SQL Server 2017 Editions

SQL Server 2017 (Code Name Helsinki), which is yet to be released officially, will come with many new Database Engine features, enhancements, and performance improvements. These includes Resumable online index…

Read more »
How to send email from SQL Server

How to send email from SQL Server

Email functionality is integrated in almost every website and application now a days. Microsoft SQL Server also supports sending emails. Even though it is not recommended to use SQL Server…

Read more »
difference-breadth-principal

Difference between Breadth and Principal Editions

The SQL Server editions are classified into two editions “Principal Editions and Breadth Editions”.

Read more »

This backend version is not supported to design database diagrams or tables

Creating or modifying a complex table correctly using solely SQL can be tricky, but SQL Server Management Studio’s Table Designer feature has make it very easy. But sometimes when you…

Read more »

Find Version of SQL Server

There are various ways to find out version of SQL Server being used. I will list two of them which are commonly used.

Read more »