Litaba tse Ncha SQL Server 2012 - RC0 e hlahisoa
Microsoft SQL Server 2012 RC0 e sa tsoa lokolloa. RC e emetse Mokhethoa oa Phaliso eo ka sebele e leng phetolelo e batlang e loketse. Microsoft e bua ka tokollo ena e le SQL Server Code e bitsoang "Denali" empa e rarolletse SQL Server 2012 e le lebitso la ho qetela la sehlahisoa. Khoebo ea khoebo (BI) e bohlokoa haholo mekhatlo e meholo le e meholo. Ka ho lokolloa ha SQL Server haufinyane, ha ho na khaello ea lisebelisoa tsa BI ho phaella lintlheng tse ling tse ngata.
Sehlooho sena se tla u fa ponelo-pele ea lintho tse hlokahalang, likarolo tse ncha le lisebelisoa ho SQL Server 2012 (khoutu e bitsoang Denali) ho kenyelletsa:
- Litlhoko tsa Hardware le Software
- Ho ikamahanya ka ho fetisisa ho fapana le subnet Subnet
- Lintlafatso tsa ho ntlafatsa, ho kopanyelletsa le ho latellana, potso ea boipheliso paging le litlhaloso tse feletseng tsa ho batlisisa
- Ntlafatso ea BI le Web Development Development
- Litšoantšo tse shebaneng le Websaete
- Litšebeletso tsa Boleng ba Ditaba
Hopola hore tlhahisoleseding ena ke bakeng sa tlhahlobo pele mme e ka fetoha ke Microsoft.
Litlhoko tsa Hardware le Software
- Microsoft e khothalletsa ho sebelisa mokhoa oa faele oa NTFS ho e-na le FAT32. FAT32 e tla sebetsa empa mohlomong u se ke ua e sebelisa.
- U ke ke ua kenya SQL Server 2012 (e bitsoang Denali ka khoutu) ho li-drive kapa mapolesa a qobelloang.
- U tlameha ho ba le mokotla oa "ha u se o khutlisetse" o kenngoa pele o kenya SQL Server 2012 (e bitsoang Denali khoutu). Sena se kenyelelitsoe Windows 7 SP1 le Windows Server 2008 R2. Ho seng joalo, o ka kopitsa sephutheloana sa ho qala sa Microsoft.
- SQL Server 2012 (e bitsoang code Denali) e hloka .NET Framework 4.0.
- Tlhahiso e nepahetseng e tšehetsoa ka theknoloji ea Microsoft ea Hyper-V.
- U tla hloka bonyane sebaka sa disk sa mahala sa 3,6 GB.
- Microsoft e khothalletsa hore u se ke ua kenya SQL Server 2012 (e bitsoang code e bitsoang Denali) ho molaoli oa domain.
- E khothalletsoang Processors & RAM
- 64-bit version: AMD Opteron, AMD Athlin 64, Intel Xeon le Intel EM64T Support kapa Intel Pentium IV e nang le tšehetso ea EM64T e tsamaeang ka 2.0 GHz kapa ka potlako. Khothalletsoang RAM ke boholo ba hore tsamaiso ea tšebeliso e tšehetsa kapa bonyane 2 GB.
- Phetolelo ea 32-bit: Pentium III kapa e tsamaeang le 2.0 GHz ka potlako. Khothalletsoang RAM ke boholo ba hore tsamaiso ea tšebeliso e tšehetsa kapa bonyane 2 GB.
- Windows PowerShell 2.0 ke ntho e hlokahalang pele ho kenya SQL Server 2012 (e bitsoang code Denled). O ka fumana software ena ho leqephe la Windows Management Framework.
Ho ikamahanya ka ho fetisisa ho fapana le subnet Subnet
Le SQL Server 2012 (e bitsoang Denali ka khoutu), o ka lokisa SQL Server moo ho fokotsa node ea cluster ho ka kopanngoa le subnet e fapaneng haholo. Litemana tsena li ka fetisetsoa libakeng tse sa tšoaneng tse fanang ka boipheliso ba tlokotsi hammoho le ho fumaneha ha maemo a phahameng. E le hore sena se sebetse ka tsela e nepahetseng, ho tla hlokahala hore u phete boitsebiso bo fetisisang boitsebiso bo amehang ho ponts'o ena. Sesebelisoa sa SQL Server se fokolang se itšetlehile ka sehlopha sa Windows sa failover fuster so sena se lokela ho behoa pele. Hopola hore litlhokomeliso tsohle tse amehang pontsong ena li tlameha ho ba sefateng se tšoanang sa Active Directory.
Lintlafatso tsa ho ntlafatsa
- Ho latellana : Liketso li 'nile tsa kōptjoa ke sechaba sa SQL Server ka lilemo,' me se kenngoa phalong ena. Ho latellana ke motho ea hlalosang ntho e hlahisang sephetho sa palo. Mohlala ke ona o sebelisang Sequence.
/ ****** Etsa Sequence Object ****** /
BALA SEQUENCE MySequence
QALANG LE 1
TŠEBELETSO KA 1;/ ****** Etsa Letlapa la Tempele ****** /
ETSA @Person TABLE
(
ID int HA HO NULL PELE KE NETSE,
FullName nvarchar (100) HA HO NULL
);/ ****** Kenya Litaba Tse ling tsa ****** /
TSEBA PELE @Person (ID, FullName)
LINTLHA TSA BOHLOKOA (NAHANA E LATELANG KA MYSequence, 'Jim Johnson'),
(BOHLOKOA BO HLAHLANG BA MYSequence, 'Bob Thompson'),
(NAHALO E LATELANG KA MySequence, 'Tim Perdue');/ ****** Bonts'a Dintlha ****** /
Khetho * FROM @Person;Liphetho li ne li tla shebahala tjena:
Full Full Name
1 Jim Johnson
Bob Thompson
3 Tim Perdue
- Tlhahlobo ea Ad-Hery Paging: Ho hlahisa liphetho ho SQL Server ho buisitsoe ka lilemo. Tlhophiso ka khetho ho polelo ea SQL SELECT e ntlafalitsoe SQL Server 2012. Ho sebelisa sethomo sa OFFSET le FETCH hammoho le ORDER BY ho u fa taolo ea paging ka ho beha sephetho. Ho sebelisa mokhoa ona ka sebele ho ka thusa tshebetso ka ho khutlisetsa feela liphetho tseo u batlang ho li bontša basebelisi ba hau ha li hlokahala. Tsamaiso e latelang ea TSQL e fapana khahlanong le tafole ea Motho ho database ea AdventureWorks (e fumanehang ho tsoa ho Microsoft). Molaong o hlahang ka tlase mona, SQL Server e ne e tla khutlisa litlaleho tse 10 tse qalang ka tlaleho 11. Taelo ea OFFSET e fana ka ntlha ea qalo ea polelo ea SELECT ka mokhoa oa ho ba pageng, mme taelo ea FETCH e fana ka litlaleho tse ngata tse tla khutla ka nako.
Khetha SEBusinessEntityID, FirstName, LastName
HO tsoa ho Motho
HO ETSA KA KhoeboEntityID
TSEBETSE 10 LIPOTSO
E FETILENG FETA LETHATHAMO LA TSE KA HARE;
- Tlhaloso e feletseng ea Text: Tlhaloso e feletseng ea Text in SQL Server 2012 e ntlafalitsoe ka ho u lumella hore u batlisise le ho hlahisa boitsebiso bo bolokiloeng maralong kapa metadata e atolositsoeng. Nahana ka tokomane ea PDF e nang le "lisebelisoa" tse tletseng lebitso, Mofuta, Tsela, Tsela, Tsela, Taolo, Nako, joalo-joalo. SQL Server e ncha ka ho fetisisa, lintlha tsena li ka ba likhahla le ho phenyekolloa hammoho le boitsebiso bo ngotsoeng ka bobona. Boitsebiso bo tlameha ho pepeseha mosebetsing, empa ho ka khoneha hona joale.
Ntlafatso ea BI le Web Development Development
Microsoft e tsamaisitse BI (Business Intelligence) haufi le mosebedisi wa ho qetela le SQL Server 2008 R2. Sesebelisoa sa Excel PowerPivot se thusa basebedisi ka ho theha setšoantšo sa boitsebiso ba boithaopo. Litaba tse monate ke PowerPivot e ntseng e ntlafatsoa SQL Server 2012 (e bitsoang Denali khoutu). Microsoft e eketsa KPIs le ho phunyeletsa, e tla ba ea bohlokoa haholo ho basebelisi bohle.
Analysis Services e tla kenyelletsa setšoantšo se secha sa BI Semantic (BISM). BISM ke mohlala o motlakase o 3 o akarelletsang:
- Mohlala oa Data
- Mokhoa oa Khoebo
- Boitsebiso ba Ditshebeletso
BISM e tla ntlafatsa tlhahlobo ea pele ea Microsoft e bonts'ang ho kenyeletsa Excel, Reporting Services le SharePoint Insights. Microsoft e boletse hore BISM ha e nkele sebaka sa BI Models tse teng hona joale empa e le mohlala o mong oa mefuta e meng. Ka mantsoe a bonolo, BISM ke mohlala oa kamano o kenyeletsang lihlahisoa tsa BI tse kang li-KPIs le li-hiérarchies.
Tlhahiso-leihlo e thehiloeng Websaeteng - Phello ea morero
Project Crescent ke lebitso la khoutu ea Microsoft bakeng sa sesebelisoa se secha sa tlaleho le se bonts'ang se lebeletsoeng SQL Server 2012 (lebitso le bitsoang Denali). Motlakase oa morero o fana ka ho hula le ho tlohela mosebetsi oa ho fana ka tlaleho ea litlaleho mme o hahiloe ka botlalo ho Silverlight.
E kenyeletsa sesebelisoa se matla sa lipotso le li-storyboarding tse kopanetsoeng ho lumella mofani ho arolelana litšoantšo tsa ditshwantsho tse kholo tsa datasete.
Litšebeletso tsa Boleng ba Ditaba
Litšebeletso tsa boleng ba data ke mokhoa o thehiloeng ho tsebo o sebetsang SSIS (SQL Services Services Integration Services). Tšobotsi ea data ke e 'ngoe ea lintho tseo u sa fumaneng li phethahetse. Microsoft e hlahisa "Tlhahlobo ea Tlhahlobo le Tlhahlobo" e tla u fa tlhahisoleseding mabapi le seo data ya hao e itšetlehileng ka sona. E boetse e bonts'a moloko oa data, ho kenyelletsa moo o tsoa teng le mekhoa e ka morao.