N Things Worth Knowing About CTEs

If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) - new in SQL Server 2005...

SQL Saturday #28 - Keynote

I was honored to be asked to do the keynote for SQL Saturday #28 in Baton Rouge recently. It’s taken...

Default to Yes

There are a lot of times when the decision matters less than who makes it. A common if simplified example...

SQL Saturday #28 - Slides and Impressions

I’m late, I suck, but here’s some things I started in Baton Rouge and am just now getting out.
 
First, I’ll...

Mission Accomplished – Well sort of …

Did you ever set a goal and then sort of … demolish it without realizing it? That has happened this year....

Generate Insert Query in SQL

Sometimes we need to generate the INSERT script in sql server. When, we need to insert bulk of data from...

PASS Elections Portal

I think the shirt says it all
If you’ve been under a rock the last few weeks you may not know...

Changing of the Guard

A few weeks ago Andy Leonard (Blog | Twitter) announced that he was stepping down from his position as PASS Regional...

Memory

Not a sound from the pavement

Have you ever come across a SQL query that used to run faster?  Has that...

You Don’t Need Log Backups

You don’t need log backups. You don’t. They aren’t required for SQL Server to function.
The place when you don’t need...