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

Presentation Materials “A Function is a Function”

Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...

SQL BLOG: Using Triggers for creating history tables in SQL Server

Case Study:1)       We  need to track the employee table in terms of new records inserted along with the datetime stamp
2)     ...