Izinto ezintsha kwiSQL Server 2012 -RC0 ikhutshwe
I-Microsoft SQL Server 2012 iRC0 yakhululwa. I-RC imele umPhumeleli wokuKhululwa okuyiyona nto inguqulelo olusondeleyo lwemveliso. IMicrosoft ibhekisele kulokhu kukhululwa njengeSQL Server Code ebizwa ngokuthi "iDenali" kodwa ihleli kwiSQL Server 2012 njengegama lokugqibela lemveliso. I-Intelligence Intelligence (BI) ibaluleke kakhulu kwimibutho emibini ibe yincinci. Ekukhutshulweni kwamuva kweSQL Server, akukho nqongophala yongqinisiso lwe-BI ukongezelela kwezinye izinto ezongezelelweyo.
Eli nqaku liza kukunika umboniso weemfuno, iimpawu ezintsha kunye nokuphucula kwi-SQL Server 2012 (ikhowudi egama linguDenali) kuquka:
- Izixhobo zeFayilithi kunye neNkqubo zeSofthiwe
- Iqoqo le-Multi-Subnet Failover Clustering
- Ukuphuculwa kweeNkqubo, kubandakanywa ukulandelelana, umbuzo osisigxina kwi-paging kunye ne-full-text search tweaks
- Ukuphuculwa kweNgingqi ye-BI kunye noPhuhliso lweWebhu
- Ukubonakalisa okusekelwe kwiWebhu
- IiNkonzo zeMigangatho yoLwazi
Gcina ukhumbule ukuba olu lwazi luyi-preview kuphela kwaye luya kutshintsha nguMicrosoft.
Izixhobo zeFayilithi kunye neNkqubo zeSofthiwe
- UMicrosoft uncoma ukusebenzisa ifom yefayile ye-NTFS esikhundleni se-FAT32. I-FAT32 iya kusebenza kodwa akufanele ukuba uyisebenzise.
- Awukwazi ukufaka i-SQL Server 2012 (ikhowudi egama linguDenali) kwiimoto ezifakwe kwimephu okanye ukuqhutyelwa.
- Kufuneka ube nephakheji ye "akukho-reboot" efakwe ngaphambi kokufaka i-SQL Server 2012 (ikhowudi egama linguDenali). Oku kufakwe kwi-Windows 7 SP1 kunye neWindows Server 2008 R2. Ngaphandle koko, unokukhupha iphakheji yokuqalisa ngaphandle kweMicrosoft.
- I-SQL Server 2012 (ikhowudi egama linguDenali) idinga i-.NET Framework 4.0.
- Ukutshintshisiswa kwenkxaso kuxhaswa usebenzisa i-Microsoft Hyper-V technology.
- Uya kuyimfuneko ubuncinane 3.6 GB yesithuba sediski samahhala.
- UMicrosoft uncoma ukuba ungafaki i-SQL Server 2012 (ikhowudi egama linguDenali) kumlawuli wesizinda.
- Iiprojekithi ezikhuthaziweyo kunye ne-RAM
- I-64-bit version: AMD Opteron, AMD Athlin 64, i-Intel Xeon nge-Intel EM64T inkxaso okanye i-Intel Pentium IV ene-EM64T inkxaso eqhuba i-2.0 GHz okanye ngokukhawuleza. I-RAM ephakanyisiweyo yinkqantosi yokuba inkqubo yokusebenza isekela okanye ubuncinane i-2 GB.
- I-32-bit version: I-Pentium III okanye isebenza ngokufanelekileyo kwi-2.0 GHz ngokukhawuleza. I-RAM ephakanyisiweyo yinkqantosi yokuba inkqubo yokusebenza isekela okanye ubuncinane i-2 GB.
- I-PowerShell 2.0 ye-Windows iyimfuneko ebalulekileyo yokufaka i-SQL Server 2012 (igama elibizwa ngokuba nguDenali). Unokufumana le software kwiWindows Framework page.
Iqoqo le-Multi-Subnet Failover Clustering
Nge-SQL Server 2012 (ikhowudi egama linguDenali), ungayilungisa i-SQL Server apho i-node cluster nodes ingaxhunyezwa kwi-subnet ehlukileyo ngokupheleleyo. Iingqungquthela zingasasazeka kwiindawo ezahlukeneyo zokubonelela ngeentlekele kunye nokufumaneka okuphezulu. Ukuze le nto isebenze ngokuchanekileyo, kuya kufuneka uphinde uphendule idatha kwiinkcukacha ezichaphazelekayo kule miselo. Iqoqo le-failover le-SQL Server lixhomekeke kwiqoqo le-Windows Server failover ukuze oko kusetyenziswe kuqala. Gcina ukhumbule ukuba zonke ii-subnets ezithintekayo kulo miselo kufuneka zibe kwi-Domain Directory efanayo.
Ukuphuculwa kweeNkqubo
- Ukulandelelana : Ukulandelelana kuceliwe ngumphakathi we-SQL Server iminyaka, kwaye ifakiwe kulokhu kukhutshwa. Ukulandelelana yinto echazwe ngumsebenzisi eyenza ukulandelelana kwenani. Nasi umzekelo usebenzisa ukulandelelana.
/ ****** Yenza into yokulandelelana ****** /
YOKUKHALA ISICWANGCISO seMpawu
QALISA NO 1
UKUQHUBA NGOKUBA 1;/ ****** Yakha Itheyibhile Yesikhashana ****** /
SIKHULULELA @Person TABLE
(I
Inombolo ye-ID engekho i-NULL IPRAYIMARI EYIQINISO,
FullName nvarchar (100) AKUKHO NULL
);/ ****** Faka ezinye iinkcukacha ****** /
BHALA @Person (ID, FullName)
AMANQAKU (ISILANDELO ESILANDELAYO NGAMALANDELO ANGI, 'UJim Johnson'),
(ISILANDELO ESILANDELAYO NGAMANQAKUFUYO, 'UBob Thompson'),
(ISILANDELO ESILANDELAYO NGAMIQULOMELO, 'Tim Tim Perdue');/ ****** Bonisa iData ****** /
UKUHLOLA * FROM @Person;Iziphumo ziya kubonakala ngathi:
ID FullName
1 UJim Johnson
2 Bob Thompson
3 Tim Perdue
- I-Ad-Hoc Umbuzo oPhezulu: Iziphumo zokupasa kwiSQL Server sele zixutyushwa iminyaka. I-Order ngokukhetha kwi-SQL SELECT inkcazo iye yaphuculwa kwi-SQL Server 2012. Ukusebenzisa udibaniso lwe-OFFSET kunye ne-FETCH kunye ne-ORDER BY kukunika ulawulo lwe-paging ngokusebenzisa isethi yemiphumo. Ukusebenzisa olu buchule lunokunceda ngokwenene ukusebenza ngokubuyisela kuphela iziphumo ofuna ukubonisa kubasebenzisi bakho xa zifuneka. Ikhowudi ye-TSQL elandelayo isebenza ngokubhekiselele kwitafile yomntu kwi-database ye-AdventureWorks yesampula (efumaneka kwi-Microsoft). Kwimbuzo yesampuli ngezansi, iSQL Server iya kubuya iirekhodi ezili-10 ziqala ngerekhodi 11. Umyalelo we-OFFSET unikezela iqela lokuqala kweSETYENZO ngokwemigqaliselo ye-paging, kwaye umyalelo we-FETCH unikezela ukuba ziphi iirekhodi zokubuyela ngexesha.
Khetha i-BusinessEntityID, FirstName, LastName
KUSUKA KUNYE
UKUSETYENZISWA KWEBANZII-IntityID
KWI-OFFSET 10
FUNDA IINGCANDELO 10 ZIQALA;
- Uphando olupheleleyo lweTekisi: Ukukhangela kwimixholo epheleleyo kwiSQL Server 2012 kuye kwaphuculwa ngokukuvumela ukuba uphendule kwaye ulandele idatha egcinwe kwiipropati ezide okanye imethadatha. Khawucinge ngomqulu we PDF onawo "iipropati" ezizaliswe njengegama, Uhlobo, Uhlobo, Ifolda, Uluhlu, Umhla oDalwe, njl. Kokukhutshwa okutsha kweSQL Server, le datha ingaba yi-indexes kwaye iphandwe kunye nedatha kwincwadi ngokwayo. Idatha kufuneka ibonakaliswe emsebenzini, kodwa kunokwenzeka ngoku.
Ukuphuculwa kweNgingqi ye-BI kunye noPhuhliso lweWebhu
UMicrosoft wathutha iBI (iBusiness Intelligence) kufuphi nomsebenzisi wokugqibela kunye neSQL Server 2008 R2. Isixhobo se-Excel PowerPivot sinceda abasebenzisi ngokudala imodeli yokunika ingxelo yokuzimela. Iindaba ezilungileyo i-PowerPivot iyakhuliswa kwi-SQL Server 2012 (igama elibizwa ngokuba yiDenali). IMicrosoft yongeza ii-KPIs kunye nokugqithisa, okuya kuba luncedo kubo bonke abasebenzisi.
IiNkonzo zoHlolo ziza kubandakanya i-BI Semantic Model (BISM) entsha. I-BISM iyimodeli engama-3 equka:
- Umzekelo weDatha
- Logic Logic
- Ukufikelela kwedatha
I-BISM iya kuphucula ukuhlaziywa kokugqibela kweMicrosoft okubandakanya i-Excel, IiNkonzo zokuBala kunye ne-SharePoint Insights. UMicrosoft uthe iBISM ayiyiyo indawo yeeModeli zeBI zangoku kodwa enye enye imodeli. Ngendlela elula, i-BISM imodeli yobudlelwane obandakanya i-BI yokusebenza njengama-KPIs kunye nama-hierarchies.
Ukubonakaliswa kweWebhu-Based Crescent
Ikhefu leProjekthi yigama lekhodi yeMicrosoft yezoxhobo ezintsha zokubhengezwa kunye nokuboniswa kulindeleke kwi-SQL Server 2012 (igama elibizwa ngokuba yiDenali). I-Prorescent Project inikeza idonsa kwaye idibanise ukusebenza komsebenzi wokubika kwaye yakhiwe ngokupheleleyo kwi-Silverlight.
Iquka ithuluzi elinamandla lombuzo kunye nebhodi lokubhala ibali lokudibanisa ukuvumela umsebenzisi ukwabelana ngeembonakalo zeedasethi ezinkulu.
IiNkonzo zeMigangatho yoLwazi
Iinkonzo zoLwazi lweNgcaciso yindlela ejoliswe kulwazi eqhuba kwi-SSIS (iiNkonzo ze-Integration Services Services SQL). Ubunjani beenkcukacha ngenye yezinto ongeke uphelele. UMicrosoft uzisa "Uhlalutyo lwempembelelo kunye nomgca" oza kukunika ulwazi malunga nokuba idatha yakho ixhomekeke kuyo. Kwakhona kubonisa umgca wolwazi, kubandakanywa apho livela khona kunye neendlela ezikuso.