Izici ezintsha ku-SQL Server 2012 - I-RC0 ikhishwe
I-Microsoft SQL Server 2012 i-RC0 isanda kukhishwa. I-RC imele ukukhishwa Ummeli okuyisisekelo ukuthi cishe ukukhiqizwa kusulungile. I-Microsoft ikhulume kulokhu kukhululwa njengekhodi ye-SQL Server ebizwa ngokuthi "iDenali" kodwa isixazulule ku-SQL Server 2012 njengegama lokugcina lomkhiqizo. I-Business intelligence (BI) ibaluleke kakhulu ezinhlanganweni zombili ezinkulu nezincane. Ekukhululweni kwamuva kwe-SQL Server, akukho ukusweleka kwezithuthukisi ze-BI ngokungeziwe kwezinye izithuthukisi eziningi.
Lesi sihloko sizokunikeza kuqala izidingo, izici ezintsha nezithuthukisi ku-SQL Server 2012 (ikhodi okuthiwa i-Denali) kufaka phakathi:
- Izidingo ze-Hardware ne-Software
- Ukuhlanganiswa kwe-Multi-Subnet Failover
- Ukuthuthukiswa kohlelo, kufaka phakathi ukulandelana, ukubuza okukhangayo ukuguqulwa kwe-paging ne-full-text tweaks
- Ukuthuthukiswa kwe-BI ne-Web Development Environment
- Ukubukwa okusekelwe kwiWebhu
- Izinsizakalo zekhwalithi yedatha
Khumbula ukuthi lolu lwazi luwukuhlola kuqala kuphela futhi luzoguqulwa yi-Microsoft.
Izidingo ze-Hardware ne-Software
- I-Microsoft ikhuthaza ukusebenzisa ifomethi yefayela le-NTFS esikhundleni se-FAT32. I-FAT32 izosebenza kepha akufanele ukuthi uyisebenzise.
- Awukwazi ukufaka i-SQL Server 2012 (i-ikhodi okuthiwa i-Denali) kuma-drive aphethwe noma ukushayela okucindezelweyo.
- Kumele ube nephakheji "engekho kabusha" efakwe ngaphambi kokufaka i-SQL Server 2012 (i-code ebizwa nge-Denali). Lokhu kufakwe ku-Windows 7 SP1 ne-Windows Server 2008 R2. Uma kungenjalo, ungalanda iphakheji elingekho kabusha kusuka ku-Microsoft.
- I-SQL Server 2012 (i-Denali ikhodi egama layo) idinga i-.NET Framework 4.0.
- I-Virtualization isekelwa ngokusebenzisa ubuchwepheshe be-Hyper-V ye-Microsoft.
- Uzodinga okungenani u-3.6 GB we-disk space space.
- I-Microsoft ikhuthaza ukuba ungafaki i-SQL Server 2012 (ikhodi okuthiwa i-Denali) kusilawuli sesizinda.
- Amaphrosesa anconyiwe ne-RAM
- I-64-bit version: AMD Opteron, AMD Athlin 64, i-Intel Xeon ne-Intel EM64T Ukusekela noma i-Intel Pentium IV enokusekela kwe-EM64T eqhuba i-2.0 GHz noma ngokushesha. I-RAM enconyiwe inqunyiwe ukuthi uhlelo lokusebenza lusekela noma okungenani u-2 GB.
- Inguqulo engu-32-bit: Pentium III noma ehambisanayo eqhutshwa ku-2.0 GHz ngokushesha. I-RAM enconyiwe inqunyiwe ukuthi uhlelo lokusebenza lusekela noma okungenani u-2 GB.
- I-Windows PowerShell 2.0 iyadingeka ngaphambi kokufaka i-SQL Server 2012 (i-code ebizwa nge-Denali). Ungathola le software kusuka kukhasi leWindows Management Framework.
Ukuhlanganiswa kwe-Multi-Subnet Failover
Nge-SQL Server 2012 (i-Denali ikhodi egama layo), ungakwazi ukumisa i-SQL Server lapho i-failover i-node yamaqoqo ingaxhumeka kunsizakalo ehluke ngokuphelele. Ama-subnets angasakazwa ezindaweni ezihlukahlukene zokuhlinzeka ngezinhlekelele nokutholakala okuphezulu. Ukuze lokhu kusebenze ngokufanele, kuzodingeka uphinde uphendule idatha yonkana yolwazi oluhilelekile kulokhu kulungiselelwa. Iqoqo le-SQL Server failover lixhomeke kwiqoqo le-Windows Server failover ukuze lokhu kusetshenziswe kuqala. Khumbula ukuthi zonke izintambo ezithintekayo kulokhu kulungiselelwa kumele zibe se-Active Directory domain efanayo.
Ukuthuthukiswa kohlelo
- Ukulandelana : Ukulandelana kuceliwe ngumphakathi we-SQL Server iminyaka, futhi kufakwe kulokhu kukhululwa. Ukulandelana kuyinto into echazwe ngumsebenzisi edala ukulandelana kwenombolo. Nasi isibonelo usebenzisa Ukulandelana.
/ ****** Dala Into Yokulandelana ****** /
DALA ISIKHATHI Sokulandelana Kwami
QALA NOMA 1
UKUTHANDISWA NGOKU-1;/ ****** Dala ithebula lesikhathi ****** /
DUMELA @Person TABLE
(
I-ID int HHAYI NULL IMPILO EYIKHULU,
I-FullName nvarchar (100) AKAZI NULL
);/ ****** Faka Ezinye Idatha ****** /
BHEKA @Person (ID, FullName)
AMALULELO (OKUQONDELEKILE NGOKUTHANDELWA KANYE NOKUPHAKATHI KWAMI, 'UJim Johnson'),
(ISIKHATHI ESILANDELAYO SOKUPHAKATHI KWAMI, 'Bob Thompson'),
(ISIKHATHI ESILANDELAYO SOKUPHAKATHI KWAMI, 'Tim Tim Perdue');/ ****** Bonisa Idatha ****** /
HLOLA * FROM @Person;Imiphumela izobukeka kanje:
ID FullName
1 UJim Johnson
2 Bob Thompson
3 Tim Perdue
- I-Ad-Hoc Umbuzo Wokumemeza: Imiphumela yokusakaza ku-SQL Server iye yaxoxwa iminyaka eminingi. I-oda Ngokukhethwa kukho kwisitatimende se-SQL SELECT sithuthukisiwe ku-SQL Server 2012. Ukusebenzisa inhlanganisela ye-OFFSET ne-FETCH kanye ne-ORDER BY ikunika ukulawula kwe-paging ngokusebenzisa isethi yemiphumela. Ukusebenzisa le nqubo kungasiza ngempela ukusebenza ngokubuyisa kuphela imiphumela ofuna ukuyikhombisa kubasebenzisi bakho uma kudingeka. Ikhodi ye-TSQL elandelayo isebenza ngokubhekene netafula lomuntu ku-database ye-AdventureWorks yesampula (etholakala ku-Microsoft). Esikhathini sempendulo yesampula ngezansi, i-SQL Server izobuyisela amarekhodi angu-10 aqala ngerekhodi 11. Umyalo we-OFFSET unikeza iphuzu lokuqala lesitatimende sokukhetha ngokulandela i-paging, futhi umyalo we-FETCH unikeza ukuthi mangaki amarekhodi azobuya ngesikhathi.
Khetha i-BusinessEntityID, FirstName, LastName
KUSUKA kumuntu
KWEBhizinisiI-IntityID
I-OFFSET 10 IZINDLELA
FUNDA OKUQUKETHWE 10 KUPHELA kuphela;
- Ukufundwa kombhalo ogcwele: Ukusesha Okugcwele Kwamagama ku-SQL Server 2012 kuye kwaphakanyiswa ngokukuvumela ukuthi useshe futhi ubhale idatha egcinwe ezakhiweni ezinwetshiwe noma emethadatha. Cabangela idokhumende ye-PDF ene "izakhiwo" ezigcwaliswe njengegama, uhlobo, ifolda, umthamo, usuku lokudalwa, njll. Ekukhululweni okusha kwe-SQL Server, le datha ingaba yizikhombo futhi isetshenziswe nedatha kulo mbhalo ngokwayo. Idatha kufanele ivezwe emsebenzini, kodwa kungenzeka manje.
Ukuthuthukiswa kwe-BI ne-Web Development Environment
I-Microsoft ihambise iBI (Business Intelligence) eduze nomsebenzisi wokugcina nge-SQL Server 2008 R2. Ithuluzi le-Excel PowerPivot lisiza abasebenzisi ngokudala imodeli yokubika eyesevisi. Izindaba ezinhle i-PowerPivot ithuthukiswa ku-SQL Server 2012 (i-Denali ikhodi okuthiwa yi-code). I-Microsoft ingeza i-KPIs iphinde ikhiphe, okuzosiza ngempela bonke abasebenzisi.
I-Analysis Services izofaka i-BI Semantic Model (BISM) entsha. I-BISM iyimodeli engu-3-ungqimba efaka:
- Isibonelo sedatha
- I-Business Logic
- Ukufinyelela kwedatha
I-BISM izokwandisa ukuhlaziywa kokuphela kweMicrosoft ekuboneni kufaka phakathi i-Excel, Imisebenzi Yokubika kanye ne-SharePoint Insights. I-Microsoft ithi i-BISM ayiyona indawo yamaModeli we-BI wamanje kodwa enye yelinye imodeli ehlukile. Ngokwemigomo elula, i-BISM iyimodeli yohlobo olubandakanya i-BI artifact njenge-KPIs nama-hierarchies.
Ukuboniswa okusekelwe kuwebhu - Iphesenti yephrojekthi
I-Project Crescent yigama lekhodi leMicrosoft yekhompyutha entsha yokubika nokubukwa okulindeleke ku-SQL Server 2012 (i-Denali ikhodi okuthiwa yi-code). I-Project Crescent inikeza ukudonsa nokuphonsa ukusebenza kombiko wokubika futhi yakhiwa ngokuphelele ku-Silverlight.
Ihlanganisa ithuluzi elinamandla lombuzo nokubhalwa kwezindaba okuhlanganyelwe ukuvumela umsebenzisi ukuthi abelane ngemiboniso yamasethi amadatha amakhulu.
Izinsizakalo zekhwalithi yedatha
Izinsizakalo Zekhwalithi Yedata yindlela yokusekela ulwazi egijima kwi-SSIS (SQL Services Integration Services). Ikhwalithi yedatha ingenye yalezo zinto ongazitholi kahle. I-Microsoft isethula "Ukuhlaziywa Kwempembelelo Nemigqa" okuzokunikeza ulwazi mayelana nokuthi idatha yakho incike kuphi. Iphinde ibonise uhlu lwemininingwane, kufaka phakathi lapho livela khona kanye nezinhlelo ezikude.