Introduction to SQL Server at Christmas

There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...

Office 2013 BI and Mobility

I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about...

IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM

Dear Friends
Firstly, I want to say thanks for your support & liking my blogs that make it possible.
I like to share...

SQL Saturday #145 Nashville – Recap

This month has been wild. I’ve been out of town quite a bit for work, and started the month with...

SQL Server # TSQL to Convert STRING in PROPER format

Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...

When a Covering Index no longer covers

I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about...

Database Design Contest at the 2012 AITP Region 3 Student Conference

Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette.  31 different teams submitted database...

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning