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

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