SSMS Add-ons

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on...

Where are my 32-bit Perfmon Counters?

I have run into this before, but not in this same way, so I decided it would be worth writing...

Why is there a sysobjects when we already have sys.objects?

Once upon a time in a version of SQL far far away we had system tables that were easy to...

A few words about simplicity: Using Red-Gate Ecosystem framework

In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...

Presentation Slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas.  The abstract is below.  Great...

PROVIDING LOGGING INFORMATION AT COMMAND LINE

For providing logging information at command line utility use the option /l

for example

dtexe /f "some path" /l "logging type; connection...

Blogging-Write More

Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the...

Building the SQLSaturday Orlando Marketing Plan–Part 5

More notes, many from a chat with Kendal.
We wish we could see the open rate on email and an...

Building the SQLSaturday Orlando Marketing Plan–Part 6 (Seminars)

Seminars (aka “pre-cons”) have been part of the DNA of SQLSaturday going back to #1. For those that weren’t there...

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to...