Vaega Fou i le SQL Server 2012 - RC0 Faʻaloloina
O le Microsoft SQL Server 2012 RC0 faatoa faʻasaʻolotoina. RC o loʻo tu mo le faʻatagaina o le Faʻamasino lea o le mea autu o le faʻataʻitaʻiga toetoe o le saunia. Na faʻasinoina e Microsoft lenei faʻamaumauga e pei o le SQL Server Code ua faaigoaina "Denali" ae ua malupuipuia i luga o le SQL Server 2012 e avea ma igoa mulimuli mo le oloa. O le atamai tau pisinisi (BI) e matua taua tele i le faʻapenaina o mea tetele ma laiti. I le faʻasalalauga lata mai o SQL Server, e leai se tele o faʻaleleia BI e faaopoopo i le tele o isi faʻaleleia.
O lenei tusiga o le a avatu ia te oe se muaʻi faʻamatalaga o manaʻoga, foliga fou ma faʻaleleia atili i le SQL Server 2012 (numera e igoa ia Denali) e aofia ai:
- Faʻamaumauga Faʻamatalaga Faʻamatalaga ma Meafaigaluega
- Tele-Subnet Failover Flustering
- Polokalame faʻaleleia o polokalame, e aofia ai faʻasologa, fesili faʻapipiʻi paga ma tweaks
- BI ma Web Development Environment Faʻalelei
- Faʻamatalaga Faʻamatalaga Faʻavae i le Initaneti
- Auaunaga Lautele Ata
Manatua o lenei faʻamatalaga mo le na o le muaʻi silafia ma e mafai ona suia e Microsoft.
Faʻamaumauga Faʻamatalaga Faʻamatalaga ma Meafaigaluega
- Ua fautuaina e Microsoft le faʻaaogaina o le faila file NTFS nai lo le FAT32. FAT32 o le a galue ae e tatau ona e le faʻaaogaina.
- E le mafai ona e faʻatulagaina le SQL Server 2012 (code-named Denali) i luga o masini faʻapipiʻiina poʻo taʻavale faʻapipiʻiina.
- E tatau ona i ai le afifi o le "leai-toeboot" na faʻapipiʻiina aʻo leʻi tuʻuina le SQL Server 2012 (code-named Denali). E aofia ai lenei i le Windows 7 SP1 ma le Windows Server 2008 R2. A leai, e mafai ona e siiina mai le afifi le toe maua mai Microsoft.
- O le SQL Server 2012 (code-named Denali) e manaʻomia ai le NET Framework 4.0.
- Ua lagolagoina le ola mama i le faʻaaogaina o tekonolosi a Hyper-V.
- O le ae manaʻomia le le itiiti ifo i le 3.6 GB o le avanoa avanoa avanoa.
- Ua fautuaina e Microsoft e te le faʻatūina le SQL Server 2012 (code-named Denali) i luga o le pule o le pule.
- Fautuaga Tusitusia fautuaina & RAM
- 64-bit version: AMD Opteron, AMD Athlin 64, Intel Xeon ma le Intel EM64T Support poʻo Intel Pentium IV ma le EM64T lagolago e faʻatatau 2.0 GHz pe vave. Fautuaina RAM o le maualuga lea e lagolagoina e le masini komepiuta poʻo le 2 GB.
- 32-bit version: Pentium III poʻo le fetaui faʻatonu i le 2.0 GHz o le vave. Fautuaina RAM o le maualuga lea e lagolagoina e le masini komepiuta poʻo le 2 GB.
- Windows PowerShell 2.0 o se muai manaʻomia mo le faʻapipiʻiina o le SQL Server 2012 (code-named Denali). E mafai ona e mauaina lenei polokalama mai le itulau o le Windows Management Framework.
Tele-Subnet Failover Flustering
Faʻatasi ai ma le SQL Server 2012 (code-named Denali), e mafai ona e faʻatulagaina le SQL Server i le mea e mafai ona fesoʻotaʻi ai nonoa tautua faiva i se subnet sili ona ese. E mafai ona faʻasalalauina vaevaega i nofoaga eseese o loʻo maua ai le faʻaleagaina o faʻalavelave faʻafuaseʻi ma le maualuga o avanoa. Ina ia saʻo lelei lenei mea, o le ae manaomia le toe faʻaogaina o faʻamatalaga i luga o faʻamaumauga o loʻo aofia ai i lenei faatulagaga. O le faʻaaogaina o le failaver faila SQL Server e faʻalagolago i le faila o le failover Windows Server ma o lea e tatau ona faʻatutu muamua. Ia manatua o subnets uma e aofia ai i lenei faatulagaga e tatau ona iai i le itu Active Directory.
Polokalame Faʻaleleia
- Faʻatulagaga : O talosaga na talosagaina e le faʻalapotopotoga o SQL Server mo le tele o tausaga, ma o loʻo aofia ai i lenei faʻasalaga. O le faasologa o se mea na faʻamatalaina e le tagata e faʻaalia ai se faasologa o se numera. O se faʻataʻitaʻiga lea e faʻaaoga ai le Faasologa.
/ ****** Fausia le Faʻasologa o le Faʻasologa ****** /
FUAFUAINA SEQUENCES Fuaitau
START WITH 1
TUUINA ATU E LE 1;/ ****** Fausia le Tapenaga o le Laulau ****** /
FAʻAMATALAINA LE LAGOLAGO TAGATA
(
ID e LE MAFAI ONA TAITAI LELEI,
FullName nvarchar (100) NO NULL
);/ ****** Faʻaofi nisi Data ****** /
INSERT @Person (ID, FullName)
VALUES (TUPE MAUA MO MYSequence, 'Jim Johnson'),
(TALA FAATASI MO MYSequence, 'Bob Thompson'),
(TALA FAATINO MO MySequence, 'Tim Leʻa');/ ****** Faʻaali le Faʻamatalaga ****** /
FILIFILI * FROM @Person;O taunuuga o le a pei o lenei:
ID FullName
1 Jim Johnson
2 Bob Thompson
3 Tim Time
- Ad-Hoc Query Paging: O faʻataʻotoga i totonu o le SQL Server na talanoaina mo le tele o tausaga. O le Poloaiga Saunia e ala i le filifiliga SQL SELECT ua faʻaleleia i le SQL Server 2012. O le faʻaaogaina o le OFFSET ma le FETCH faʻatasi ai ma le ORDER BY e tuʻuina atu ai ia te oe le puleaina o le paging e ala i se iuga. O le faʻaaogaina o lenei metotia e mafai ona fesoasoani moni i le faʻatinoga e ala i le toe aumaia o iuga e te manaʻo e faʻaali atu i ou tagata faʻapitoa pe'ā manaʻomia. O le siata TSQL o loʻo mulimuli mai i le laulau Tagata i le AdventureWorks sample database (o loʻo maua mai Microsoft). I le suega fesili i lalo, o le a toe faafoi mai e le SQL Server le 10 faamaumauga e amata i le faamaumauga 11. O le OFFSET poloaiga ua maua ai se amataga mo le faamatalaga SELECT i le tulaga o le paina, ma o le FETCH poloaiga ua maua ai le tele o faamaumauga e toe foi i le taimi.
FILIFILI BusinessEntityID, FirstName, LastName
FROM Person.Person
TALIINA e BusinessEntityID
OFFSET 10 ROWS
FETCH NEXT 10 FAASOLO ONA;
- Suʻesuʻega Faʻatasi : O le Suʻesuʻega Atoatoa i le SQL Server 2012 ua faʻamalosia e ala i le faʻatagaina o oe e suʻesuʻe ma faʻasoa faʻamaumauga o loʻo teuina i mea lautele poʻo metadata. Manatu i se pepa PDF o loʻo i ai "meatotino" ua tumu i le Igoa, Ituaiga, Auala Folki, Lautele, Aso na faia, ma isi mea. I le tatalaina fou o le SQL Server, o lenei faʻamatalaga e mafai ona faʻasino ma suʻesuʻe faʻatasi ma faʻamatalaga i le pepa lava ia. O faʻamaumauga e tatau ona faʻaalia i le galuega, ae mafai i le taimi nei.
BI ma Web Development Environment Faʻalelei
Na faʻapipiʻi e Microsoft le BI (Business Intelligence) latalata i le tagata faʻauʻu faʻatasi ma le SQL Server 2008 R2. O le Excel PowerPivot meafaigaluega fesoasoani i tagata faaaoga e ala i le fatuina o se faʻataʻitaʻiga a le tagata lava ia. O le tala lelei o le PowerPivot o loʻo faʻamalosia i le SQL Server 2012 (code-named Denali). O loʻo faʻaopoopoina e Microsoft KPI ma fofo, lea o le a sili ona aoga mo tagata uma e faaaogaina.
Auʻaunaga Faʻamatalaga e aofia ai se BI Semantic Model (BISM) fou. O le BISM o se faʻataʻitaʻiga 3-layer e aofia ai:
- Faʻamaumauga o faʻamatalaga
- Polokalame Tau Pisinisi
- Avanoa Faʻamatalaga
O le a faʻaleleia e le BISM le faʻatautaia o suʻesuʻega a le Microsoft e aofia ai le Excel, Lipoti Auaunaga ma SharePoint Insights. Ua fai mai Microsoft o BISM e le o se sui mo Faigamalaga BI o loʻo iai nei ae sili atu i se isi faʻataʻitaʻiga. I faaupuga faigofie, o le BISM o se faʻatalatalanoaga e aofia ai le BI mea faʻapitoa e pei o KPI ma faʻatulagaga.
Faʻamatalaga Faʻamatalaga i luga o le Upega Tafaʻilagi - Poloketi Poloketi
Poloketi Poloketi o le igoa code code Microsoft mo le faʻamatalaga fou ma mea faʻapitoa e faʻaalia i totonu o le SQL Server 2012 (code-named Denali). Poloketi Poloketi tuʻufaʻatasia ma faʻaitiitia le faʻatulagaga o faʻamatalaga ad-hoc ma sa fausia atoa i Silverlight.
E aofia ai se meafaigaluega o fesili fesiligia ma fesoʻotaiga faʻatalanoa e faʻataga ai se tagata faʻaaoga e faʻasoa faʻamatalaga o faʻamaumauga tetele.
Auaunaga Lautele Ata
Auaunaga Lautele o Fuainumera Faʻatonu o se faʻataʻitaʻiga e faʻatatau i le tomai o loʻo faʻatino i SSIS (SQL Services Integration Services). O uiga lelei o faamatalaga o se tasi lea o na mea e te le atoatoa. O loʻo faʻaofi e Microsoft le "Analysis Analysis and Lineage" lea o le a tuʻuina atu ai ia oe faʻamatalaga e uiga i le mea e faalagolago i ai lau faʻamaumauga. O loʻo faʻaalia ai foi le laina o faʻamatalaga, e aofia ai le mea e sau mai ai ma le faiga o loʻo i tua.