Find Members of AD Group - PowerShell Script

This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...

Monitor Deadlock in SQL 2012

Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...

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]
...

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...

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...

SQL Server: Understanding the Data Page Structure

We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...

Choosing a Mobile Workstation

I get a lot of e-mail and Twitter requests for advice about what laptop someone should buy. I don’t mind...

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...

August #Meme15 Assignment

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

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...