Attaching All Databases with PowerShell–Attaching Missing Databases

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...

Busy Busy Weeks, Finally Some Good News! SQL 2008 / 2008 R2 Will Get Their Final Service Pack!

We will actually be getting our final Service Pack! 

The information can be found here. You may still want extended support...

Columnstore Memory Grant Issue

In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...

Handling Perfmon Logs with Relog

In a recent situation, I was tasked by a client to check one of their servers which they believed to...

I Voted For the 2014 PASS NomCom

I was interested to see that the online voting system has changed this year to one powered by Simply Voting....

I'm A Candidate For The 2014 PASS Nomination Committee

The 2014 PASS election cycle begins today when voting opens for the Nomination Committee (NomCom) and I'm one of eleven...

Power Pivot as the Core to your Power BI Solution

I’ve noticed a recent trend with many presentations and articles on Power BI and Excel functionality. Many of these presentations...

Recent Reading: The Food Network, And The White House!

I haven’t posted much on books lately, here are two that are different:
Inside the Food Network. Definitely some gossip, but...

SQL Server 2014 Cluster Installation Steps

Steps for SQL Server 2014 Cluster Installation :-
1) Lunch SQL Server Installation Center

2) Enter Product Key

3) Accept License

4) Check Global...

SSAS Performance Logger Now Available

I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger.  The tool allows you...