Microsoft Servers SQL Database utariri hurongwa

First Microsoft Servers SQL shanduro chaipiwa ne kambani shure muna 1988. Database pakarepo papi somunhu ndeyeukama Database, iro rine, maererano mugadziri, vatatu zvaanowana:

• zvakachengetwa pachishandiswa kuti nokukurumidza date yokuenzanisira uye kuvimbika kwaro anodzokororwa multi-mushandisi muoti;
• zvachose kuwana Database kuti patsanura vanoshandisa pasina adhimini;
• rakavhurika Server papuratifomu, vachibvumira kuti kusika rechitatu-party zvikumbiro dzinoshandisa SQL Server.

Microsoft SQL Server 2005 pasi bumbiro zita Yukon pamwe akanatsiridzwa scalability akava wokutanga shanduro rinonyatsotsigirawo .com michina. Kuvandudzwa rutsigiro zvakaparadzira data, zvishandiso kuti nhau uye ongororo wokutanga.

Kusangana chete Internet akabvumira kushandiswa SQL Servers muna 2005 sehwaro kwezvisikwa e-pakutengeserana enyika nyore uye yakachengeteka kuwana mashoko Via akakurumbira browsers uchishandisa pakuvara Firewall (firewall). The Enterprise rutsigiro cheteyo kadambari ane risingaperi uwandu processors.

Yokutsiva 2005 shanduro akauya Microsoft SQL Server 2008, iyo ichiri chimwe chezvinhu mukurumbira Database servers, uye zvishoma akazozviratidza unotevera shanduro - SQL Servers 2012, pamwe vatsigire kugarisana pamwe .com Pakuumbwa nezvimwe yemhando Uropi rwokugadzira uye Visual Studio budiriro ezvinhu. Kuvhura gore okuchengetera chikwata chinokosha wakasikwa SQL Azure.

Panorama-SQL

Kubvira muna 1992, mubvunzo mutauro SQL chinhu Database kuwana mwero mashoko. Zvinenge zvose zvirongwa mitauro kuwana nayo kushandisa Database yayo, kunyange kana inodzidzisa anzwe kuti ari kushanda pamwe mashoko zvakananga. The chikuru nemarongerwo mutauro inoramba kuchinja kuti kugarisana, asi mumwe mutengesi Database Kutarisira gadziriro vakaedza kuzadza okuwedzera SQL mabasa. A kubvuma akasaonekwa, uye mushure "mitemo hondo" vaiva vatungamiriri vaviri: PL / SQL, Oracle, uye Panorama-SQL muna Microsoft Servers SQL.

T-SQL Maitiro kunosvika SQL kuwana Microsoft Servers SQL. Asi izvi hazvirevi haabatanidzi pokumuka mafomu mu mashoko "mureza".

Michina yako bhizimisi SQL Server 2008 R2

Hwakavimbika nokushanda zvebhizimisi zvikumbiro vachishoropodza basa nhasi. The kuchangotanga nyore Database kungaita kuti yakakura varasikirwa. The Database Server ndiye Microsoft SQL Server 2008 R2 unokubvumira norugare uye vakachengetwa kuchengeta zvinenge risingaperi Kuwanda kwemashoko kushandisa vanoshamwaridzana chidhiraivho vakuru zvose. Akatsigira scaling kusvika 256 processors.

Hyper-V michina zvinobudirira utilizes kufadza simba ano multi-Musimboti enyika. Support nekuti muzvizhinji kuti chaivo processor gadziriro kunoderedza mari uye kunonatsiridza scalability.

kuongorora mashoko

To nokukurumidza ongorora-zvechokwadi nguva Data Hova nzira iri kushandiswa chinoumba SQL Server StreamInsight, optimized hworudzi urwu mabasa. Tinogona kuva tsika zvikumbiro kwakavakirwa .com.

Business chamazuva uye mashoko chibatiso

chero imwe nguva kutsigira Zvakanyanya Kunaka Panguva Yepamuviri chokupika inopa pakuvara Server kupfuma kuzvidzora. The Mudzviti anogona kutarisira Batsiranai mabasa uye gadziriro pfuma, tikaisa muganhu kuti chikumbira kushandisa CPU uye ndangariro. Encryption zvinhu zvinopa aida kuchinja uye yakajeka date kudzivirirwa uye kuwana nerogi zviri kwaari.

Unlimited Database saizi

A date yokuchengetera zvinhu anogona kukwira nokukurumidza uye zvakanaka. Users anogona kushandisa Fast Track Date Warehouse templates kutsigira dhisiki arrays anosvika 48 TB. Basic configuration inotsigira midziyo kubva achitungamirira makambani akadai HP, EMC uye IBM. date compression basa mureza UCS 2 kubvumira mari zvikuru kushandiswa dhisiki nzvimbo.

Kuvandudza Kushanda kwezvinhu Developers uye vakuru

New-software muuki unokubvumira kukurumidza kubvisa underloading servers, kuvandudza kuzvidzora uye optimize kuita pasina kudikanwa kwokunze chechitatu-party nyanzvi. Kuzvidzora parameters chikumbiro uye Database, vanowana mikana kuvandudza kuita mu mumadheshibhodhi uye kuwedzera ndiwedzere uye kugadzwa.

Zvaitibatsira pachako mabhizimisi ongororo

