New features in different version of SQL SERVER

SQL SERVER 2000
  • Query Analyzer and Enterprise manager are separate
  • We can create maximum of 65,535 databases.
SQL SERVER 2005
  • Query Analyzer and Enterprise manager are combined as SSMS(Sql Server management Studio)
  • XML data type is introduced
  • We can create 2(pow(20))-1 databases
  • We can compress the tables and indexes
  • Varchar(max) or Varbinary(max) is available
  • SSIS is started using
  • PIVOT and UNPIVOT functions are introduced.
  • Database can encrypt
SQL SERVER 2008
  • We can able to Encrypt the entire Database
  • Introduced Back-Up Encryption.
  • XML Datatype is implemented and used.
  • FILESTREAM Datatype is introduced
  • LINQ is introduced for retrieving multiple types of data
  • Table-Valued Parameters is introduced
  • Merge Statement is included
  • Major Changes in DateTime -DATE, TIME, DATETIMEOFFSET, DATETIME2
  • The restriction has been removed for UDTs( In 2005, UDTs where restricted to max. size of  8 KB)
  • Data Synchronization is introduced.
  • It support maximum of 64 logical process in 2008 and  256 logical process 2008R2
  • It can support only 1000 partitions
  • It is uses 27 bit precision for spatial

SQL SERVER 2012
  • Code Name Denali
  • Query Page splitting is implemented in sqI2012
  • It can support upto15,000 partitions
  • It is uses 48 bit precision for spatial
  • ORDER BY Clause with OFFSET / FETCH options
  • Column store indexes -special type of read-only index designed to be use with Data Warehouse queries
  • AlwaysOn Availability Groups
  • User-Defined Server Roles
  • Enhanced Auditing Features
  • BI Semantic Model
  • Sequence Objects
  • Enhanced PowerShell Support
  • Distributed Replay
  • PowerView
  • SQL Azure Enhancements
  • Big Data Support

SQL SERVER 2014
  • Hekaton enhancements The In-Memory -  OLTP
  • Updateable Columnstore Indexes -  you must have a clustered columnstore index on the table. Non-clustered columnstores aren't supported.
  • Managed Backup to Azure
  • Azure VMs for Availability replicas
  • SQL Server Data Files in Azure
  • Resource Governor for I/O
  • Resource Governor I/O control, continued
  • Delayed durability
  • SSD buffer pool extension
  • Incremental statistics
  • Lock priority of online operations- now specify a lock priority for online re-indexing

SQL SERVER 2016
  • Always Encrypted
  • Dynamic Data Masking --  last four digits of the credit card number.
  • JSON Support -- Java Script Object Notation
  • Multiple TempDB Database Files
  • PolyBase-  SQL statements to query Hadoop, or SQL Azure blob storage
  • Query Store- With the Query Store feature, SQL Server now saves historical execution plans
  • Row Level Security
  • R Comes to SQL Server
  • Stretch Database
  • Temporal Table
  • In-Memory Enhancements - this feature is vastly improved, supporting foreign keys, check and unique constraints and parallelism.

Comments

Post a Comment

Popular posts from this blog

Get OAuth 2.0 access token of Paypal using HttpClient in c#

Here called paypal Rest API using System.Net.Http.HttpClient for OAuth 2.0 access token try  { // ClientId of your Paypal app API          string  API ClientId = " ASCxaD7FzuvGbX-xxxxxxxx.....xxxxxxxxxxx-6RZDgwLuOyrCsy3 " ;                 // secret key of you Paypal app API string   API Secret = " ENldyFXuW46R7Wv0 xxxxxxxx.....xxxxxxxxxxx ee8pyH8 " ;          using ( var client = new System.Net.Http. HttpClient ())         {              var byteArray = Encoding .UTF8.GetBytes( API ClientId + ":" + API Secret );             client.DefaultRequestHeaders.Authorization = new Headers. AuthenticationHeaderValue ( "Basic" , Conv...
Read more

Generics method using interface in c#

Implement an Interface with Generic Methods namespace  Win.Data { // Created Interface for field of table      public   interface   IFieldTable     {          string  Id {  get ;  set ; }          DateTime  TimeStamp {  get ;  set ; }          string  User {  get ;  set ; }          string  View {  get ;  set ; }          string  Name {  get ;  set ; }          //string QData { get; set; }     } // FieldString class inhirated from IFieldTable      public   class   FieldString ...
Read more

Match substring surrounded by known prefix and suffix using regex in c#

Add prefix and/or suffix to substring using regex match using c# Example 1: string strline = "This is 123 test string"; strline = Regex.Replace(strline, @"([\d])", "[$1]"); Console.WriteLine(strline); Out Put: is [1][2][3] test string Example 2: string strline = "That's first [good] mark_test"; strline  = Regex.Replace(strline, @"([^A-Za-z0-9 ])", "\\$1"); Console.WriteLine(strline); Out Put: That\'s first \[good\] mark\_test Example 3: string strline = "Hello [123] Frinds"; strline  = Regex.Replace(strline, @"([^\[])(\[\d+\])(.*)", "$1xxxxxxxxx $2 xxxxxxxxx$3"); Console.WriteLine(strline); Out Put:    Hello xxxxxxxxx [123] xxxxxxxxx Frinds Note: In this example $1, $2, $3 means respective value of match group
Read more