ANSI PADDING, Trailing Whitespace, and Variable Character Columns

What does ANSI_PADDING mean and how does it affect my SQL Server database?

Thoughts on SQL Server Certification

This is probably part 1 of a series, but no guarantees.

Why Certify?
I've been working with SQL Server for 10 years...

SQLSaturday Acquired by PASS – Reactions

The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...

What the Exec?

I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...

2010 Goals

It’s time to make a list of things to shoot for in the year ahead.  I did okay on my...

Where Will We PASS Each Other?

In my a post on Monday, I talked about who I want to meet while at the PASS Summit.  Today...

Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS

Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...

What happened to that email?

This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...

SQL Server Profiler Part 2: Custom Templates and Saving Data

In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.

Introduction to Profiler

This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.