Microsoft Servers SQL database management system

Da farko Microsoft Servers SQL version aka gabatar da kamfanin da baya a shekarar 1988. Database nan da nan armashi, kamar yadda wani da zumunci database, wanda yana da, bisa ga manufacturer, uku abũbuwan amfãni:

• adana hanyoyin da cewa yin kara data samfurin da kuma mutuncin yana kiyaye a Multi-mai amfani da yanayin.
• m damar yin amfani da database to cire haɗin masu amfani ba tare da gwamnati.
• bude uwar garke dandali, kyale ka don ƙirƙirar ɓangare-na uku da cewa amfani da SQL Server.

Microsoft SQL Server 2005 a karkashin code sunan Yukon da waye, scalability ya zama na farko version cikakken goyon bayan .NET fasaha. Inganta goyon baya ga rarraba bayanai, na farko kayayyakin aiki, don bayar da rahoto da kuma bincike.

Hadewa da Internet a yarda da yin amfani da SQL Servers a shekarar 2005 a matsayin tushen ga halittar e-kasuwanci tsarin da sauki da kuma amintacce samun bayanai via rare bincike ta amfani da gina-in Firewall (Firewall). The ciniki support layi daya sarrafa kwamfuta a kan wani Unlimited yawan sarrafawa.

Don maye gurbin 2005 version zo Microsoft SQL Server 2008, wanda shi ne har yanzu daya daga cikin rare database sabobin, da kuma kadan daga baya ya bayyana na gaba version - SQL Servers 2012, tare da goyon bayan da karfinsu da .NET Tsarin da kuma sauran m bayanai sarrafa fasahar da Kayayyakin aikin hurumin cin yanayi. Don samun dama da girgije ajiya na musamman naúrar da aka halitta SQL Azure.

Ma'amala-SQL

Tun da 1992, da kuma tambayar da harshen SQL ne a database damar misali data. Kusan duk shirye-shirye da harsuna don samun damar da shi ta yin amfani da database, ko idan mai amfani jin cewa ya na aiki tare da bayanai kai tsaye. Ainihin ginin kalma da harshen ya zauna canzawa don karfinsu, amma kowanne mai siyar da database gudanar da tsarin kokarin cika ƙarin SQL ayyuka. A jayayya ba a iya samu, da kuma bayan "nagartacce yaki" sun shugabannin biyu: PL / SQL, Oracle, da kuma ma'amala-SQL a Microsoft Servers SQL.

T-SQL procedural kara SQL don samun damar Microsoft Servers SQL. Amma wannan ba ya ware da ci gaban da aikace-aikace a "misali" kalamai.

Sanya aiki da kai your kasuwanci tare da SQL Server 2008 R2

Abin dogara aiki na kasuwanci aikace-aikace ne m zuwa kasuwanci a yau. 'Yar alamar sauki database iya kai ga babbar asarar. A database uwar garke ne Microsoft SQL Server 2008 R2 ba ka damar amince da tam adana a kusan Unlimited adadin bayanai ta amfani da saba controls duk ma'aikata. Goyan bayan hawa zuwa 256 sarrafawa.

Wuce-wuri-V fasahar yadda ya kamata utilizes matsakaicin ikon zamani Multi-core tsarin. Support for a jam'i na rumfa processor tsarin rage halin kaka da kuma inganta scalability.

bincika da data

Don sauri bincika real-lokaci data kõguna yanayin ne amfani da bangaren SQL Server StreamInsight, gyara domin irin wannan ayyuka. Za mu iya ci gaba al'ada aikace-aikace dogara ne a kan .NET.

Business ci gaba da kuma bayanan tsaro

a kowane lokaci daya da goyon bayan mafi kyau duka yi na samar da wani gina-in uwar garke albarkatun iko. A gudanarwa iya sarrafa workload da kuma tsarin albarkatun, don saita mai iyaka ga aikace-aikace don amfani da CPU da ƙwaƙwalwar ajiyar. Boye-boye siffofin samar da wani m, kuma m data kariya da kuma damar log ne da ita.

Unlimited database size

A data sito iya hawansa da sauri kuma a amince. Masu amfani iya amfani da Fast Track Kwanan sito shaci don tallafa wa faifai iri-iri har zuwa 48 tarin fuka. Basic sanyi goyon bayan kayan aiki daga manyan kamfanoni kamar HP, EMC da IBM. data matsawa aiki misali UCS 2 damar more tattali amfani da faifai sarari.

Inganta yadda ya dace da developers da kuma ma'aikata

New software maye ba ka damar da sauri cire underloading sabobin, inganta iko da kuma inganta yi ba tare da bukatar waje na ɓangare na uku masana. Control sigogi na aikace-aikace da kuma database, sami damar inganta yi a dashboards da kuma hanzarta da inganci da kuma kafuwa.

Kallo don sirri kasuwanci analysis

