(Robert Sheldon) With the release of SQL Server 2008, Microsoft introduced Extended Events, a system for collecting event-driven data about a SQL Server instance and its databases. The Extended Events feature required a smaller footprint than trace events and supported a robust programmatic interfac

(Pinal Dave) It is interesting to see how a blog evolves with the time and user interacts with each blog post. Earlier I wrote two of the blog posts on NOWAIT and SET LOCK_TIMEOUT. I have received very good response on this subject. Please read following two blog posts before continuing this blog po

(Arshad Ali) During SSIS package development we can add a data viewer to the data path of the data flow task to analyze the data passing through the data path or the pipeline, but once the package is deployed (or when not using Business Intelligence Development Studio) there was no built-in support

(Vikas Munjal) SQL Server has introduced a functionality to pass a table data form into stored procedures and functions. This feature greatly simplifies the process of developing. The reason being, we need not worry about forming and parsing XML data.

(Kenneth Fisher) I recently got the following email: “I just keyed in two rows into a table with all identical column values. How do I get rid of just one of them?”

(Greg Larsen) As I get older it seems like time marches on faster and faster. But in reality the passing of time is a constant. Maybe it is because I am get older and I have more memories of dates and times of the past that makes it seem like time passes faster.

(Jon Gallant) I just got this error when doing Merge Replication on a SQL Server 2005 environment:

(Chad Churchwell) Often times as a SQL Server DBA we find databases that appear on our servers that are not part of our backup plan or maintenance plan. This could be a DEV server where developers have CREATE DATABASE (MSDN) permission or other applications where Admins can create databases using th

(Andrew Novick) After more than 25 years of working with Microsoft SQL Server, you’d think pretty much everything has been done at least once. I thought it would be a challenge to find anything surprising in a product with roots going back to the mid-1980s.

(satnam singh) This article describes a simple procedure we implemented to ensure that the data on our the database on the Disaster Recovery server is consistent with the production server. Our DR Server is a separate server which is located in a separate data centre.