Nyob zoo, Habr! Peb ua haujlwm ntau nrog , thiab xyoo no lawv yuav - Chaw tsim tshuaj paus kev daws teeb meem rau kev tswj hwm thiab saib xyuas Microsoft SQL Server databases. Nyob rau hauv Russia, nws zoo li rau peb, me ntsis paub txog cov hais mav. Ntawm nplooj ntawv tseem ceeb ntawm lawv lub vev xaib lawv sau "Killer tools for SQL Server". Suab hem. Peb muaj lub tswv yim los qhia tus neeg muag khoom no thiab xyuas seb qhov twg yog qhov ua rau tuag taus ntawm lawv cov kev daws teeb meem. Cia peb pib nrog qhov hype - khoom pub dawb. Tom qab lawv yuav muaj ib feem luv luv txog cov khoom lag luam. Kuv vam tias koj pom cov kev pab cuam no pab tau. Thov sub miv.
Hauv tsab xov xwm no:
- - ib qho cuab yeej rau kev sib piv SQL code, cov ntaub ntawv thiab folders. Ua haujlwm kuj yog qhov txuas ntxiv rau SSMS lossis Visual Studio.
- - kwj decryption ntawm cov khoom hauv SQL Server: cov txheej txheem, kev ua haujlwm, ua rau thiab pom. Ua haujlwm kuj yog qhov txuas ntxiv rau SSMS lossis Visual Studio.
- - kuaj pom ntawm SQL Server piv txwv thiab cov kev pabcuam cuam tshuam SSRS, SSAS thiab SSIS.
- - lub cuab yeej rau refactoring thiab formatting SQL code. Ua haujlwm ua qhov txuas ntxiv rau SSMS lossis Visual Studio.
- - tsim SQL Server object diagrams. Ua haujlwm kuj yog qhov txuas ntxiv rau SSMS lossis Visual Studio.
- - ib lub cuab yeej rau optimizing Execution plan. Ua haujlwm kuj yog qhov txuas ntxiv rau SSMS.
- - lub cuab yeej cia li ua tiav SQL nqe lus thiab tso cai rau koj ntxiv koj tus kheej snippets (keyboard shortcuts rau autocompletion). Ua haujlwm kuj yog qhov txuas ntxiv rau SSMS lossis Visual Studio.
- - ib qho cuab yeej rau kev ua tiav SQL code ntawm ntau lub databases ib zaug.
- - qhov khoom siv rau kev tshawb nrhiav cov ntaub ntawv thiab cov khoom hauv qhov tob ntawm SQL Server. Ua haujlwm raws li kev txuas ntxiv rau SSMS lossis Visual Studio.
- - ib qho cuab yeej los tsim cov kav dej CI/CD. Tsuas yog ib qho ntawm tag nrho cov khoom uas tau teev tseg ntawm no muaj lub vev xaib console.
Txhua yam khoom yog ib feem ntawm kev ua haujlwm ntawm ApexSQL cov kev daws teeb meem them nyiaj. Thaum kawg ntawm tsab xov xwm peb yuav piav qhia luv luv txog cov kev lag luam uas lawv muaj.
Cov yeeb yaj kiab luv luv txog kev ua haujlwm thiab kev muaj peev xwm
Sib piv cia koj sib piv SQL Server cov ntaub ntawv, folders, thiab khoom. Kev sib piv bidirectional thiab lwm tiam ntawm ib tsab ntawv rau kev sib koom ua ke cov khoom sib txawv tau txais kev txhawb nqa. Nyob rau hauv lub interface, cov nqi hluav taws xob tuaj yeem hais txog cov syntax ntawm C #, C ++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML.
Cov yam ntxwv tseem ceeb: kev koom ua ke rau hauv SSMS thiab Visual Studio, hu cov khoom los ntawm cov ntaub ntawv sib txawv rau kev sib piv ncaj qha los ntawm Object Explorer thiab .
Cov yeeb yaj kiab luv luv txog kev ua haujlwm thiab kev muaj peev xwm
Hauv Decryption, los ntawm SSMS lossis Visual Studio interface, koj tuaj yeem decrypt cov txheej txheem, ua haujlwm, ua rau lossis saib hauv ib nias.
Hauv qhov interface koj tuaj yeem saib DDL tsab ntawv decryption. Kev sib txuas ib txhij rau ntau zaus ntawm SQL Server tau txais kev txhawb nqa.
Txheeb xyuas qhov xwm txheej uas twb muaj lawm ntawm SQL Server, SSRS, SSAS thiab SSIS cov kev pabcuam los ntawm IP chaw nyob thiab saib cov ntaub ntawv ntxaws.
Los ntawm lub interface koj tuaj yeem teeb tsa cov ntaub ntawv tshawb pom ntawm lub sijhawm. ApexSQL Discover tuaj yeem xa cov ntawv ceeb toom nrog kev tshawb pom los ntawm email.
Cov yeeb yaj kiab luv luv txog kev ua haujlwm thiab kev muaj peev xwm
Code formatting tuaj yeem ua tiav raws li lub thawv profile lossis koj tuaj yeem kho koj tus kheej kom tus lej zoo dua rau koj paub. Refactor tuaj yeem hais txog qhov hloov pauv tsis tau siv hauv cov lej, encapsulate code blocks rau hauv cov txheej txheem, thiab nthuav "*" rau hauv cov npe ua tiav.
Ib qho txiaj ntsig zoo yog kev faib cov lus kom cais tawm cov kab uas siv tsawg tshaj plaws. Refactor yuav tshaj tawm cov khoom uas yuav cuam tshuam los ntawm kev sib cais no.
Tsis tas li ntawd hauv Refactor interface koj tuaj yeem hloov pauv cov npe ntawm cov khoom yam xyuam xim thaum hloov tag nrho cov kev vam meej.
Cov no thiab lwm yam haujlwm tuaj yeem pom nyob rau hauv kev nthuav dav ntxiv ntawm nplooj ntawv nrog .
Cov khoom siv hluav taws xob pom SQL Server cov khoom thiab kev sib raug zoo ntawm lawv. Nyob rau hauv tib lub interface, koj tuaj yeem hloov qhov teeb tsa ntawm cov khoom thiab tsim cov lej DDL sib raug. Txhua qhov kev pom pom tuaj yeem raug xa tawm raws li cov duab.
Cov qauv ua haujlwm tau nthuav dav nrog kev pab ntawm cov khoom lag luam ΠΈ . Siv cov khoom lag luam thawj zaug, koj tuaj yeem sib piv cov qauv nrog lub xeev tam sim no hauv cov ntaub ntawv los yog sib piv cov qauv ntawm ob qhov sib txawv databases, thiab cov khoom thib ob yog xav tau los sau cov khoom database.
Cov yeeb yaj kiab luv luv txog kev ua haujlwm thiab kev muaj peev xwm
Qhov no yog ib qho cuab yeej optimization kev ua tau zoo. Tsis tas li, siv ApexSQL Plan, koj tuaj yeem xa tawm cov phiaj xwm rau cov ntawv ceeb toom hauv HTML thiab XML hom. Ib qho kev siv ntau zaus rau cov khoom siv hluav taws xob no yog qhov sib piv ntawm cov phiaj xwm tam sim no thiab ib qho hloov kho raws li ntau yam ntxwv.
ApexSQL Plan txhawb nqa rub tawm los ntawm lub khw nug thiab nthuav qhia cov yam ntxwv ntawm cov lus nug no hauv daim ntawv dashboards.
Cov yeeb yaj kiab luv luv txog kev ua haujlwm thiab kev muaj peev xwm
Code accelerator. Hauv kev siv hluav taws xob interface koj tuaj yeem teeb tsa lub npe npe, snippets thiab code highlighting.
Hauv ApexSQL Propagate, koj tuaj yeem teeb tsa kev ua tiav ntawm ntau yam SQL Server databases thiab txiav txim siab qhov kev txiav txim.
Cov txiaj ntsig ntawm cov lej ua tiav raug txheeb xyuas los ntawm kev siv hluav taws xob thiab sau tseg kom yooj yim saib cov txiaj ntsig ntawm kev tua.
Cov yeeb yaj kiab luv luv txog kev ua haujlwm thiab kev muaj peev xwm
Cov cuab yeej tshawb nrhiav cov qauv database. Los ntawm no koj tuaj yeem muaj kev nyab xeeb hloov npe cov khoom thiab taug qab lawv cov kev sib raug zoo. Cov txiaj ntsig tshawb tau raug xa tawm mus rau HTML, CSV thiab Excel.
Cov yeeb yaj kiab luv luv txog kev ua haujlwm thiab kev muaj peev xwm
PowerShell code khiav hauv qab lub hood ntawm cov khoom siv hluav taws xob. Tsim, tshuaj xyuas, Cov ntaub ntawv thiab xa tawm muaj rau tus tsim tawm los ntawm ApexSQL DevOps Toolkit interface. Ntawm no koj tuaj yeem tsim cov ntaub ntawv hluavtaws, cia li khiav cov ntawv xeem, thiab cov ntaub ntawv hloov pauv. Nws tuaj yeem txuas nrog lub plugin rau TeamCity, Jenkins thiab lwm yam.
ApexSQL paub lub hauv paus muaj ntawm DevOps hauv ib puag ncig database.
Tam sim no peb tau daws cov kev daws teeb meem dawb, peb yuav luv luv muab cov npe ntawm cov kev daws teeb meem them nyiaj, uas, tau kawg, muaj kev ua haujlwm muaj zog dua.
- - ib lub cuab yeej rau kev tshuaj xyuas cov ntaub ntawv rau kev ua raws li kev ruaj ntseg, incl. HIPAA, GDPR, PCI txhawb nqa. Cov ntawv ceeb toom thiab saib cov keeb kwm hloov pauv tau txais kev txhawb nqa.
Saib screenshot thiab video
- - automation ntawm tsim incremental backups, muas cav thiab tag nrho backups. Rov qab mus rau qhov tshwj xeeb hauv lub sijhawm tau txais kev txhawb nqa, koj tuaj yeem tsim cov qauv tsim cov thaub qab thiab hloov kho cov phiaj xwm thaub qab.
Saib screenshot thiab video
- - ib qho khoom siv rau kev saib xyuas thiab tswj kev defragmentation.
Saib screenshot thiab video
- - lub cuab yeej rau kev tswj cov dej num, suav nrog keeb kwm, lub sijhawm thiab cov ntawv ceeb toom.
Saib screenshot
- - ib lub cuab yeej rau kev nyeem cov ntawv sib pauv rau kev tshuaj xyuas, rov ua dua lossis rov qab hloov pauv.
Saib screenshot thiab video
- - rov qab cov ntaub ntawv puas, deleted lossis ploj.
Saib screenshot thiab video
- - ib qho cuab yeej rau kev txheeb xyuas kev sib raug zoo hauv cov ntaub ntawv.
Saib screenshot thiab video
- - ib lub cuab yeej rau automating database creation. Yuav txuas mus rau version tswj systems.
Saib screenshot thiab video
- - SQL code txhim kho.
Saib screenshot thiab video
- yog ib lub cuab yeej los tsim ntau lab kab ntawm cov ntaub ntawv hauv ib nias. Export cov ntaub ntawv xeem rau SQL, XML, CSV, JSON thiab Excel tau txais kev txhawb nqa.
Saib screenshot
- - lub cuab yeej rau kev tshawb nrhiav, faib thiab npog cov ntaub ntawv rhiab hauv cov ntaub ntawv. Muaj 220+ lub qhov ncauj qhov ntswg predefined thiab 55+ built-in lim rau kev faib tawm.
Saib screenshot
- - ib qho cuab yeej los tsim DDL thiab DML cov ntawv sau thiab cov pob khoom siv tau ua tiav.
Saib screenshot thiab video
- - ib qho cuab yeej rau kev sib koom ua ke ntawm kev tswj hwm version nrog SSMS.
Saib screenshot thiab video
- - Kev tshuaj xyuas cov ntaub ntawv hauv database thiab txhais ua DML.
Saib screenshot thiab video
- - ib lub cuab yeej rau kev khiav chav ntsuas ncaj qha los ntawm SSMS console.
Saib screenshot thiab video
Sau rau hauv cov lus hais tias cov cuab yeej rau kev tshuaj xyuas thiab kev tswj xyuas cov ntaub ntawv koj twb tau siv thiab cov teeb meem dab tsi koj daws nrog lawv.
Txhawm rau nug cov lus nug txog ApexSQL cov khoom lag luam, tau txais cov khoom lag luam rau kev sim, lossis nrhiav tus nqi, tawm hauv kev thov .
Yog tias koj tab tom daws qhov teeb meem nyuaj ntawm kev saib xyuas thiab kev tswj hwm, nyeem peb cov lus dhau los ntawm HabrΓ©:
Koj tseem tuaj yeem sau npe rau peb .
Tau qhov twg los: www.hab.com