May 21

Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller

DemoEnvironment_Part1_1

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

Mar 12

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job

SSISDeadLock

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 …

Continue reading »

Mar 05

Remove Local Administrators SSAS Admin Access

BuiltInAdminsAreServerAdmins

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 …

Continue reading »

Nov 05

PASS Summit 2012

20121104-230524.jpg

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 …

Continue reading »

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 …

Continue reading »

Sep 04

Cisco VPN Client 5 on Windows 8

Error

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 …

Continue reading »

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 …

Continue reading »

Older posts «