The effects of an SSD on SQL Server Performance

I.                    Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me.  Being a...

transparent data encryption steps

In this blog post I show steps that are needed to enable Transparent Data Encyption on a SQL Server 2012...

reconfigure vs reconfigure with override

You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In...

SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint

This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing...

Learning solid SQL Server and Business Intelligence skills through online training

I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL...

SQL Server 2008 R2 Service Pack 2

Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through...

How To Prevent SELECT * The Evil Way

SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on...

Color Expressions in SSAS Calculations

Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a...

SQL Saturday #150 Baton Rouge 2012

Baton Rouge SQL Saturday is Saturday, August 4!

 We expect ~400 attendees at the brand new LSU Business Education Centre of...

Different techniques to identify blocking in SQL Server

SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...