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...
Most recent posts
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...
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...
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...
Installing Power View for Multidimensional Models
Power View was a new reporting option added in the SQL Server 2012 release as part of the SharePoint integrated mode of Reporting Services. From the beginning it was limited to only reporting...