Most recent posts

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 am a 100% openly admitted Apple...

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 on the step executing the SSIS...

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 in, add or remove admins as...

PASS Summit 2012 0

PASS Summit 2012

It’s finally here, PASS Summit 2012. Everything kicks off tomorrow and Tuesday with a couple days of pre-cons then the regular sessions on Wednesday to Friday. I’ve been in Seattle since late on Friday with a handful of Pragmatic Works...

0

Find Skew in Distributed Tables

The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the PDW provides a huge performance gain over a traditional SQL Server; however, when laying out tables it is a little...

21

Cisco VPN Client 5 on Windows 8

NOTE: Always create a backup before doing any type of Windows registry modifications!!!! With the full public release of Windows 8 right around the corner it is inevitable that people will want to get in there and check it out....