Most recent posts

0

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...

SSIS Tips and Tricks Q&A 1

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...

SharePoint Reporting Services Content Types Missing 5

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...

0

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...

0

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...

0

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...

Installing Power View for Multidimensional Models 9

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 off tabular models (and therefore PowerPivot...