Using Cell-Level Encryption in SQL Server

Industry guidance such as the Payment Card Industry Data Security Standard (PCI-DSS), Healthcare Insurance Portability and Accountability Act (HIPAA) and...

#TSQL2Day – A Day in the Life of A Service DBA

Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...

Enabling "Open Project Folder" for project types that don't support it

One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...

Office 2013 Preview – Enabling PowerPivot in Excel

With the Office 2013 announcements today I was excited to download and get my hands on the tools.  Because this is still...

Scrum what are story points

In this blog post I discuss Scrum (agile development methodology) and method to accurately estimate effort to complete sprint which...

SQL in the City – London 2012

It’s a wrap. Two days of SQL in the City are complete, and I’m back at home, almost feeling normal....

SQL Saturday #171 Pittsburgh!

It's official, there's going to be a SQL Saturday in Pittsburgh this year!

The date is October 6th, and the...

SSRS does not require IIS

Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do...

The Hollywood DBA

I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will...

What’s been happening in Wayne’s World

Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...