C# Corner

It is rather good to be check for the database status before waiting for server to respond in case of failures.

Exploring SQL Server Data Tools in Visual Studio 2013

This link gives list of shortcuts of SQL Server Management Studio 2016 and 2008.

The following link explains how we can generate database back-up using a SQL command, apart from using the SQL wizard.

Query Execution Plan Basics

Database optimization techniques you can actually use.

From this resource you can have idea about SQL Server Database administration.

From this link you will know all new features of SQL Server 2016.

Follow below link for SQL Server White Papers.

The most popular videos from the SQL Server TechCenter are available for download in both WMV and MP4 formats.

Have you reached the point of having seen the term "normalization" used database literature, but you are still unsure as to just what you have to do to get a normalized database? If so, then you’re...

This article discusses about properties available for Columns in SSRS.

There are many causes of poor performance in SQL server when data grown and load on the server increased.

Create a sequence in SQL Server 2012.

This article discusses on the need to avoid multiple code blocks in a stored procedure.

This article discusses on writing script to populate date dimension without using a cursor.

This article discusses on designing database with keeping performance in mind.

In this article, author discusses on the value data compression has and efficiency gains that can be had by utilizing this enterprise-level feature.

IDENT_CURRENT column in SQL Server.