Microsoft Servers SQL database management usoro

First Microsoft Servers SQL version e gosiri site na ụlọ ọrụ azụ na 1988. Database ozugbo positioned dị ka a relational nchekwa data, nke nwere, dị ka emeputa, atọ uru:

• ịchekwa usoro na-eme ka a ngwa ngwa na data sample na ya ike n'ezi na-nọgidere na-enwe multi-ọrụ mode;
• na-adịgide adịgide ohere nchekwa data ịkwụpụ ọrụ enweghị nchịkwa;
• emeghe nkesa n'elu ikpo okwu, ikwe ka gị ike-atọ ndị ọzọ ngwa na-eji SQL Server.

Microsoft SQL Server 2005 n'okpuru koodu aha Yukon na enwekwukwa scalability ghọrọ ndị mbụ version n'ụzọ zuru ezu na-akwado NET technology. Mma nkwado maka ekesa data, mbụ ngwaọrụ nke akuko na analysis.

Integration na Internet ekwe ojiji nke SQL Servers 2005 dị ka ihe ndabere maka ihe e kere eke nke e-azụmahịa na usoro na mfe na ala ohere data via-ewu ewu nchọgharị iji wuru-na Firewall (firewall). The Enterprise support ukem Mgbakọ na-akparaghị ókè ọnụ ọgụgụ nke processors.

Iji dochie 2005 version wee Microsoft SQL Server 2008, nke bụ ka otu n'ime ndị kasị ewu ewu database sava, na a obere ka e mesịrị pụtara ọzọ version - SQL Servers 2012, na nkwado nke ndakọrịta na NET Okpokoro na ndị ọzọ na elu ọmụma nhazi technology na visual Studio development gburugburu ebe obibi. Ka ịnweta ojii nchekwa a pụrụ iche unit e kere SQL Azure.

Transact-SQL

Ebe ọ bụ na 1992, nke ajụjụ asụsụ SQL bụ a nchekwa data ohere ọkọlọtọ data. Fọrọ nke nta niile mmemme asụsụ iji nweta ya na-eji ya database, ọbụna ma ọ bụrụ na onye ọrụ na-eche na ọ na-arụ ọrụ na ozi ozugbo. Ihe bụ isi ahazi ahịrịokwu nke asụsụ na-anọgide na-agbanweghi agbanwe maka ndakọrịta, ma onye ọ bụla na-ere database management usoro ndomo ọzọ SQL ọrụ. A ikwere ike ịchọta, na mgbe "ụkpụrụ agha" ha abụọ isi: pl / SQL, Iha, na transact-SQL na Microsoft Servers SQL.

T-SQL usoro gbatịrị SQL iji nweta Microsoft Servers SQL. Ma nke a adịghị ewepu mmepe nke ngwa ke "ọkọlọtọ" okwu.

Machiini azụmahịa gị na SQL Server 2008 R2

Pụrụ ịdabere na ime nke azụmahịa ngwa bụ oké egwu ego taa. The nwetụrụ mfe database pụrụ iduga nnukwu losses. The database server bụ Microsoft SQL Server 2008 R2-enye gị ohere n'enweghị ihe na-ntukwasi-obi-echekwa a fọrọ nke nta na-akparaghị ókè ego nke ozi iji maara njikwa niile ọchịchị. Akwado egbuke gburugburu ruo 256 processors.

Hyper-V technology irè utilizes kacha ike nke oge a na multi-isi na usoro. Nkwado maka a plurality nke mebere processor usoro ebelata-akwụ ụgwọ na mma scalability.

nyochaa data

Iji ngwa ngwa nyochaa ezigbo oge data iyi mode bụ mee akụrụngwa SQL Server StreamInsight, kachasị maka nke a ụdị ihe aga-eme. Anyị nwere ike ịzụlite omenala ngwa dabeere NET.

Business continuity na data nche

mgbe ọ bụla otu oge na-akwado akwado arụmọrụ na-enye a wuru na-server ego akara. The nchịkwa nwere ike jikwaa arụ na usoro ego, ka a anọru ngwa iji CPU na ebe nchekwa. Ezo atụmatụ enye a na-agbanwe na uzo data nchebe na ohere log na ya.

Unlimited database size

A data nkwakọba pụrụ ịrị ọsọ ọsọ na n'enweghị. Ọrụ nwere ike iji Fast Track Ụbọchị nkwakọba ndebiri na-akwado disk arrays 48 TB. Basic nhazi na-akwado ngwa si na-eduga ụlọ ọrụ ndị dị otú ahụ dị ka HP, EMC na IBM. data mkpakọ ọrụ ọkọlọtọ UCS 2 ekwe ọzọ echekwa ojiji nke disk ohere.

Rụọ arụmọrụ nke mmepe na ndị ọchịchị

New software wizard-enye gị ohere ngwa ngwa wepu underloading sava, mma-achịkwa ma na-ebuli arụmọrụ na-enweghị mkpa maka mpụga-atọ ndị ọzọ ndị ọkachamara. Control parameters nke ngwa na nchekwa data, ịchọta ohere iji melite arụmọrụ dashboards ma mee ngwangwa mmegolite na nwụnye.

Ngwaọrụ n'ihi na onye ahịa analysis

