Category Archives: Sql Server New Feature

SQL Server 2012 Features:5: 5. Windows server core support

In continuation of previous blog- Server Core is a minimalistic Microsoft Windows server installation option. You can install SQL Server on a Server Core installation of Windows Server 2008 R2 SP1 or Windows Server 2012. This option of windows server 2012 provides a … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature | Leave a comment

SQL Server 2012 Features:4: Contained Database

In continuation of previous blog: Contained Databases: A contained database includes all database settings and the metadata within itself which results no configuration dependencies on the instance of SQL Server. Therefore a contained database is a database that is isolated … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature | Leave a comment

SQL Server 2012 Features:3: Pagination

In continuation of previous blog: Pagination: This feature focuses on the result set of T-sql. It divides the result set into different parts to view easily. We can do pagination by using ‘OFFSET’ and ‘FETCH’ commands. We can pull only … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature, T-SQL | Leave a comment

SQL Server 2012 Features:2:Sequencing

In continuation of previous blog.. Sequencing A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence was created. This sequence is generated in an order of ascending … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature | Leave a comment

SQL Server 2012 Features:1:Column store Indexes

As promised to provide little glimpse of each feature from the definition point of view, I am ready to deliver each feature each week for your kind notice. Column store Indexes: A columnstore index is a technology for storing, retrieving and managing … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature | Tagged , | Leave a comment

Interview Question:Important New Features of SQL Server 2012, 2014 & 2016

Questions may be asked from the DBA prospective so I tried to collect few important features for SQL Server 2012,2014 and 2016 . Next blog will be published with explanation for each feature. SQL Server 2012 Features:- Column store indexes … Continue reading

Rate this:

Posted in Sql Server, Sql Server New Feature | Leave a comment

Database Engine Feature Enhancement: SQL Server 2014

Database Engine Feature Enhancement: SQL Server 2014 There are many new features available in SQL Server 2014 from the point view of admin and developers. I have listed few features below which are important for the admin prospective. The brief … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature, windows azure | Tagged , , , , | 2 Comments