Powershell Day 6

Day 6 Functions and error handling As everyone aware of what is function, so no need to give therotical infomration...

SQL PASS ERC: How to Score the Interview?

One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...

Microsoft Migration Assistant v5.0 Released

As I was surfing around twitter after the marathon TV event that was the Royal Wedding came to end last...

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