This article explains the undocumented sp_MSforeachdb procedure in SQL server.

This article describes how to use a Logon Trigger to restrict out of office hours and limit or deny the number of connections for a specific user.

This article explains two ways to delete all the table data within a database.

This article explains the release of memory consumed by SQL Server at runtime.

This article describes Database Mail, how to configure and manage Database Mail, and what permissions are needed to use database mail in SQL server 2012.

This article shows how to find nth highest value from a database table.

In this article we learn how to generate a SQL Database script with data.

In this article, we will see some useful T-SQL for date calculation.

In this article I will explain how to get missing objects for a particular user in a database.

Here, we will take a look at how to use functions in SQL Server.

This article describes an undocumented physical row locator function in SQL Server 2008.

This article provides five ways to remove duplicate data (rows) from a SQL Server table.

In this article we will see a simple script to backup a database to disk drives.

In this article, I want to explain the Identity property in SQL Server.

This article describes error handling in SQL-Server.

Here, I will explain the need for nvarchar over varchar in SQL Server.

This article explains how to create a view and how to do an update using a view. The later part of the article explains the usage of the check option while creating a view.

This article explains how much memory is consumed in SQL Server.

In this article I show how to determine how many types of entities you have in your any database.

This article describes all the new DateTime functions introduced in SQL Server 2012 with examples.