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

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

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

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

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

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

Finding the worst running query in a stored procedure

The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...

Zombie AD Groups

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