SQL Server Security: The Sum of Its Parts

When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...

SQL Street

I’m involved with with a new venture called sqlstreet.co.uk.  SQL Street is the place to shop for database experts.

Here’s a...

Time Pass With Transaction Log - Part 1

Hundreds of expert level books, articles, videos and blogs has talked much about Transaction Logs and How well to manage it.
Everything from basics...

Countdown to PASS Summit 2012 – 2 to Go – I’m Presenting Again

I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions....

Countdown to PASS Summit 2012 – 3 to Go – Setting My Schedule

Three days to go. I need to get my schedule sorted out, how about you. What influences your schedule? Since...

SSIS C Sharp #115 – C# Script to detect delta

A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways...

Ask the Unicorn: Do I have to sing at SQL Karaoke?

The PASS Summit is coming up next week and that means that as the sun goes down, a number of...

Countdown to PASS Summit 2012 – 4 to Go – SQL Karaoke, Really?

Four days to the Summit. Will you be singing? Last year was my first time attending SQL Karaoke. While I...

Don’t believe everything you read: Truncate table is not logged

Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that...

Friday at Red Gate

Looks like I’m not the only one enjoying Friday.

Some of the staff at Red Gate had a Hawaiian day. Nice...