Querying the Management Data Warehouse for Disk Usage over time (Data Collector)

A part of every DBA’s job is to justify all those disk space requests. The phrases “I just need it”...

Schedule Announced for SQLSaturday #151 in Orlando

We had 45 speakers submit sessions this year. Sticking to our tradition here in Orlando, we accepted as many speakers...

Ever Want to See How a Hand Plane Works?

If you’re interested in woodworking, read on!
I’ve been thinking of making a hand plane out of wood and was doing...

How to find SQL Agent Jobs without Notification Operator Configured?

We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...

How to list all CLR objects inside your database?

I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...

August #Meme15 Assignment

I haven’t done a #meme15 blog assignment in a while and figured I would pop one off as the weekend...

Don’t Miss This Presentation

Next Wednesday (Aug 15, 2012) my friend Brian Kelley (blog, LinkedIn, Twitter) is presenting for the PASS Professional Development chapter...

Execution Plans … In the Cloud!

If you’re moving to a fully-fledged SQL database as part of Azure you may never even touch SQL Server Management...

Going to Seattle for More SQLSkills!

Last April I experienced the most amazing training event I have participated in so far in my life (yet).

I actually...

Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server

The PASS Data Architecture Virtual Chapter hosts none other than Dr. SQL Louis Davidson as he helps application and database...