Microsoft inkqubo yolawulo database Kumncedisi we SQL

Microsoft version aphambili SQL yokuqala thaca yinkampani umva ngo-1988. Database nangoko kubekwe njenge ezinobume database, ethe, ngokutsho kumenzi, amathuba ezintathu:

• agcinwe iinkqubo kukwenza okukhawulezileyo isampula data nengqibelelo yayo siyagcinwa kwimo multi-umsebenzisi;
• ukufikelela isigxina ledatha lokuqhawula abasebenzisi ngaphandle ulawulo;
• platform server evulekileyo, elikuvumela ukuba ukudala izicelo zeqela lesithathu ezisebenzisa Kumncedisi we SQL.

Umncedisi SQL Microsoft 2005 phantsi kwegama ikhowudi Yukon kunye scalability ngcono waba kwinguqulelo yokuqala zixhasa ngokupheleleyo technology .NET. inkxaso Ukuphuculwa i data zisasazwe, izixhobo kuqala ingxelo kunye uhlalutyo.

Ukudityaniswa kunye Internet wavumela ukusetyenziswa Kumncedisi we SQL ngo-2005 njengoko njengesiseko indalo kweenkqubo e-commerce kunye ukufikelela elula olukhuselekileyo ukuya data nge bakhangeli beencwadi ezithandwayo usebenzisa eyakhelwe-ngaphakathi Firewall (firewall). Inkxaso Enterprise okunxuseneyo computing kwi inani esinganasiphelo esixhasiweyo.

Ukuze endaweni uguqulelo 2005 weza Kumncedisi we SQL Microsoft 2008, nto leyo nangoku yenye kweeseva kakhulu zithandwa database, yaye kamva kancinane wabonakala uguqulelo elandelayo - SQL Kumncedisi we-2012, kunye nenkxaso wokuhambelana Framework .NET kunye nezinye phambili ulwazi ngobugcisa ukuzilungisa yaye bume yophuhliso Visual Studio. Ukufikelela yokugcina ilifu iyunithi eyodwa yenziwe SQL Azure.

Transact-SQL

Ukususela ngo-1992, lo umbuzo ulwimi SQL lwedatha ledatha standard ukufikelela. Phantse zonke lwenkqubo iilwimi ukufikelela usebenzisa ledatha yayo, kwanokuba umsebenzisi uvakalelwa ukuba ukusebenza ngolwazi ngqo. Syntax osisiseko ulwimi kuhlala ingatshintshanga uphawulo, kodwa elowo umthengisi iinkqubo zolawulo ledatha wazama ukugcwalisa imisebenzi SQL eyongezelelweyo. Ukungazazi ayikwazanga kufumaneka, yaye emva "imigangatho imfazwe" abaziintloko ezimbini: PL / SQL, Oracle, kunye Transact-SQL kwi Microsoft Kumncedisi we SQL.

T-SQL yenkqubo ubonakalisa SQL ukufikelela Microsoft Kumncedisi we SQL. Kodwa oku akukhethi uphuhliso izicelo kwiingxelo "umgangatho".

Zokusebenzisa ishishini lakho Kumncedisi we SQL-2008 R2

ukusebenza ezinokuthenjwa izicelo zoshishino kubalulekile kwishishini namhlanje. Le database nakancane elula kunokukhokelela ilahleko enkulu. Umncedisi Idathabheyisi Kumncedisi we SQL Microsoft 2008 R2 ikuvumela ukuba ngokukhuselekileyo ukugcina isixa phantse unlimited iinkcukacha usebenzisa ulawulo aqhelekileyo kubalalwuli bonke. Ezixhaswayo izinga ku 256 esixhasiweyo.

technology Hyper-V ngempumelelo isebenzisa amandla ubuninzi kweenkqubo multi-core mihla. Inkxaso ukuba nobuninzi kweenkqubo iprosesa virtual kunciphisa iindleko yaye kuphucula scalability.

uhlaziye idatha

