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

Standing Desk – Flooring

My standing desk experiment has worked out well. I have gotten used to standing there and I’ve slowly found places...

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