This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.  Read more...

With SQL Server 2005 DMVs, we can easily find query performance statistics. Every DBA has a favorite script to find query performance stats. I also have one. But, are all the queries captured by the DMVs? In this tip I will walk through capturing some of this data and show what is capture and what is not captured by the DMVs.  Read more...

DBA's can use the Transfer Error Messages and Transfer Master Stored Procedures tasks to transfer error messages and stored procedures between difference SQL Server instances.  Read more...

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.  Read more...

This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.  Read more...

The final part of the series will examine full text catalogs and indexing, database collation, service broker considerations, encryption and high availability.  Read more...

What are the benefits of Effective Dating and what problems does it solve?  Read more...

SQL Server 2005 and 2008 provide native XML data type and provides extensive support for XML data processing. The easy conversion from XML to a relational table provides a way for set-based updates based on user input.   Read more...

In a previous tip on SQL Script Generation Programmatically with SMO, you've seen how you can use SMO to generate SQL scripts programmatically. In this tip I will cover how to generate scripts using Windows PowerShell.  Read more...

A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12  Read more...

So you’ve got some packages that regularly extract data to one or more text files, but you know that from...  Read more...