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 is part 1 and the SSAS post will be separate. To start with, thank you for joining if you did attend the webinar. All of us at Pragmatic Works that do the webinars really do it because we enjoy giving back to...
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 you created a PowerPivot library and don’t have Silverlight installed. The list could go on. Luckily setting the default view is really simple. Navigate to the library which you would like to change the default view...
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 Free Training videos here. I had several people ask about PASS Summit. So here is a link to the Summit page (). It is being held in Charlotte, NC in just a couple of weeks, October 15th to October 18th. There were...
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 create a new document library and want to add the ability to create data sources, reports or even just launch report builder you will need to add new the reporting services content types to...
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 want to miss those. My topic this week is going to be SSIS Tips and Tricks. Find all the relevant information after the break! Topic: SSIS Tips and Tricks Instructor: Bradley Schacht...
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: Download and Install Windows Server 2012 If you don’t already have a blank image with Windows Server 2012 you can download the trial version directly from Microsoft here The trial will allow you to try out all...
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 all over the place in system tables in PDW. There is a simple solution, convert the value to something like VARCHAR. Well this wouldn’t be a blog post if that was all I had to say on...
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 recording here. You can also check out all the Pragmatic Works Free Training videos here. I discussed why data mining is useful to organizations, showed how to download and install the plug-in using Excel 2013 and then how...
SharePoint SSRS “The permissions granted to user 'DomainUser' are insufficient for performing this operation”
Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with my SharePoint environment after a restore did go wrong. I was planning on blogging a bunch of it and thanks to time constraints I had to just get it backup and running and couldn’t take down notes about most of it. After getting everything back up and running I thought I was good to go...
SQl Server 2014 CTP1
CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can go grab it now! If you are curious about some of the features here is the Microsoft page and there are plenty of blogs out there as well: This is preview software so be sure to read up on the release notes and install on a virtual machine to ensure nothing mission critical gets messed up. Happy data...