Zvitsva Zvitsva muSQL Server 2012 - RC0 yakabudiswa
Microsoft SQL Server 2012 RC0 ichangobva kusunungurwa. RC inomiririra Kushandurwa Mubatiri iyo inonyanya kuve shanduro yakagadzirirwa kugadzirwa. Microsoft inotaura nezvekusunungurwa iyi seSQL Server Code inonzi "Denali" asi yakagadzirirwa SQL Server 2012 sezita rekupedzisira rechibereko .. Business intelligence (BI) inonyanya kukosha kumasangano ose makuru uye maduku. Mukusunungurwa kwakabuda kweSQL Server, hapana kushaikwa kwezvikwata zveBI mukuwedzera kune zvimwe zvakawanda zvigadziridzo.
Ichi chinyorwa chichakupa chinyorwa chezvinodiwa, zvitsva nezvisimudziro muSQL Server 2012 (code inonzi Denali) kusanganisira:
- Hardware uye Software Zvido
- Multi-Subnet Failover Clustering
- Programming Kuvandudzika, kusanganisira kuenzanisa, kutemesa kwekutsvaga paging uye zvakakwana-kutsvakurudza kutsvaga tweaks
- BI uye Web Development Development Mavandudziro
- Kuratidzwa kweWebhu
- Data Quality Services
Ramba uchiyeuka kuti ruzivo urwu nderokuona zvarongwa chete uye rwunoshandiswa kuchinja neMicrosoft.
Hardware uye Software Zvido
- Microsoft inokurudzira kushandisa NTFS mafaira mafaira pane FAT32. FAT32 inoshanda asi iwe haufaniri kuishandisa.
- Iwe haugoni kuisa SQL Server 2012 (code-inonzi Denali) pamitambo yepamapuraneti kana kumanikidzirwa.
- Iwe unofanirwa kuva ne "hapana-reboot" purasi yakaiswa pamberi pokuisa SQL Server 2012 (code-inonzi Denali). Izvi zvinowanikwa muWindows 7 SP1 uye Windows Server 2008 R2. Kana zvisina kudaro, unogona kukanda purogiramu isina-reboot kubva kuMicrosoft.
- SQL Server 2012 (code-inonzi Denali) inoda .NET Framework 4.0.
- Virtualization inotsigirwa uchishandisa shanduro yeMicrosoft V Hyper-V.
- Iwe unoda zvingada kusvika 3.6 GB yepachena disk space.
- Microsoft inokurudzira kuti urege kuisa SQL Server 2012 (code-inonzi Denali) pane mutungamiriri wechirongwa.
- Yakarongwa Processors & RAM
- 64-bit version: AMD Opteron, AMD Athlin 64, Intel Xeon neIntel EM64T Support kana Intel Pentium IV ine rutsigiro rwe EM64T runoshandisa 2.0 GHz kana kuti nekukurumidza. Yakakurudzirwa RAM inonyanya kushandiswa kwehutano kana 2 GB.
- 32-bit version: Pentium III kana kushandiswa kunoenderana ne 2.0 GHz nekukurumidza. Yakakurudzirwa RAM inonyanya kushandiswa kwehutano kana 2 GB.
- Windows PowerShell 2.0 ndiyo inotarisirwa kuisa SQL Server 2012 (code-inonzi Denali). Unogona kuwana iyi software kubva paWindows Management Framework peji.
Multi-Subnet Failover Clustering
NeSQL Server 2012 (code-inonzi Denali), unogona kugadzira SQL Server apo failover cluster nodes inogona kusanganiswa kune subnet yakasiyana. Nzvimbo dzepasi pano dzinogona kupararira kune nzvimbo dzakasiyana-siyana dzenharaunda dzinopa hutano hwekugadzirisa pamwe nehupamhi hwekuwanikwa. Kuti izvi zvishande zvakakodzera, iwe uchada kudzokorora dheta kune dzimwe nhepfenyuro dzinobatanidzwa mukugadzirisa uku. SQL Server kuregerera musumbu inobva paWindows Server kukanganisa cluster kuitira kuti izvi zvigadziridzwe kutanga. Ramba uchiyeuka kuti zvose zvinyorwa zvinosanganiswa mumugadziriro iyi zvinofanira kunge zviri muAlex Directory Active domain.
Programming Enhancements
- Kuenzanisa : Kuenzaniswa kwakakumbirwa nemusangano weSQL Server kwemakore, uye wakabatanidzwa mukubudiswa uku. Kuenzanisira ndeyomudzidzisi anotsanangura chinhu chinogadzira chirevo chechiverengero. Heano muenzaniso unoshandisa Sequence.
/ ****** Ita Sequence Object ****** /
DENGA SEQUENCE MySequence
TANGA NA 1
KUNYORWA NOMUSORO 1;/ ****** Yaka Temp Table ****** /
TARISA @Person TABLE
(
ID int NAT NULL PRIMARY KEY,
FullName nvarchar (100) HERE NULL
);/ ****** Isa Dzimwe Dheyo ****** /
INSERT @Person (ID, FullName)
ZVINOKUDZIDZA (CHINOKUDZIDZA CHINOKUDZIDZWA NEZVANGUZVO, 'Jim Johnson'),
(CHINOTEVERA CHINOKUDZIDZWA NEZVANGUZVO, 'Bob Thompson'),
(CHINOKUDZIDZA CHINOKUDZIDZWA NEZVANGUZVO, 'Tim Perdue');/ ****** Ratidzai Dhi ****** /
Sarudza * FROM @Person;Mhinduro yacho yaizoita seyiyi:
ID FullName
1 Jim Johnson
2 Bob Thompson
3 Tim Perdue
- Ad-Hoc Query Paging: Kugadzirisa mhinduro muSQL Server yakakurukurwa kwemakore. Mutemo Nokusarudza muSQL SELECT chirevo chave chawedzerwa muSQL Server 2012. Kushandisa kusanganiswa kwe OFFSET uye FETCH pamwe neOVERDER BY kunokupa kutungamirirwa kwepaging kuburikidza nemugumisiro wemugumisiro. Kushandisa nzira iyi kunogona kubatsira chaizvo kubudirira kuburikidza nekudzorera chete mhinduro dzaunoda kuratidzira kuvashandi vako kana vachidikanwa. Iyi inotevera TSQL code inopesana neMunhu wefurafura mudhavhidha yeAventureWorks sarudzo (inowanikwa kubva kuMicrosoft). Muchirevo chemuenzaniso uri pasi apa, SQL Server ingadzoka zvinyorwa 10 zvichibva nererekodhi 11. Murairo we OFFSET unopa mavambo ekutaura kweCHIKAMU maererano nehedheni, uye murairo weFETCH unopa marenda akawanda kuti adzoke panguva.
Sarudza BhizinesiEntityID, FirstName, LastName
KUBVA Munhu.Person
RONGA NEBASAEntityID
OFFSET 10 ROWS
FUNGA NECHINHU ZVINOTEVERA 10 ZVINOITA PANE;
- Full-Text Tsvaga: The Full Text Search muSQL Server 2012 yakasimbiswa nekukubvumira kutsvaga nekunyora deta yakachengetwa mune mamwe maitiro kana metadata. Funga rugwaro rwepurogiramu rine "dzimba" yakazadzwa seZita, Rudzi, Firiji nzira, Kukura, Zuva Rakaumbwa, nezvimwe. Mukusunungurwa kushandiswa kweSQL Server, iyi dheta inogona kuva indekisi uye ichitsvakurudzwa pamwe nemashoko ari mudhiroyo pacharo. Dheedhi inofanirwa kubudiswa kushanda, asi zvinoita zvino.
BI uye Web Development Development Mavandudziro
Microsoft yakagadzira BI (Business Intelligence) pedyo nomuti wekupedzisira neSQL Server 2008 R2. Iko Excel PowerPivot shandiso inobatsira vashandisi kuburikidza nekugadzira yega self-service reporting report. Mashoko akanaka iW PowerPivot iri kukurudzirwa muSQL Server 2012 (code-inonzi Denali). Microsoft inowedzera KPIs uye inodhonza, iyo ichave yakakosha kune vese vashandisi.
Analysis Services inosanganisira imwe BI Semantic Model (BISM). BISM inomiriro wechitatu-inosanganisira:
- Data Model
- Business Logic
- Data Access
BISM ichavandudza kutsvaga kweMicrosoft yekupedzisira inosangana nekusanganisira Excel, Reporting Services uye SharePoint Insights. Microsoft inotaura kuti BISM haisi iyo inotsiviwa yezvino BI Models asi yakawanda yeimwe mienzaniso. Muchirevo chisinganzwisisiki, BISM inoratidziro yehukama iyo inosanganisira BI zvipfeko zvakadai seKPIs uye mahedheni.
Kuratidzwa kweWebhu -Kushandiswa kwePurojekiti
Project Crescent ndiro zita rekodhi yeMicrosoft yezvigadzirwa zvitsva uye zviratidzo zvinotarisirwa muSQL Server 2012 (code-inonzi Denali). Project Crescent inopa dragha uye inodonha chikwata chekuzivisa zvikwereti uye yakavakwa zvachose paSillightlight.
Inosanganisira simba rine tsvakurudzo yepamusoro uye inobatanidza nyaya yekubatanidza kubvumira mumwe mudzidzi kugovera zviratidzo zvemasikisi makuru makuru.
Data Quality Services
Data Quality Services inzira inodzidzisa-inotungamirirwa muSSIS (SQL Services Integration Services). Dhiyabhorosi yehutano ndeimwe yezvinhu izvo zvausingambofi zvakakwana. Microsoft inotanga "Impact Analysis uye Lineage" iyo ichakupa ruzivo pamusoro pezvinhu zvaunotarirwa nedunhu rako. Inoratidzawo mazera e data, kusanganisira iyo inobva kune iyo uye maitiro ari shure kwayo.