Ukuba ufuna ukuhlaziya-time real imijelo data indlela yingxenye kusetyenziswa SQL Umncedisi StreamInsight, olulungiselelwe olu hlobo zemisebenzi. Sinako ukuphuhlisa izicelo siko esekelwe .NET.

ukuqhubeka Business and data zokhuseleko

nangaliphi na ixesha elinye exhasa lusebenze inika ulawulo lwezibonelelo server eyakhelwe-ngaphakathi. Umlawuli ikwazi ukulawula izibonelelo komsebenzi kunye nenkqubo, ukumisela umda izicelo ukusebenzisa CPU kunye memory. iimpawu Encryption zinika bhetyebhetye nokuba selubala nokhuselo idatha yonikezelo loshicilelo ke kuye.

ubukhulu database Unlimited

A yempahla kwedatha zinga ngokukhawuleza nangokukhuselekileyo. Abasebenzisi ukusebenzisa track templates Umhla Warehouse olukhawulezayo ukuxhasa kwimiboniso diski ukuya 48 TB. uqwalaselo Basic ixhasa izixhobo kwiinkampani eziphambili ezifana HP, EMC kunye IBM. ucinezelo data umsebenzi standard UC 2 uvumele ukusetyenziswa enoqoqosho ngakumbi isithuba kwidiski.

Ukuphucula ukusebenza developers nabalawuli

software wizard Entsha ikuvumela ukuba ukususa ngokukhawuleza iiseva underloading, ukuphucula ulawulo kunye nokwandisa yokusebenza ngaphandle kwesidingo iingcali zomntu wesithathu yangaphandle. Lawula Ipharamitha yesicelo database, bafumana amathuba okuphucula ukusebenza dashboard nokukhawulezisa ukuphuculwa kunye nofakelo.

Izixhobo for analysis yeshishini lokobuqu

Le nkampani iye zange uluvo olunye ukuba ngubani kufanele bakwenze analytics - IT-amasebe okanye ngqo kubasebenzisi. inkqubo yokunika ingxelo lobuqu uyayisombulula le ngxaki ngokusebenzisa izixhobo zale mihla ekhuselekileyo nolusebenzayo zokwakha, uhlalutyo inkqubo zoshishino nokuba ngumzekelo. Ivumela ukufikelela ngqo zedata e Microsoft Office kunye zakwaMicrosoft® SharePoint. ulwazi Corporate ungahlanganiswa nezinye iintlobo izinto, ezifana iimephu, imizobo kunye nevidiyo.

indawo elula for ukusebenza kunye

Nika abasebenzi bakho kunye nokufikelela kulwazi, uphuhliso ngokudibeneyo kunye nocazululo lwedatha usebenzisa isicelo PowerPivot ukuba spreadsheet Excel. Le program ivumela uhlalutyo lweenkcukacha ngumzekelo kweenkqubo zoshishino lipapashe iingxelo ukwabelana Web okanye SharePoint nkqubo.

Kuba indalo ezibonwayo, inkqubo lwangaphakathi Iingxelo Ingxelo Builder 3.0, nto leyo exhasa iintlobo yeefomati kunye noluhlu olubanzi itemplates ezichazwe phambili.

Sebenza zolwazi free

Le nkampani ibonelela iiprojekthi ezincinane kunye nabakhi mafikizolo kwi Microsoft SQL Server Express version ekhethekileyo free. Oku kuquka ubuchwepheshe ledatha efanayo, ukuba le nguqulo "elipheleleyo 'Kumncedisi we SQL.

Ixhasa bume yophuhliso zeStudiyo zokuBonakalayo kunye Developer Web. Yenza iitafile alukhuni imibuzo, ukuphuhlisa izicelo Internet ngenkxaso database, ufikelelo ngqo kwiinkcukacha evela PHP.

Sebenzisa zonke iinkalo Transact-SQL kunye ukufikelela nobuchwepheshe eziphambili ukuya ADO.NET kunye data LINQ. Ixhasa igcinwe iinkqubo, kudala nemisebenzi.

Gxila kumacandelo logic ishishini, kwaye ukukhulisa isakhiwo database liya kwenza le nkqubo ngokwakho.

