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

A Month of PowerShell – Day 21 (Backups)

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)

Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series...

Check out IT Central Station

If you get some time, head on out to IT Central Station.com. You can provide some valuable feedback on the...

Data Warehouse Architecture Presentation Slides

Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter.  There were over 200 attendees!  The recording of...

Insert multiple values sets into a table in one command

The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...

MDX #26 – SSN can only be referenced as a member property in MDX

I’ve blogged about the Properties()  function before.
MDX #11 – How to get number of cars each customer owned using Properties() function?
MDX...