Nhazi ọhụrụ na SQL Server 2012 - RC0 Released
A tọhapụrụ Microsoft SQL Server 2012 RC0 n'oge na-adịbeghị anya. RC na-anọchite anya Hapụ onye omempụ nke bụ isi na mbipute fọrọ nke nta ka ọ bụrụ mmepụta ngwa ngwa. Microsoft zoro aka na ntọhapụ a dị ka SQL Server Usoro akpọ "Denali" mana ọ nọkwasịrị na SQL Server 2012 dị ka aha ikpeazụ maka ngwaahịa ahụ. Nghọta azụmahịa (BI) dị oke mkpa maka òtù ma nnukwu ma obere. Na ntọhapụ nke SQL Server, enweghi ụkọ nkwalite BI na mgbakwunye na ọtụtụ nkwalite ndị ọzọ.
Isiokwu a ga - enye gị ọkwa nke ihe ndị a chọrọ, atụmatụ ọhụrụ na nkwalite na SQL Server 2012 (koodu aha ya bụ Denali) gụnyere:
- Ngwanrọ na Nchọpụta Software
- Multi-Subnet Failover Clustering
- Mmezi mmemme, tinyere usoro, ad-hoc query paging na search tweaks
- BI na Web Development Environment Improvements
- Ihe ntanetị nke Web
- Ọrụ Ogo Ngosipụta
Buru n'uche na ozi a bụ maka nhụchalụ naanị na ọ bụ ihe gbanwere na Microsoft.
Ngwanrọ na Nchọpụta Software
- Microsoft na-atụ aro iji nchịkọta faịlụ NTFS kama FAT32. FAT32 ga-arụ ọrụ kama ị ga-enwe ike ghara iji ya.
- Ị nweghị ike ịwụnye SQL Server 2012 (koodu-aha ya bụ Denali) na mpempe akwụkwọ mapped ma ọ bụ draịva draịva.
- Ị ghaghị ịnweta ngwugwu "enweghị-reboot" tupu ịwụnye SQL Server 2012 (koodu-aha ya bụ Denali). Nke a gụnyere na Windows 7 SP1 na Windows Server 2008 R2. Ma ọ bụghị ya, ị nwere ike ibudata ngwugwu nwube na Microsoft.
- SQL Server 2012 (koodu-aha ya bụ Denali) chọrọ NET Framework 4.0.
- A na-akwado Virtualization site na iji teknụzụ Hyper-V Microsoft.
- Ị ga-achọ ma ọ dịkarịa ala 3,6 GB nke ohere disk ohere.
- Microsoft na-akwado ka ị ghara itinye SQL Server 2012 (koodu-aha ya bụ Denali) na onye na-elekọta ngalaba.
- Na-atụ aro Processors & Ram
- 64-bit version: AMD Opteron, AMD Athlin 64, Intel Xeon na Intel EM64T Nkwado ma ọ bụ Intel Pentium IV na EM64T nkwado ọsọ 2.0 GHz ma ọ bụ ngwa ngwa. Akwadora RAM kachasị na usoro nhazi na-akwado ma ọ bụ na ọ dịkarịa ala 2 GB.
- 32-bit version: Pentium III ma ọ bụ arụmọrụ na-agba ọsọ na 2.0 GHz nke ngwa ngwa. Akwadora RAM kachasị na usoro nhazi na-akwado ma ọ bụ na ọ dịkarịa ala 2 GB.
- Windows PowerShell 2.0 bụ ihe dị mkpa maka ịwụnye SQL Server 2012 (koodu-aha ya bụ Denali). Ị nwere ike nweta software a site na Windows Management Framework page.
Multi-Subnet Failover Clustering
Na SQL Server 2012 (koodu-aha ya bụ Denali), ị nwere ike ịhazi SQL Server ebe a na-ejikọta ụyọkọ ụyọkọ ụyọkọ ọnụ na netwọk kpamkpam. Enwere ike gbasaa mpaghara ebe dị iche iche na-enye mgbake ọdachi na oke dị elu. Iji mee nke a ka ọ rụọ ọrụ n'ụzọ ziri ezi, ị ga-achọ ịmegharị data ahụ n'ofe databasịnụ gụnyere nhazi a. Fluster failover SQL Server na-adabere na ụyọkọ ntanetị Windows Server nke a ga-ebute ụzọ. Buru n'uche na ihe niile edere na nhazi a ga-abụ otu Active Directory ngalaba.
Mmezi mmemme
- Usoro : Usoro rịọrọ site n'aka SQL Server obodo ruo ọtụtụ afọ, ma ọ gụnyere na ntọhapụ a. Usoro bụ onye ọrụ akọwapụtara na site na usoro nke nọmba. Nke a bụ ihe atụ na-eji usoro.
/ ****** Mepụta Ihe Ntugharị Ihe Nlekọta ****** /
Debe usoro ihe omuma
Malite 1
NKWUKWU NKE 1;/ ****** Mepụta Temp Table ****** /
Detuo ndị isi na-asụ TABLE
(
ID abughi NKWU NDỊ KWESỊRỊ,
FullName nvarchar (100) NOT NULL
);/ ****** Tinye ụfọdụ Data ****** /
Tinye @Person (ID, FullName)
VALUES (NKWUKWU NDỊ DỊ N'IME OZI, 'Jim Johnson'),
(NKWU NDỊ DỊ N'AKWỤKWỌ NDỊ MERE, 'Bob Thompson'),
(NKWUKWU NDỊ GA-AHỤ ỤMỌDỤ, 'Tim Wepụrụ');/ ***** Gosi Gosi Data ****** /
Họrọ ihe site n'aka onye isi;Ihe ga - esi na ya pụta:
ID FullName
1 Jim Johnson
2 Bob Thompson
3 Tim echefula
- Ad-Hoc Query Paging: A na-atụle ihe ngwugwu na SQL Server maka afọ. Na Nhọrọ site na nhọrọ na nkwupụta SQL ezuberela na SQL Server 2012. Iji otu Nchikota nke OFFSET na FETCH tinyere ORDER BY na-enye gị nchịkwa nke na-ebugharị site na nsonaazụ rụpụtara. Iji usoro a nwere ike inyere aka na arụmọrụ site n'ijighachi ihe ịchọrọ igosi ndị ọrụ gị mgbe ha chọrọ. Usoro TSQL na-esonụ na-agba ọsọ megide tebụl Onye na AdventureWorks sample database (dị site na Microsoft). Na nyocha ajụjụ dị n'okpuru ebe a, SQL Server ga-alaghachi 10 ederede na-amalite site na ndekọ 11. Iwu OFFSET na-enye mmalite maka nkwupụta SELECT na okwu nke ịkọ ozi, iwu FETCH na-enyekwa ọtụtụ ndekọ iji laghachi n'otu oge.
Kpido BusinessEntityID, FirstName, Aha aha
FROM Person.Person
BỤ BỤRỤ BusinessEntityID
AKWỤKWỌ 10 ROWS
FETCH NEXT 10 NA-EZI;
- Nchọta ederede zuru ezu: Enwetara Nchọgharị Zuru Oke na SQL Server 2012 site n'ikwe ka ịchọọ na nhazi data echekwara na njirimara ma ọ bụ metadata. Tụlee ihe PDF nke nwere "njirimara" jupụtara dị ka Aha, Ụdị, Ụzọ nchekwa, Ọdịdị, Ụbọchị Ekepụtara, wdg. Na ntọhapụ ọhụrụ nke SQL Server, data a nwere ike ịbụ ihe ederede ma chọọ ya na data dị na akwụkwọ ahụ n'onwe ya. A ghaghị ịkọwa data ahụ n'ọrụ, mana ọ ga-ekwe omume ugbu a.
BI na Web Development Environment Improvements
Microsoft wepụrụ BI (Business Intelligence) nso ka njedebe njedebe na SQL Server 2008 R2. Ngwaọrụ PowerPivot Excel na-enyere ndị ọrụ aka site na ịmepụta ihe nyocha ozi onwe onye. Ozi ọma a na-eme ka PowerPivot dị na SQL Server 2012 (koodu-aha ya bụ Denali). Microsoft na-agbakwụnye KPI ma na-egwugharị site na, nke ga-aba uru n'ezie maka ndị ọrụ niile.
Ọrụ nyochaa ga-agụnye ihe ọhụrụ BI Semantic Model (BISM). BISM bụ akara nke 3-na-agụnye:
- Ihe ngosi data
- Mmetụta Business
- Data Access
BISM ga-eme ka nyocha njedebe njedebe nke Microsoft gụnyere Excel, Ọrụ Reporting na SharePoint Insights. Microsoft ekwuola na BISM abụghị onye na-anọchi anya ụdịdị BI ugbu a ma ọ bụ ihe ọzọ. N'okwu dị mfe, BISM bụ ihe nlereanya mmekọrịta nke na-agụnye arịa BI dịka KPI na usoro nlekọta.
Ojiji nke Web-Based - Crescent Project
Ihe ntinye akwukwo nso bu aha Microsoft maka akuko ohuru na ihe eji anya nke oma na SQL Server 2012 (koodu aha ya bu Denali). Ụlọ ọrụ na-enyere ndị mmadụ aka ịdọrọ ma dobe ọrụ mgbasa ozi ad-hoc ma wuo ya na Silverlight.
Ọ na-agụnye ngwá ọrụ nyocha dị ike na mkparịta ụka interactive iji nye onye ọrụ ohere ịkekọrịta ihe ngosi nke ihe ndekọ data dị ukwuu.
Ọrụ Ogo Ngosipụta
Ọrụ Ntanetị data bụ ihe ọmụma nke dabeere na SSIS (SQL Ọrụ Integration Services). Njirimara data bụ otu n'ime ihe ndị ahụ ị na-emezughị. Microsoft na-ewebata "Mmetụta Mmetụta na Ịdị Nlekọta" nke ga-enye gị ozi gbasara ihe data gị dabere. Ọ na-egosipụtakwa usoro ọmụmụ data ahụ, gụnyere ebe o si na usoro ndị dị n'azụ ya.