Tshiab nta hauv SQL neeg rau zaub mov 2012 - RC0 Tso tawm
Microsoft SQL Office 2012 RC0 yog tsis ntev los no tso tawm. RC sawv tawm Tso Tawm Sib Tw uas yog qhov tiag qhov khoom siv tau npaj txhij txhua. Microsoft xa mus rau qhov kev tso tawm raws li SQL Server Code Named "Denali" tiam sis nws tau tswm ntawm SQL neeg rau zaub mov 2012 ua lub npe kawg rau qhov khoom. Kev txawj ntse ua lag luam (BI) yog qhov tseem ceeb rau cov koom haum loj thiab me me. Nyob rau hauv qhov tseeb tso cai ntawm SQL neeg rau zaub mov, yog tsis muaj tsis txaus ntawm BI enhancements ntxiv rau ntau lwm enhancements.
Tsab ntawv xov xwm no yuav muab rau koj ua ib qho ntawm cov tseev kom muaj, cov tshiab nta thiab kev hloov kho hauv SQL Server 2012 (code npe Denali) nrog rau:
- Kho vajtse thiab kev yuav tsum tau Software
- Multi-Subnet Failover Clustering
- Programming Enhancements, nrog rau cov kab zauv, kev nug cov lus nug paging thiab tag nrho cov ntawv tshawb nrhiav tweaks
- BI thiab Kev Txhim Kho Zej Tsos Qhov Chaw
- Web-based Visualization
- Cov Kev Pabcuam Cov Ntaub Ntawv
Nco ntsoov tias cov ntaub ntawv no yog rau kev saib ua ntej tsuas yog thiab yuav hloov los ntawm Microsoft.
Kho vajtse thiab kev yuav tsum tau Software
- Microsoft pom zoo siv NTFS cov ntaub ntawv hom es tsis txhob FAT32. FAT32 yuav ua haujlwm tab sis koj yuav tsum tsis txhob siv nws.
- Koj yuav tsis nruab SQL neeg rau zaub mov 2012 (code-named Denali) ntawm mapped drives los yog compressed drives.
- Koj yuav tsum muaj lub pob "tsis-reboot" ua ntej yuav txhim kho SQL Server 2012 (code-named Denali). Qhov no muaj nyob rau hauv Windows 7 SP1 thiab Windows Server 2008 R2. Txwv tsis pub, koj muaj peev xwm download tau lub pob ntawm tsis muaj-reboot los ntawm Microsoft.
- SQL neeg rau zaub mov 2012 (code-named Denali) yuav tsum tau .NET moj khaum 4.0.
- Virtualization yog kev txhawb siab siv Microsoft's Hyper-V technology.
- Koj yuav tsum tau tsawg kawg yog 3.6 GB ntawm qhov chaw dawb disk.
- Microsoft pom zoo kom koj tsis txhob nruab SQL neeg rau zaub mov 2012 (code-named Denali) rau ntawm tus thawj tswj.
- Cov txheej txheem pom zoo & RAM
- 64-ntsis version: AMD Opteron, AMD Athlin 64, Intel Xeon nrog Intel EM64T Kev them nyiaj yug lossis Intel Pentium IV nrog EM64T txhawb khiav 2.0 GHz los yog sai dua. Pom zoo tshaj RAM yog qhov ntau tshaj plaws uas muaj kev txhawb zog los yog tsawg kawg yog 2 GB.
- 32-ntsis version: Pentium III los yog sib tw khiav ntawm 2.0 GHz ntawm sai. Pom zoo tshaj RAM yog qhov ntau tshaj plaws uas muaj kev txhawb zog los yog tsawg kawg yog 2 GB.
- Windows PowerShell 2.0 yog ib qho kev tsim nyog rau kev txhim kho SQL neeg rau zaub mov 2012 (lub npe hu ua Denali). Koj tuaj yeem tau txais qhov software no los ntawm lub Xaiv Cov Haujlwm Tswj Xyuas Qhov Coj.
Multi-Subnet Failover Clustering
Nrog SQL neeg rau zaub mov 2012 (code-named Denali), koj tuaj yeem configure SQL neeg rau zaub mov uas cov lag luam poob haujlwm poob qis yuav raug txuas mus rau ib qho txawv subnet. Cov ntawv ua yuav kis tau mus rau ntau thaj chaw uas muaj kev puas tsuaj rov qab los nrog kev muaj chaw txaus. Hauv kev txiav txim rau qhov no kom ua hauj lwm zoo, koj yuav tsum tau hloov cov ntaub ntawv nyob hauv cov databases koom nrog hauv qhov kev teeb tsa no. SQL Server poob haujlwm pawg yog nyob ntawm lub Windows Server poob haujlwm pawg ces qhov no yuav tsum tau teeb ua ntej. Nco ntsoov tias txhua lub subnets uas koom rau hauv cov txheej txheem no yuav tsum yog tib lub Active Directory sau.
Programming Enhancements
- Sequences : Sequences tau raug thov los ntawm lub zej zog SQL neeg zej zog xyoo, thiab nws tau tso rau hauv qhov kev tso tawm no. Kev sib lawv liag yog ib tus neeg siv cov cuab yeej uas tau muab tso tawm ua ke ntawm ib tug lej. Ntawm no yog ib qho piv txwv uas siv Kev Sib Txuas.
/ ****** Tsim Dua Zauv Nres ****** /
TSIM NTXIV MySequence
PIB NROG 1
TOM QAB 1;/ ****** Tsim Temp Rooj ****** /
DECLARE @Person LUB ROOJ
(
ID TSIS TSIS TXHOB THAWJ TSWJ HWM,
FullName nvarchar (100) TSIS TXHOB
);/ ****** Ntxig Qee Cov Ntaub Ntawv ****** /
INSERT @Person (ID, FullName)
MUAJ NQI (MUAJ TUS NQI TUS MUAJ CAI LOS NTAWM MySequence, 'John Johnson'),
(TUS NQI TUS NEEG MUAJ NTSIAB LUS RAU MySequence, 'Bob Thompson'),
(TUS NQI TUS KHEEJ RAU MySequence, 'Tim Perdue');/ ****** Qhia cov ntaub ntawv ****** /
Xaiv * ntawm @Person;Cov qhabnias yuav zoo li no:
Daim ID npe
1 Jim Johnson
2 Bob Thompson
3 Tim Perdue
- Ad-Hoc Query Paging: Paging tau nyob rau hauv SQL neeg rau zaub mov tau tham txog ntau xyoo. Qhov Kev Txiav Txim Los Ntawm Kev Xaiv Nyob Hauv SQL SELECT Statement tau raug kho zoo hauv SQL neeg rau zaub mov 2012. Siv lub sijhawm ua haujlwm ntawm OFFSET thiab FETCH nrog rau TXAWV los muab rau koj tswj ntawm paging los ntawm cov teeb meem. Siv cov txheej txheem no tuaj yeem pab kev ua tau zoo los ntawm kev xa rov qab tsuas yog qhov koj xav tau los qhia rau koj cov neeg siv thaum lawv xav tau. Tsab cai nram qab no TSQL tiv thaiv tus neeg lub rooj hauv cov AdventureWorks qauv database (muaj los ntawm Microsoft). Hauv cov lus nug hauv qab no, SQL neeg rau zaub mov yuav xa 10 cov ntaub ntawv pib ua kom tiav 11. Cov lus txib OFFSET muab lub ntsiab lus pib rau SELECT tsab ntawv hais txog kev paging, thiab FETCH hais kom muaj pes tsawg cov ntaub ntawv rov qab.
Xaiv BusinessEntityID, FirstName, LastName
FROM Person.Person
TXIAV TXIM NTAWM BusinessEntityID
OFFSET 10 ROWS
FETCH NEXT 10 ROWS XWB;
- Full-Text Search: Cov Kev Tshawb Fawb Hauv SQL Server 2012 tau raug kho kom zoo dua los ntawm qhov uas koj mus nrhiav thiab index cov ntaub ntawv cia hauv cov khoom lossis cov metadata. Xav txog cov ntaub ntawv PDF uas muaj "cov khoom" puv xws li Npe, Hom, Nplaub tshev kev, Qhov Cim, Hnub Tsim, thiab lwm yam. Hauv kev tshaj tawm tshiab ntawm SQL neeg rau zaub mov, cov ntaub ntawv no yuav yog indexes thiab tshawb nrog cov ntaub ntawv nyob rau hauv daim ntawv nws tus kheej. Cov ntaub ntawv yuav tsum tau ua haujlwm, tab sis nws tau tam sim no.
BI thiab Kev Txhim Kho Zej Tsos Qhov Chaw
Microsoft tsiv BI (Kev txawj ntse ua lag luam) los ze zog mus rau qhov kawg neeg siv nrog SQL Server 2008 R2. Lub PowerPivot Tool pab cov neeg siv los tsim ib qho qauv qhia tus kheej. Cov xov xwm zoo yog PowerPivot raug kho zoo hauv SQL neeg rau zaub mov 2012 (lub npe hu ua Denali). Microsoft muab KPIs thiab xyaum los ntawm, uas yuav pab tau rau txhua tus neeg siv.
Kev Pabcuam Tsomfwm yuav xam nrog tus qauv tshiab BI Semantic Model (BISM). BISM yog 3-txheej qauv uas suav nrog:
- Cov Qauv Cov Ntaub Ntawv
- Lag luam Log
- Cov Ntaub Ntawv Siv
BISM yuav ua kom Microsoft lub thev nias sab nrauv muaj xws li Excel, Qhia Ntawv Qhia thiab SharePoint Insights. Microsoft tau hais tias BISM tsis yog hloov rau BI Models tam sim no tab sis ntau dua ntawm ib qho qauv qhia ntawv. Hauv cov lus yooj yooj yim, BISM yog ib tus qauv piv nrog rau cov BI artifact xws li KPIs thiab hierarchies.
Web-Based Visualization - Project Crescent
Project Crescent yog lub npe Microsoft lub npe rau kev tshaj qhia tshiab thiab kev pom qhov cuab yeej tsim tawm hauv SQL Server 2012 (code-named Denali). Project Crescent muab ntes thiab poob qis tshaj tawm kev ua haujlwm thiab tau ua tiav ntawm Silverlight.
Nws muaj xws li cov cuab yeej nug cov lus nug thiab sib tham sib storyboarding kom tso cai rau ib tus neeg siv los sib saib ntawm cov datasets loj.
Cov Kev Pabcuam Cov Ntaub Ntawv
Cov Kev Pabcuam rau Cov Ntaub Ntawv (Data Quality Services) yog ib txoj kev paub raws li kev paub hauv SSIS (SQL Services Integration Services). Cov ntaub ntawv zoo yog ib yam ntawm cov khoom uas koj tsis tau txais zoo meej. Microsoft yog qhia txog "Kev Ntsuas thiab Kev Tshaj Lij" uas yuav qhia tau koj cov ntaub ntawv txog koj cov ntaub ntawv nyob ntawm. Nws kuj qhia txog cov kab ntawv ntawm cov ntaub ntawv, nrog rau qhov uas nws los ntawm thiab cov tshuab uas nws qab.