Per Member Per Month Per 1000 Calculations in MDX

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...

Performing an INSERT from a PowerShell script

This code demonstrates how to do an INSERT into SQL Server from a PowerShell script using an ADO.NET command object...

Reblog: May 17 to May 23

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

SQL – SQL Server Script to Iterate and Pull Data from All SQL Instances – Database Backup

This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to...

Ad-hoc Reporting with SharePoint Recording and Q&A

I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013.  If...

Azure does Powershell too

Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...

Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

Today I will talk about a book  titled  ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

When I...

Business Objects on Linux and SQL Server

This is just a quick post to share a lesson learned while I was on an engagement where the client’s...

DR planning article up at MSSQLTips!

My latest article is up at MSSQLTips.com:
 
Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right
 
For more of...

Exploring Excel 2013 for BI Tip #7: Retaining Pivot Table Size After Data Refreshes

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...