Category Archives: Sql Server New Feature

Introduction to SQL Server 2019

Introduction to SQL Server 2019 Microsoft has announced the first public community technology preview (CTP 2.0) of SQL Server 2019. It is powerful and enhanced version of SQL Server. This SQL Server 2019 has a lot of new features, enhanced … Continue reading

Rate this:

Posted in Database Administration, Microsoft News, Mirza Husain, Sql Server New Feature, T-SQL | Tagged , , , , , , , , , , | Leave a comment

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