Buy vs. Build

It’s the classic question faced by everyone in Information Services. I know how to do this and I could build...

Auditing Failed Logins – SQL Server 2008

I wrote about setting up a basic server audit recently. That showed about how a server level audit is set...

Importing binary files with SSIS

I have gotten a number of emails over the past few days asking about how I import binary files into SSIS as well as how to improve throughput by...

Importing binary files with SSIS

I have gotten a number of emails over the past few days asking about how I
import binary files into SSIS as well as how to improve throughput by...

Importing binary files with SSIS

I have gotten a number of emails over the past few days asking about how I import binary files into...

Book Review: The Yankee Years

The Yankee Years by Joe Torre ($12 @ Amazon) was a gift, and I enjoyed it more than expected. When it...

The Truth about SQLPS and PowerShell V2

With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...

When did SQL Server start and how long is the downtime window?

 
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...

BI Conference Grocery Shopping Demo

Help enter demonstration data for the Microsoft BI Conference.

Go to the shopping
demo web form and enter some transactions.

No...

Challenge 19 – An Explanation of a Query

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...