Development and demo environments can be hard to come by. Over the course of this series you will learn how to setup all the necessary components to create your own SharePoint 2013 demo environment. We will start with a blank Windows Server 2012 VM and conclude with a fully functional SharePoint farm including all the …
May 14
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 could click on the Actions menu and then select Open With Windows Explorer. Simple. Easy. Fast forward to SharePoint 2010. The button …
May 07
SQL Saturday Jacksonville 2013 Wrap-up
It was another great year at SQL Saturday Jacksonville. For the last several years I have been lucky enough to be part of the group that organizes the event. It’s definitely a lot of work leading up to the event, the others on the team definitely do more work than I do, the day of …
Mar 21
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 fan. I have owned every version of the iPhone, have a Mac Mini, MacBook Air …
Mar 12
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 package, not an error message from within the package. There was no history of a …
Mar 05
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 necessary in the security section. However, by default any user who is a member of …
Nov 05
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 team members. I’m looking forward to meeting a lot of new people and having a …
Sep 11
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 different. There are two options for creating tables on the disk: Replicated: The entire table …
Sep 04
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. If you are working someplace that uses the Cisco VPN client you may run into …
Sep 04
Error: No mapping between account names and security IDs was done
I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a third party tool for virtualization. In the process I decided to rebuild my VM set up and modify the layout a little. Previously I had made each VM a domain controller that needed to be …