The ụlọ ọrụ ka mgbe nwere otu echiche dị ka onye a ga-aku na nchịkọta - IT-ngalaba ma ọ bụ ozugbo na ọrụ. onye akuko usoro doziri nsogbu a site nke oge a ngwaọrụ enem irè ewu, azụmahịa usoro analysis na ịme ngosi uwe. Ọ na-ekwe kpọmkwem ịnweta ọdụ data na Microsoft Office na weèb Server. Ụlọọrụ ozi nwere ike ike na ndị ọzọ na ụdị nke ihe, dị ka map, ndịna-emeputa na video.

Adaba na gburugburu ebe obibi na-arụ ọrụ ọnụ

Enye gị ọrụ na-enweta ihe ọmụma, nkwonkwo mmepe na data analysis na iji PowerPivot ngwa ihe Excel spreadsheet. Ihe omume na-enye ohere maka analysis nke ọmụma na ịme ngosi uwe nke azụmahịa Filiks ma na-ebipụta akụkọ na-ekerịta Web ma ọ bụ weèb usoro.

Maka visual e kere eke, a usoro nke esịtidem na-akọ Report Nrụpụta 3.0, nke na-akwado a dịgasị iche iche nke formats na a dịgasị iche iche nke predefined ndebiri.

Arụ ọrụ na ọdụ data free

The ụlọ ọrụ na-enye obere oru na novice mmepe Microsoft SQL Server Express pụrụ iche free version. Nke a na-agụnye otu database technology, na nke "zuru" version of SQL Server.

Ọ na-akwado Visual Studio development gburugburu ebe obibi na Web Developer. Mepụta ọkaibe tebụl na gbara ajụjụ, ịzụlite Internet ngwa na database support, kpọmkwem ịnweta ozi site na PHP.

Jiri niile atụmatụ nke transact-SQL na kacha elu technology ohere ADO.NET na LINQ data. Ọ na-akwado ịchekwa usoro, triggers na ọrụ.

Tinye uche azụmahịa mgbagha mmiri, na optimizing database Ọdịdị ga-eme ka usoro onwe gị.

Mepụta ọgaranya akụkọ nke ọ bụla complexity. Jiri search subsystem akụkọ iwekota na Microsoft Office ngwa, na kwukwara na akwụkwọ ozi na obodo ọnọdụ.

The mepụtara ngwa nwere ike na-agba ọsọ na-anọghị nke a nchekwa data nkesa njikọ. Ngakọrịta a na-eme na-akpaghị aka site na iji proprietary technology transactional replication mmekọrịta Framework.

Dọọ ha akụrụngwa na iji management iwu niile ọdụ data na ngwa. General ọrụ ndapụta na-ebelata oge na-ebuli gbara ajụjụ, na-eke na Iweghachi backups enterprise.

SQL Server 2008 R2 Express Edition bụ ezigbo ngwangwa nkenye ọnọdụ nke saịtị na online echekwa, software maka ojiji nkeonwe, obere azụmahịa. Nke a bụ oké nhọrọ maka ibido na-amụta.

Jikwaa ọdụ data site na iji SQL Server Management Studio

Microsoft SQL Server Management bụ a pụrụ iche na ebe ndị e kere eke, ohere na management nke ọdụ data na niile ọcha nke SQL Server, gụnyere Akụkọ Services.

The usoro akọwaputa a otu interface niile atụmatụ nke ochichi nke omume site na mbụ na nsụgharị, dị ka Ajụjụ analyzer na Enterprise Manager. Administrators nwere software na a nnukwu set nke ndịna imewe na management, na elu scripting asụsụ na-arụ ọrụ nchekwa data.

Editor Microsoft Server Management Studio koodu kwesịrị nlebara anya pụrụ iche. Ọ na-ekwe gị aka ịzụlite script scripts transact-SQL, mmemme multidimensional gbara ajụjụ iji nweta data na iji nyochaa na ha na nkwado ịzọpụta pụta dị ka XML. Mepụta gbara ajụjụ na scripts na o kwere omume na-enweghị ejikọta netwọk ma ọ bụ nkesa, sochiri mmejuputa na usoro iheomume. E nwere a dịgasị iche iche nke preset ndebiri kọmpụtà usoro.

The modul "Object Browser" na-ahapụ gị na-ele na jikwaa niile ike Microsoft Servers SQL ihe na niile na sava na database ufodu. Easy ohere nri ọmụma bụ oké egwu ngwangwa ngwa mmepe na version akara.

The usoro dabeere na Visual Studio Dịpụrụ Adịpụ Shell usoro na-akwado expandable nhazi na mmụba nke-atọ ndị ọzọ mmepe. Na Internet, e nwere ọtụtụ obodo ebe ị pụrụ ịchọta ihe niile ozi ndị dị mkpa na sample code ịzụlite ha management ngwá ọrụ na data.

Dị ka nnyocha ike Forrester Research, Database Microsoft SQL Server 2012 database nkesa na n'elu atọ enterprise data warehousing ahịa isi na njedebe nke 2013. Ndị ọkachamara na-ekwu na ndị eto ngwa ngwa Microsoft si ahịa òkè bụ n'ihi ihe integrated obibia ụlọọrụ azụmahịa usoro akpaaka. Microsoft SQL Server bụ oge a na n'elu ikpo okwu maka management na nchekwa nke ihe nile ụdị, complemented ngwaọrụ nke analysis na mmepe. Iche iche, ọ bụ uru arịba ama na ala nke mwekota na ndị ọzọ ụlọ ọrụ na ngwaahịa, dị ka Office na weèb.