Why I Don’t Run for the PASS Board

It’s getting close to that time of year when you can apply to run for the PASS Board of Directors....

An Un-CATCHable Error?

I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...

Critiquing Free Events

Yesterday I wrote about expectations at free events, basically saying they don’t differ a lot from paid events. The next...

Inserting into an XML document

I was reading through the latest XML Workshop article that I have from Jacob Sebastian. It’s a fantastic series for...

Left outer join vs NOT EXISTS

And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...

Managing Your Backup Files

I recently posted a couple of  scripts that backup all databases on your SQL Server instance to disk with a...

Plagiarism Again

Update: The problem posts have been removed from the SQLTechConsulting site.

I ran across a note from Brent Ozar (blog | Twitter)...

SQL Saturday #39 New York

New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...

Virtual Presentation : Index Statistics

I just gave a virtual presentation, courtesy of Pass and the appdev group.  The recorded presentation is available here:
Recorded Presentation
 
A...

Access Analysis Services via T-SQL?

It occurred to me the other day that it might be interesting to manage aggregates in an SQL Server database...