Learn how you can manipulat XML documents solely in memory. No file required.   Read more...

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port  Read more...

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...

The query tells whether sql server enterprise edition is using any enterprise level features or not   Read more...

This script will create a job and it will send a mail whenever SQL server restarts.  Read more...

A PowerShell script which will guide you through an interview and produce the configuration file(s) necessary for an unattended installation of SQL Server 2008/2008R2.  Read more...

Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.  Read more...

This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.  Read more...

Not everything in SQL Server is documented and Steve Jones doesn't think that everything should be. However some features are used often and should have additional documentation.  Read more...

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.  Read more...

The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.  Read more...

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...

This article describes how to backup a database using a C# Windows Form.   Read more...

Should you be using Report Builder 3.0 or SQL Server Reporting Services 2008 R2 to build reports? Here's the 411!  Read more...

A small retake on the popular percent complete script which tell how much more time an executing command will take.  Read more...

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...

How can you tell when your SQL Server instance was last started? In this tip we look at various methods of how to get the start time for a SQL Server instance.  Read more...

Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.  Read more...