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

Speaking for PASS Professional Development Virtual Chapter

This coming Wednesday I will be speaking for the PASS Professional Development virtual chapter. My talk will be on my...

SQL Server BI & SharePoint eBooks, Guides and Resources

There are many free eBooks & resources available from Microsoft and members of the MVP community.  This is a collection of...

Standing Desk – Flooring

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