Yenza iingxelo zizityebi nayiphi xaka. Sebenzisa uphendlo iingxelo esezantsi nge izicelo-Microsoft Office, yaye kongezelelwa iinkcukacha uxwebhu kwi indawo okuyo.

Izicelo kuphuhliswa ngayo Ndigidima ukungabikho uqhagamshelo leseva ledatha. Ukuvumelanisa kwenziwa ngokuzenzekelayo usebenzisa wezindlu technology emide phindana Sync Framework.

Ukulawula izibonelelo zabo besebenzisa le nkqubo yolawulo bonke oovimba kunye izicelo. nemiboniso yokusebenza jikelele kunciphisa ixesha ukuze kusetyenziswe imibuzo, ukudala nokubuyisela kwideskithophu lweshishini.

Umncedisi SQL 2008 R2 Express Edition ezilungele ukutyalwa ngokukhawuleza kweendawo kunye noovimba intanethi, isoftware oyisebenzisela wena buqu, amashishini amancinane. Le kukho olukhulu usa qalisa nokufunda.

Lawula zolwazi ngokusebenzisa SQL Server Management Studio

Management Kumncedisi we SQL Microsoft yimekobume ezizodwa ukuba indalo, ufikelelo kunye nolawulo zolwazi zonke iingxenye Kumncedisi we SQL, kubandakanywa iiNkonzo Reporting.

Le nkqubo umisela omnye ujongano zonke iinkalo zolawulo iinkqubo ukusuka iinguqulelo ngaphambili, ezifana Query Analyzer kunye noMphathi Enterprise. Abalawuli isoftwe kunye noluhlu olukhulu loyilo nolawulo imizobo, kunye ulwimi phambili ukusebenza ledatha.

Umhleli ikhowudi Microsoft zakwaMicrosoft® Management Studio kufuna ingqalelo ekhethekileyo. It ikuvumela ukuba iincwadi zeempendulo script Transact-SQL, lwenkqubo imibuzo yoyilo ukufikelela idatha ukuhlalutya nabo ngenkxaso ukugcina iziphumo njengoko XML. Yenza imibuzo kunye eempendulo ngaphandle kokuqhagamshelana womnatha okanye umncedisi, kulandele ukuphunyezwa kunye nexesha. Kukho iintlobo ngeentlobo itemplates esinye acwangciswe ngaphambili kunye nenkqubo lwewebhu.

Imodyuli "Into Umkhangeli" ikuvumela ukubuka nokulawula yonke Microsoft izinto ezihlangeneyo Kumncedisi we SQL kubobonke abancedisi kunye iimeko ledatha. ukufikelela lula ulwazi ekunene kubaluleke kakhulu kuphuhliso isicelo ngokukhawuleza kunye Yeenguqulelo Ezisebenza kunye.

Le nkqubo isekelwe phezu zeStudiyo zokuBonakalayo inkqubo Shell Ukubakude exhasa uqwalaselo esongwayo kunye nokwandiswa developers zomntu wesithathu. Kwi-Internet, kukho iindawo ezininzi apho ungafumana onke ayimfuneko ulwazi kunye isampuli ikhowudi ukuphuhlisa izixhobo zawo zolawulo kunye data.

Ngokutsho ngokuqinileyo uphando Forrester Uphando, Database Microsoft SQL Server 2012 server database kwi iinkokheli eziphezulu market data kubekwa lwamashishini ezintathu ekupheleni kuka-2013. Iingcali zithi share lemarike ukukhula-Microsoft kungenxa ngendlela edityanisiweyo yequmrhu inkqubo zoshishino esizisebenzelayo. SQL Server Microsoft liqonga mihla ukwenzela ulawulo kunye nokugcinwa zonke iintlobo, intw 'izixhobo zohlalutyo kunye nophuhliso. Ngokwahlukeneyo, kubalulekile ukukhumbula lula ukuhlanganiswa kunye neemveliso enye inkampani yakhe, afana ne-Ofisi kunye SharePoint.