SQL Injection: It's not just about your data

On the topic of my SQL Connections SQL Server presentation, one of the things I pointed out about recent SQL...

Rant About Judges that Misunderstand the Role of a DBA

Part - 07 Exerpts from "The Tyranny of Bill-101" - Part 07

Commenting on how frustrating it is for DBAs to deal with...

This appears to be a system procedure..but it isn’t!

G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...

Adding a processor_description column to sys.dm_os_sys_info in SQL Server Denali

I opened a new Connect Item today, asking Microsoft to add a new column to the sys.dm_os_sys_info DMV in SQL...

S3OLV April 2011

Are you ready to learn again?  The Las Vegas SQL Users Group is ready to have our April meeting.  The meeting is to be held April 14, 2011 at...

S3OLV April 2011

Are you ready to learn again?  The Las Vegas SQL Users Group is ready to have our April meeting.  The...

Updated Overlapping Statistics Scripts

Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...

A SQL Server Hardware Nugget A Day – Day 5

For Day 5, I will be covering a few tools that can be used for hardware identification. Since quite a...

To TOP or not to TOP an EXISTS

Earlier this year I had a look at a query pattern that I often see on forums and in production...

How to Deal with Quebec’s Extremists – Report their Threats to the Police (Investigation Under Way)

 
I’m part of a Committee that is dedicated to eliminating discriminatory legislation in Quebec, here’s a statement we released last...