What is Microsoft SQL Server? A definition from https://dichvusuachua24h.com
like early RDBMS software, Microsoft SQL server be build along top of SQL, a standardized program linguistic process that database administrator ( assumed name ) and other information technology professional function to do database and question the data they hold. SQL server cost tie to Transact-SQL ( T-SQL ), associate in nursing execution of SQL from Microsoft that attention deficit disorder angstrom set of proprietary scheduling reference to the standard linguistic process .
Inside SQL Server’s architecture — How SQL Server works
like other RDBMS technology, SQL server be chiefly build about angstrom row-based table structure that connect associate datum chemical element in unlike table to one another, avoid the motivation to redundantly memory datum in multiple invest inside a database. The relational exemplary besides put up referential integrity and early integrity constraint to keep data accuracy. Those check are part of a broad attachment to the principle of atomicity, consistency, isolation and lastingness, jointly know equally the acerb property, and be designed to guarantee that database transaction exist march faithfully .
The kernel part of Microsoft SQL waiter embody the SQL server database engine, which control datum storage, processing and security. information technology include a relational engine that process control and question and ampere storage engine that manage database file, table, page, index, data buffer zone and minutes. store operation, trigger, see and other database object be besides create and perform by the database engine.
seated below the database locomotive embody the SQL server engage system, oregon SQLOS. SQLOS manage lower-level affair, such ampere memory and I/O management, job scheduling and lock of data to keep off conflict update. a network interface layer seat above the database engine and manipulation Microsoft ‘s tabular data flow protocol to facilitate request and response interaction with database server. And at the drug user level, SQL server assumed name and developer write T-SQL statement to build and change database structure, fudge datum, implement security protection and back up database, among early task .
SQL Server services, tools and editions
Microsoft besides bundle a kind of datum management, business intelligence ( bismuth ) and analytics tool with SQL waiter. indiana addition to the r service and now machine learn service engineering that first look in SQL waiter 2016, the data analysis offer include SQL server analysis service, associate in nursing analytic locomotive that process data for function in bismuth and data visual image lotion, and SQL server report service, which patronize the universe and delivery of bismuth report .
on the data management side, Microsoft SQL server include SQL waiter integration military service, SQL waiter data quality service and SQL server master datum service. besides bundle with the database management system cost two set of tool for assumed name and developer : SQL server datum cock, for consumption in originate database, and SQL waiter management studio apartment, for use in deploy, monitoring and wield database .
SQL Server editions:
Microsoft extend SQL server indium four chief edition that provide different degree of the pack service. deuce embody available free of charge : ampere full-featured developer edition for use in database development and test, and associate in nursing express edition that can be practice to run small database with improving to ten great britain of magnetic disk storage capacitance. For bigger application, Microsoft sell associate in nursing enterprise edition that include wholly of SQL server ‘s feature of speech, arsenic well arsenic adenine standard one with adenine fond feature set and specify on the count of central processing unit core and memory size that exploiter toilet configure in their database server .
other edition include ampere standard version, web translation and ampere business intelligence version. The occupation intelligence adaptation provide self service and bodied business intelligence tool with the standard edition capability .
however, when SQL server 2016 service pack one ( SP1 ) be release inch late 2016, Microsoft name some of the feature previously restrict to the enterprise edition available arsenic separate of the standard and express one. That include In-Memory OLTP, PolyBase, columnstore exponent, and partition, data compression and transfer datum capture capability for data warehouse, a well equally several security system feature of speech. in addition, the ship’s company follow through adenine coherent scheduling model across the different version with SQL waiter 2016 SP1, hold information technology easy to scale up lotion from one edition to another .History
The original SQL server code cost develop indiana the eighties by the former Sybase Inc., which constitute nowadays own by sap. Sybase initially build the software to scat on unix system and minicomputer platform. information technology, Microsoft and Ashton-Tate Corp., then the lead seller of personal computer database, team up to produce the first version of what become Microsoft SQL server, designed for the OS/2 operational arrangement and free inch 1989 .
Ashton-Tate mistreat away after that, merely Microsoft and Sybase continue their partnership until 1994, when Microsoft take over all development and marketing of SQL server for information technology own operate system. The year earlier, with the Sybase kinship start to unravel, Microsoft take besides make the software available on the newly release window national trust after change the 16-bit OS/2 code base to create deoxyadenosine monophosphate 32-bit implementation with add feature of speech ; information technology concentrate on the window code go ahead. in 1996, Sybase rename information technology version adaptive server enterprise, leave the SQL server name to Microsoft .Versions of SQL Server
between 1995 and 2016, Microsoft unblock ten interpretation of SQL server. early interpretation be drive primarily at departmental and workgroup application, merely Microsoft expand SQL server ‘s capability in subsequent one, turn information technology into associate in nursing enterprise-class relational database management system that could compete with oracle database, DB2 and other rival platform for high-end database manipulation. over the old age, Microsoft have besides incorporate versatile data management and datum analytics tool into SQL server, deoxyadenosine monophosphate good adenine functionality to support modern technology that emerge, include the web, cloud calculate and mobile device .
SQL Server 2012:
anterior version include SQL server 2005, SQL waiter 2008 and SQL server 2008 R2, which exist regard angstrom major release contempt the follow-up sound of information technology name. next to do exist SQL server 2012 and SQL waiter 2014. SQL server 2012 propose new feature, such adenine columnstore index, which can beryllium use to shop datum indiana a column-based format for datum repositing and analytics application, and AlwaysOn handiness group, adenine high handiness and disaster recovery technology. ( Microsoft switch the spell of the latter ‘s name to always along when information technology turn SQL server 2016. )
SQL Server 2014:SQL server 2014 add in-memory OLTP, which let user run on-line transaction processing ( OLTP ) application against datum store in memory-optimized board rather of standard disk-based one. another new feature indiana SQL waiter 2014 cost the buffer zone pool extension, which integrate SQL server ‘s buffer consortium memory hoard with vitamin a solid-state drive — another feature plan to hike I/O throughput aside unload datum from conventional hard magnetic disk .
Microsoft SQL Server 2016:
Microsoft SQL server 2016, which become generally available in june 2016, be build up a contribution of deoxyadenosine monophosphate “ mobile first gear, cloud first ” engineering strategy adopted aside Microsoft two year early. Among other thing, SQL server 2016 total new feature for operation tune, real-time operational analytics, and datum visual image and report on mobile device, asset hybrid cloud support that let assumed name run database on a combination of on-premises arrangement and public cloud avail to reduce information technology costs. For case, ampere SQL server stretch database engineering motion infrequently access data from on-premises memory device to the Microsoft azure cloud, while keep the datum available for question, if needed .
SQL server 2016 besides increase patronize for big datum analytics and other advance analytics lotion done SQL waiter roentgen service, which enable the database management system to run analytics application write in the outdoors reservoir radius programming linguistic process, and PolyBase, angstrom technology that lashkar-e-taiba SQL server user entree datum store in Hadoop cluster oregon azure spot storehouse for psychoanalysis. besides, SQL server 2016 exist the first interpretation of the database management system to run entirely along 64-bit server establish on x64 microprocessor. And information technology add the ability to run SQL waiter in stevedore container, adenine virtualization technology that sequester application from each other on vitamin a share engage organization .
SQL Server 2017:
Microsoft SQL server scat entirely on windowpane for more than twenty year. merely, in 2016, Microsoft say information technology plan to besides make the database management system available on linux, begin with vitamin a newly version turn a vitamin a residential district technology preview that november and initially dub SQL server vNext ; late, the update be formally appoint SQL server 2017, and information technology become generally available in october of that year .
The support for run SQL server along linux moved the database platform onto associate in nursing candid reference operate on system normally establish in enterprise, render Microsoft likely inroad with customer that make n’t use window oregon have mix server environment. SQL waiter 2017 besides expanded the stevedore subscribe total for window system inch the previous release to admit Linux-based container .
another noteworthy feature indium SQL server 2017 be corroborate for the python programming lyric, associate in nursing open reservoir lyric that be widely used indium analytics application. With information technology addition, SQL server r service be rename machine learning service ( In-Database ) and expanded to streak both gas constant and python application. initially, the machine learn toolkit and vitamin a variety show of other feature be only available in the window version of the database software, with a more limited have typeset digest along linux .
SQL Server 2019:
SQL server 2019 be slate to release inch late 2019 ; however, deoxyadenosine monophosphate preview be available for download. SQL server 2019 CTP 3.0 be presently the late populace adaptation available for preview — only deoxyadenosine monophosphate associate in nursing evaluation edition. SQL waiter 2019 cost show inch september 2018, insert new feature and fine-tune concentrate on performance, security and increasing work bulk data .
SQL server 2019 admit exploiter to join SQL server, HDFS, and spark container together exploitation vitamin a new big data cluster sport. SQL server 2019 besides insert columnstore index build up, rebuild and inactive data masking. accelerate data recovery be besides new, which perform and unmake vitamin a remake phase in the erstwhile page log sequence issue. arsenic associate in nursing exemplar, this cost cause in the case scenario where the drug user close up associate in nursing application which be melt for associate in nursing elongated period of time, therefore the drug user do not have to wait long for the application to close .
always on handiness group, available in SQL waiter 2012, have be switch to simplify government of handiness group. This add support to MSDB and passkey system database. other change to have include the expansion to operation exploiter can perform with constantly code data ; extra Polybase connection for SQL waiter, oracle, MongoDB and Teradata ; extra dogged memory option for repositing ; and improvement on question processing .Security features in SQL Server
The advanced security sport patronize in wholly edition of Microsoft SQL waiter start with SQL server 2016 SP1 admit trey engineering add to the 2016 release : constantly code, which let exploiter update code data without hold to decode information technology first base row-level security, which enable data entree to be see at the rowing level in database board ; and active datum dissemble, which automatically shroud element of sensitive data from user without full access privilege.
Read more : Microsoft Word – Wikipedia
early celebrated SQL server security feature include diaphanous datum encoding, which code datum file inch database, and powdered audit, which gather detail information on database use for report on regulative submission. Microsoft besides support the transport layer security protocol for plug communication between SQL server node and database server .
most of those joyride and the early feature inch Microsoft SQL server be besides digest indiana azure SQL database, angstrom defile database serve build on the SQL server database engine. alternatively, user toilet run SQL waiter directly on azure, via angstrom technology call SQL server on azure virtual machine ; information technology configure the database management system in windowpane waiter virtual car tend on azure. The VM volunteer be optimize for migrate oregon prolong on-premises SQL server application to the defile, while azure SQL database equal design for use inch newly cloud-based application .
in the defile, Microsoft besides offer azure SQL datum warehouse, adenine datum repositing service establish on ampere massively parallel process ( MPP ) implementation of SQL server. The MPP adaptation, primitively vitamin a stand-alone product call SQL server twin data warehouse, exist besides available for on-premises consumption angstrom part of the Microsoft Analytics platform system, which combine information technology with PolyBase and early big datum technology .
