Five Virtual Labs for the SQL Server 2012 DBA

Wouldn’t it be nice if you had a chance to try out the features of SQL Server?  Maybe give them...

PerformancePoint ‘Named Set’ Filter

PerformancePoint provides several options to create filters.  One of the options available is ‘Named Set’.  Within SSAS cubes we can...

Reblog: February 22 to February 28

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Something for the Weekend – SQL Server Links 01/03/13

It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server...

SQL BLOG: First Occurrence Of Character In a String

Scenario:
 We need to find the first occurrence of character ie non numeric data in the string without using the built...

SQL Server Events in the UK – March 2013

Welcome to the first of what I plan to be a regular recurring theme. Right here I will list out...

When was the last successful backup?

What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...

Windows 8 – First Impressions on a Desktop

I bought a new (to me) desktop recently to replace my aging hardware. I’ve had a quad core machine, but...

YYYYMM Math

I had a project recently where I had to do math on a number that represented a date, YYYYMM.

For example,...

"An item with the same key has already been added."

In SQL Server Reporting Services, when adding a new dataset to a report, you may see an error that looks...