Kamfanin ya ba da guda ra'ayin kamar yadda ya ke ya kamata a tsunduma a analytics - IT-sassa, ko kai tsaye ga masu amfani. sirri rahoto tsarin solves wannan matsala ta hanyar kayan aiki na zamani aminci da tasiri yi, kasuwanci aiwatar bincike da kuma yin tallan kayan kawa. Yana da damar kai tsaye dama ga bayanai in Microsoft Office da kuma SharePoint Server. Corporate bayanai za a iya hadedde tare da sauran iri kayan, kamar maps, graphics, da video.

Dace da rayuwarsu aiki tare

Samar da ma'aikata da damar yin amfani da bayanai, hadin gwiwa da kuma ci gaban data analysis ta amfani da PowerPivot aikace-aikace zuwa wani Excel. A shirin damar domin bincike na bayanai da kuma yin tallan kayan kawa na kasuwanci tafiyar matakai da kuma buga rahotanni zuwa raba Web ko SharePoint tsarin.

Domin gani halitta, a tsarin na ciki rahoton Report Builder 3.0, wadda ke goyon bayan wani iri-iri-tsaren da mai fadi da kewayon saitaccen shaci.

Aiki tare da databases free

Kamfanin samar da kananan ayyukan da novice developers to Microsoft SQL Server Express musamman free version. Wannan ya hada da wannan database da fasaha, da cewa daga cikin "full" version of SQL Server.

Yana goyon bayan Kayayyakin aikin hurumin cin yanayi da kuma Web Developer. Ƙirƙiri nagartaccen alluna da kuma queries, ci gaba Internet aikace-aikace tare da database goyon baya, kai tsaye dama ga bayanai daga PHP.

Yi amfani da duk siffofin na ma'amala-SQL, kuma mafi m fasahar samun ADO.NET da LINQ data. Yana goyon bayan adana hanyoyin, triggers da kuma ayyuka.

Mayar da hankali a kan harkokin kasuwanci dabaru aka gyara, da kuma gyara wajen database tsarin zai sa tsarin kanka.

Ƙirƙiri arziki rahotanni na wani rikitaccen. Yi amfani da search subsystem rahotanni hade tare da Microsoft Office aikace-aikace, da kuma kara da daftarin aiki bayanai a kan Gwargwadon matsayi.

A ci gaba da aikace-aikace da zai iya gudu a cikin rashi na wani database uwar garke connection. Aiki tare yana yi ta atomatik ta yin amfani da mallakar tajirai fasahar transactional kwafi Sync Tsarin.

Tafiyad da kayayyakin amfani da management siyasa domin duk databases da aikace-aikace. Janar aiki tatsuniyoyinsu rage lokaci don inganta queries, samar da tanadi backups sha'anin.

SQL Server 2008 R2 Express Edition shi ne manufa domin m girke shafukan da online Stores, software na amfanin, kananan kasuwanci. Wannan shi ne babban zaɓi don farawa da koyo.

Sarrafa databases ta yin amfani da SQL Server Management Studio

Microsoft SQL Server Management ne na musamman yanayi ga halittar, damar da kuma gudanar da bayanai da kuma dukan abubuwa na SQL Server, ciki har da Rahoto Services.

A tsarin tabbatar guda dubawa duk fasali na gwamnati na shirye-shirye daga baya versions, kamar Tambaya Analyzer da ciniki Manager. Ma'aikata da software da manyan sa na graphics zane da kuma management, da kuma ci-gaba scripting harshen aiki tare da database.

Edita Microsoft Server Management Studio code cancanci kulawa ta musamman. Yana ba ka damar ci gaba da rubutun rubutun ma'amala-SQL, shirye-shirye da dabaru queries don samun damar bayanai da kuma tantance su tare da goyon bayan ajiye sakamakon yadda XML. Ƙirƙiri queries da rubutun zai yiwu ba tare da a haɗa da cibiyar sadarwa ko uwar garke, ya bi ta hanyar aiwatar da lokaci. Akwai m iri-iri da saiti shaci da kuma versioning tsarin.

A koyaushe "Object Browser" yana bari ka duba da kuma sarrafa duk hadedde Microsoft Servers SQL abubuwa a kan duk sabobin da database lokutta. Easy samun dama bayanai ne m ga m aikace-aikace ci gaba da kuma version iko.

A tsarin dogara ne a kan Kayayyakin aikin hurumin Ware Shell tsarin mai goyan bayan expandable sanyi da kuma fadada na ɓangare na uku developers. A kan Internet, akwai mutane da yawa al'ummomi inda za ka iya samun dukan zama dole bayani da samfurin code wajen samar da nasu management kayan aikin da bayanai.

Binciken da kamfanin Forrester Research, Database Microsoft SQL Server 2012 database uwar garke a saman uku sha'anin data warehousing kasuwar shugabannin a karshen 2013. Masana sun nuna cewa, m girma Microsoft ta kasuwar rabo ne saboda wani Hadakar tsarin kula da kamfanoni kasuwanci tsari aiki da kai. Microsoft SQL Server ne mai zamani dandamali ga management da kuma ajiya na iri daban-daban, complemented kayan aikin na bincike da kuma ci gaba. Dabam, shi ne ya kamata a lura da sauƙi na hadewa da sauran kamfanin ta kayayyakin, kamar Office da kuma SharePoint.