Generating scripts for previous versions of SQL

I make a habit of using the latest version of SSMS even if I’m not working with the latest version...

Working with “special” names

What do you do when you need to use a special character in a name? Well, I guess I should...

“That little green arrow.” or “My code used to work but now I’m getting a debug error.”

If you’ve worked with SSMS for any length of time this will look awfully familiar:
SSMS 2008R2

SSMS 2012 +

This little green...

Keep an eye on those Audit files!

This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server...

Finding the error from a failed job.

This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you...

The powerpoint for my SQL Server Security Basics session

Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned...

Updating a view

I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...

SSMS Connection Information

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...

“sql_handle” is not a recognized table hints option.

I’ve you’ve run a query similar to the following:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);And gotten an error similar to:
Msg 321, Level...

Zombie AD Groups

I spent something like 2 hours today trying to figure out how a particular user had access to one of...