Most recent posts

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

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

0

Browse SharePoint in Windows Explorer

Have you ever wanted to browse your SharePoint 2010 site in Windows Explorer? If you are in SharePoint 2007 please upgrade to something a little more modern. In all seriousness, in SharePoint 2007 you...

Why I'm Considering a Surface and Windows Phone 8 1

Why I'm Considering a Surface and Windows Phone 8

Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface, Windows 8 and Windows Phone. Let me assure you that’s not the case. I...

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job 7

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job

I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with a deadlock message. This seems a bit strange given that it was a deadlock...

Remove Local Administrators SSAS Admin Access 2

Remove Local Administrators SSAS Admin Access

Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services (SSAS) administrator group at the server level. This is a pretty easy process; log...