Year In Review: 2013
Ok, so it’s not quite the end of the year yet. I figured I would get a head start on things. Who says that this type of post has to come on January 1st...
Most recent posts
Webinar Q&A: Practical SSAS: Getting Started with Analysis Services
A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first was a session on how to load a data warehouse with SSIS. The followup...
Webinar Q&A: SSIS Design Patterns for Loading a Data Warehouse
I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the Q&A for my two webinars up the week I did the presentations. So here...
Setting the Default View on a SharePoint Library
There could be a number of reasons why you would want to change the default view on a SharePoint library. Perhaps you created a new view and want to make it the default. Maybe...
SSIS Tips and Tricks Q&A
Thank you to everyone who attended my webinar on SSIS Tips and Tricks on October 3, 2013. The link to the recording can be found here. You can also check out all the Pragmatic Works...
SharePoint Reporting Services Content Types Missing
Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the necessary content types are those associated with SQL Server Reporting Services (SSRS). If you...
Free SSIS Tips and Tricks Webinar
On Thursday of this week I will be presenting a webinar for Pragmatic Works Free Training on the T’s. I hear Rachel is planning on doing leprechaun facts before I present and you won’t...
Setting Up a Domain Controller with PowerShell
Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk you through a quick and easy set of scripts to get started. Step 1:...
Converting SQL_VARIANT on PDW
There are a number of data types that are currently unsupported on PDW. Among those are SQL_VARIANT. The interesting part of that is that SQL_VARIANT along with several other unsupported data types are found...
Data Mining with Excel Q&A
Thank you to everyone who attended my free webinar on August 29, 2013 where I talked about using the Data Mining Add-in for Excel. If you were unable to attend you can find the...