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...

Be Responsible in your blogging and posting

I have been awarded the MVP award from Microsoft a few years in a row and it’s an honor, but...

Don't Throw Something New In At Production Deployment

This post comes from a conversation I had with a developer last week as well as my experiences over the...

Free Events – It’s All About Expectations

Isn’t free enough? If you go to a free event do you have a right to complain? Or, if you...