Moni, Habr! Timagwira nawo ntchito kwambiri , ndipo chaka chino anagula - wopanga mayankho pakuwongolera ndi kuyang'anira nkhokwe za Microsoft SQL Server. Ku Russia, zikuwoneka kwa ife, zochepa zomwe zimadziwika za anyamata awa. Patsamba lalikulu la tsamba lawo amalemba "Killer zida za SQL Server". Zikumveka zowopseza. Tinali ndi lingaliro loti tidziwitse wogulitsa uyu ndikuwona zomwe zili zakupha kwambiri pamayankho awo. Tiyeni tiyambe ndi gawo la hype - zinthu zaulere. Pambuyo pawo padzakhala gawo laling'ono lazinthu zamalonda. Ndikukhulupirira kuti mapulogalamuwa ndi othandiza. Chonde pansi pa mphaka.
M'nkhaniyi:
- - chida chofanizira ma code a SQL, mafayilo ndi zikwatu. Imagwiranso ntchito ngati chowonjezera cha SSMS kapena Visual Studio.
- - Kutsitsa kwazinthu mu SQL Server: njira, ntchito, zoyambitsa ndi mawonedwe. Imagwiranso ntchito ngati chowonjezera cha SSMS kapena Visual Studio.
- - kuzindikira zochitika za SQL Server ndi ntchito zina zofananira SSRS, SSAS ndi SSIS.
- - chida chosinthira ndikusintha kachidindo ka SQL. Imagwira ntchito ngati chowonjezera cha SSMS kapena Visual Studio.
- - kupanga zithunzi za SQL Server. Imagwiranso ntchito ngati chowonjezera cha SSMS kapena Visual Studio.
- - chida chokometsera mapulani a Ntchito. Imagwiranso ntchito ngati chowonjezera cha SSMS.
- - chidachi chimangomaliza mawu a SQL ndikukulolani kuti muwonjezere mawu anuanu (mafupipafupi a kiyibodi kuti mumalize zokha). Imagwiranso ntchito ngati chowonjezera cha SSMS kapena Visual Studio.
- - chida chochitira SQL code pamasamba angapo nthawi imodzi.
- - chida chofufuzira deta ndi zinthu mkati mwa SQL Server. Imagwira ntchito ngati chowonjezera cha SSMS kapena Visual Studio.
- - chida chopangira mapaipi a CI/CD. Chimodzi mwazinthu zonse zomwe zalembedwa apa chili ndi web console.
Chida chilichonse ndi gawo la magwiridwe antchito a ApexSQL omwe amalipira. Kumapeto kwa nkhaniyi tidzalongosola mwachidule zomwe zili ndi malonda omwe ali nawo.
Kanema waufupi wokhudza momwe ntchito imagwirira ntchito komanso kuthekera
Fananizani amakulolani kufananiza mafayilo a SQL Server, zikwatu, ndi zinthu. Kufananitsa kwapawiri komanso kukulitsa zolembedwa zophatikiza zinthu zosiyanasiyana kumathandizidwa. Pamawonekedwe, chidachi chimatha kuwunikira ma syntax a C #, C ++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML.
Zofunika kwambiri: kuphatikiza mu SSMS ndi Visual Studio, kuyimbira zinthu kuchokera kumitundu yosiyanasiyana ya database kuti mufananize mwachindunji ndi Object Explorer ndi .
Kanema waufupi wokhudza momwe ntchito imagwirira ntchito komanso kuthekera
Mu Decrypt, kuchokera pa mawonekedwe a SSMS kapena Visual Studio, mutha kutsitsa ndondomeko, ntchito, kuyambitsa kapena kuwona ndikudina kamodzi.
Mu mawonekedwe mungathe kuona DDL decryption script. Kulumikizana nthawi imodzi kuzinthu zingapo za SQL Server kumathandizidwa.
Dziwani zomwe zilipo kale za SQL Server, SSRS, SSAS ndi SSIS potengera ma adilesi a IP ndikuwona zambiri.
Kuchokera pamawonekedwe mutha kukonza kupezeka kwa database pa ndandanda. ApexSQL Discover ikhoza kutumiza zidziwitso ndi zotsatira zopezeka ndi imelo.
Kanema waufupi wokhudza momwe ntchito imagwirira ntchito komanso kuthekera
Kupanga ma code kutha kupangidwa potengera mbiri yomwe ili m'bokosi kapena mutha kusintha yanu kuti codeyo iwonekere yodziwika bwino kwa inu. Refactor imatha kuwunikira zosintha zosagwiritsidwa ntchito pamakhodi, kuyika ma code code munjira, ndikukulitsa "*" pamndandanda wathunthu.
Chinthu chimodzi chothandiza ndikugawanika kwa tebulo kuti mulekanitse mizati yosagwiritsidwa ntchito kwambiri. Refactor ifotokoza zinthu zomwe zidzakhudzidwe ndi kugawanika uku.
Komanso mu mawonekedwe a Refactor mutha kusintha mosamala mayina azinthu pomwe mukusintha zodalira zonse.
Izi ndi ntchito zina zitha kupezeka mwatsatanetsatane patsamba ndi .
Zomwe zimagwiritsidwa ntchito zimawonera zinthu za SQL Server ndi maubwenzi pakati pawo. Mu mawonekedwe omwewo, mutha kusintha masinthidwe azinthu ndikupanga code yofananira ya DDL. Zowoneka zonse zitha kutumizidwa kunja ngati zithunzi.
Kugwira ntchito kwachitsanzo kumakulitsidwa mothandizidwa ndi zinthu zamalonda ΠΈ . Pogwiritsa ntchito chinthu choyamba, mutha kufananiza choyimira ndi momwe zilili pano mu nkhokwe kapena kufananiza mitundu yamitundu iwiri yosiyana, ndipo chachiwiri chikufunika kuti mulembe zinthu za database.
Kanema waufupi wokhudza momwe ntchito imagwirira ntchito komanso kuthekera
Ichi ndi chida chokometsera ntchito. Komanso, pogwiritsa ntchito ApexSQL Plan, mutha kutumiza mapulani ku malipoti amtundu wa HTML ndi XML. Kugwiritsidwa ntchito pafupipafupi kwa izi ndikufanizira dongosolo lomwe lilipo komanso kusinthidwa malinga ndi mawonekedwe osiyanasiyana.
ApexSQL Plan imathandizira kutsitsa kuchokera ku sitolo yamafunso ndikuwonetsa mawonekedwe a mafunsowa ngati ma dashboards.
Kanema waufupi wokhudza momwe ntchito imagwirira ntchito komanso kuthekera
Kodi accelerator. Mu mawonekedwe ogwiritsira ntchito mutha kusintha ma aliases, ma snippets ndikuwonetsa ma code.
Mu ApexSQL Propagate, mutha kukhazikitsa ma code pamasamba osiyanasiyana a SQL Server ndikuzindikira dongosolo la kuphedwa.
Zotsatira za code yomwe yachitidwa imagawidwa ndi zofunikira ndikujambulidwa kuti muwone mosavuta zotsatira za kuphedwa.
Kanema waufupi wokhudza momwe ntchito imagwirira ntchito komanso kuthekera
Chidachi chimafufuza kapangidwe ka database. Kuchokera apa mutha kutchulanso zinthu mosamala ndikutsata maubale awo. Zotsatira zakusaka zimatumizidwa ku HTML, CSV ndi Excel.
Kanema waufupi wokhudza momwe ntchito imagwirira ntchito komanso kuthekera
Nambala ya PowerShell imayenda pansi pa hood. Mangani, Unikaninso, Zolemba ndi Kutumiza zilipo kwa wopanga kuchokera pa mawonekedwe a ApexSQL DevOps Toolkit. Apa mutha kupanga data yopangira, kuyesa kuyesa mayunitsi, ndikusintha zolemba. Itha kulumikizidwa ngati pulogalamu yowonjezera ku TeamCity, Jenkins ndi ena.
Maziko a chidziwitso cha ApexSQL ali pa DevOps mu database.
Tsopano popeza tathana ndi mayankho aulere, tidzapereka mwachidule mndandanda wa mayankho olipidwa, omwe, ndithudi, ali ndi ntchito zamphamvu kwambiri.
- - chida chowunikira nkhokwe kuti zigwirizane ndi zofunikira zachitetezo, kuphatikiza. HIPAA, GDPR, PCI imathandizidwa. Malipoti ndi kuwona mbiri yakusintha kumathandizidwa.
Onani skrini ndi kanema
- - makina opanga ma backups owonjezera, zipika zogulira ndi zosunga zobwezeretsera zonse. Bwezerani kumalo enaake pakanthawi kumathandizidwa, mutha kupanga ma tempuleti opangira zosunga zobwezeretsera ndikusintha mapulani osunga zobwezeretsera.
Onani skrini ndi kanema
- - chida chowunikira ndi kuyang'anira defragmentation.
Onani skrini ndi kanema
- - chida chowongolera ntchito, kuphatikiza mbiri, ndandanda ndi zidziwitso.
Onani skrini
- - chida chowerengera chipika chowerengera, kubwereza kapena kubweza zosintha.
Onani skrini ndi kanema
- - kubwezeretsa deta yowonongeka, yochotsedwa kapena yotayika.
Onani skrini ndi kanema
- - chida chowunikira maubwenzi mu nkhokwe.
Onani skrini ndi kanema
- - chida chothandizira kupanga database. Itha kulumikizidwa ku machitidwe owongolera mtundu.
Onani skrini ndi kanema
- - Kuwongolera ma code a SQL.
Onani skrini ndi kanema
- ndi chida chopangira mamiliyoni amizere ya data pakadina kamodzi. Kutumiza kwa data yoyeserera ku SQL, XML, CSV, JSON ndi Excel kumathandizidwa.
Onani skrini
- - chida chofufuzira, kuyika m'magulu ndi kubisa zidziwitso zachinsinsi mu database. Ili ndi masks 220+ omwe adafotokozedweratu ndi zosefera 55+ zomangidwa kuti zigawidwe.
Onani skrini
- - chida chopangira zolemba za DDL ndi DML ndi phukusi lokhazikika.
Onani skrini ndi kanema
- - chida chophatikizira machitidwe owongolera ndi SSMS.
Onani skrini ndi kanema
- - Kusanthula kwa data mu nkhokwe ndikumasulira mu DML.
Onani skrini ndi kanema
- - chida choyesera mayunitsi molunjika kuchokera ku kontrakitala ya SSMS.
Onani skrini ndi kanema
Lembani m'mawu anu zida zowunikira ndi kuyang'anira nkhokwe zomwe mumagwiritsa ntchito kale ndi mavuto omwe mumathetsa nawo.
Kuti mufunse mafunso okhudza malonda a ApexSQL, landirani malonda kuti muyesedwe, kapena mudziwe mtengo wake, siyani pempho .
Ngati mukuthana ndi vuto lowunikira ndikuwongolera, werengani zolemba zathu zam'mbuyomu za HabrΓ©:
Mukhozanso kulembetsa ku wathu .
Source: www.habr.com