How to clone a SQL Server login and password from server A to server B.

Capturing Baselines on Production SQL Servers.

Performance comparison between SQL Server and SQL Server v.Next

This article describe on how to change the linked server password

This link refers to very basic fundamental concept where programmers have to deal with multiple data types comparison.

Basic understanding about joins with examples.

I came across some very useful SQL Server features, which I felt like must be shared.

Here in this link is the list of queries which we use regularly and how these sql queries can be optimized for better performance.

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...