The kambani ndambobata chete pfungwa kuti ndiani anofanira kuita analytics - IT-madhipatimendi kana zvakananga vanoshandisa. pachako nhau hurongwa anogadziriswa dambudziko iri achishandisa ano zvishandiso vakachengeteka uye inoshanda kuvakwa, mabhizimisi muitiro kuongorora uye Modelling. Kunoitawo mbune Databases muna Microsoft Office uye SharePoint Server. Corporate mashoko inogona revatema mamwe marudzi zvinhu, zvakadai mepu, Graphics uye mavhidhiyo.

Yakakunakira zvakatipoteredza kushanda pamwe chete

Ipai vashandi venyu vane kuwana ruzivo, vadyi kukura uye umboo kuongorora kushandisa PowerPivot chikumbiro kuna Excel spreadsheet. Chirongwa rinobvumira kuti kuongorora mashoko uye Modelling pamusoro pezvakaitwa zvebhizimisi uye kubudisa mishumo kuudza Web kana SharePoint hurongwa.

Nokuti ziso chisikwa, hurongwa yomunyika inoshuma Report Builder 3.0, kunotsigira zvakasiyana siyana zvinogona uye zvakawanda predefined templates.

Kushanda Databases vakasununguka

The kambani inopa duku mabasa uye ruzivo Developers kuna Microsoft SQL Server Express chaiwo akasununguka Bhaibheri. Izvi zvinosanganisira chete Database michina, iro "izere" shanduro SQL Server.

It inotsigira Visual Studio kukura ezvinhu uye Web Developer. Sikai akaoma matafura uye queries, kutanga Internet zvikumbiro pamwe Database rutsigiro, mbune mashoko kubva PHP.

Shandisa zvose zviri Panorama-SQL uye zvemberi Michina kuwana ADO.NET uye LINQ mashoko. It inotsigira inochengetwa maitirwo ezvinhu, ude uye mabasa.

Kunyanya mabhizimisi pfungwa zvinoriumba, uye optimizing kuti Database mamiriro achaita kuti hurongwa pachako.

Sikai vapfumi mishumo ipi kunzwisisa. Shandisai kutsvaka subsystem mishumo nokusangana pamwe Microsoft Office mafomu, uye akawedzera kuti gwaro mashoko pamusoro nenzvimbo nzvimbo.

The dzakabudirira mafomu vanogona kumhanya pasina munhu Database Server kubatana. Yekuenderanisa zvinoitwa rwoga kushandisa proprietary Michina transactional kuberekana Sync Pakuumbwa.

Chirango kwezvivako vachishandisa utariri mutemo nokuda Databases zvose uye mafomu. General anodawo rako kunoderedza nguva optimize queries, kusika uye kudzorera backups vachida.

SQL Server 2008 R2 Express Edition rakanakira nokukurumidza nekutumirwa kwemauto nzvimbo uye paIndaneti muzvitoro, software kushandisa, bhizimisi duku. Ichi chisarudzo kukuru PANDAKATANGA uye kudzidza.

Manage Databases nokushandisa SQL Server Management Studio

Microsoft SQL Server Management ane unyanzvi hwakasiyana zvakatipoteredza pakusikwa, kuwana uye kurapa Databases uye zvose zvezvidzidzo SQL Server, kusanganisira Kushuma Services.

The Hurongwa anovamba chete inowanikwa zvose zvaidiwa rokutarisira zvirongwa mushanduro adarika, akadai Query Analyzer uye Enterprise Manager. Vakuru vakuru vane Software zhinji akagadzirwa Graphics zvakagadzirwa uye kutarisirwa, uye yemhando scripting mutauro kushanda pamwe Database.

Editor Microsoft Server Management Studio bumbiro akafanirwa vainyatsotarisirwa. Kunoitawo iwe kukudziridza manyorero mumanyoro Panorama-SQL, zvirongwa multidimensional queries kuwana mashoko uye kuongorora navo kutsigirwa kuti aponese zvabuda sezvo XML. Gadzira queries uye mumanyoro zvinogoneka pasina unobatanidza kune zvakarukwa kana Server, uchiteverwa Implementation uye nguva. Pane zvakawanda preset templates uye versioning gadziriro.

The module "Vanoramba Browser" rinopindura kuona uye kushandisa zvose revatema Microsoft Servers SQL zvinhu pamusoro servers zvose uye Database zviitiko. Easy kuwana kurudyi mashoko vachishoropodza kuti nokukurumidza kushanda kukura uye shanduro kuzvidzora.

The Hurongwa anobva Visual Studio Isolated Shell maitiro hunotsigira expandable configuration nokuwedzera rechitatu-party Developers. PaIndaneti, kune nharaunda dzakawanda apo unogona kuwana zvose zvakafanira mashoko uye mharidzo remitemo kutanga kwavo utariri maturusi uye mashoko.

Maererano nokutsvakurudza yakasimba Forrester Research, Database Microsoft SQL Server 2012 Database Server pamusoro matatu zvebhizimisi Data warehousing pamusika vatungamiri pakupera 2013. Nyanzvi dzinotaura kuti Kuwedzera Microsoft kuti musika mugove imhaka ane Integrated yokusvika yemakambani mabhizimisi muitiro kushandisa michina. Microsoft SQL Server ndiye ano papuratifomu kuti basa uye kuchengetera mhando dzose, nechimwe zvishandiso ongororo uye kubudirira. Oga, zvinokosha kuziva kudekara kusangana nevamwe wekambani zvigadzirwa, akadai Office uye SharePoint.