Category Archives: Uncategorized

XML as Source in SSIS

XML is becoming increasingly popular in the workplace. Many systems are using it as a way to transmit data efficiently across the network. While XML certainly has its place, consuming it and deconstructing it can be a real headache. Unfortunately, … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

SQLSaturday #48 Recap

I presented at SQLSaturday #48 this weekend. It was a great event, and I thoroughly enjoyed it. K. Brian Kelley and the other organizers put on a great event. This was the first SQLSaturday that I’ve been to in a … Continue reading

Posted in Uncategorized | Tagged | Comments Off

Create XML Fragment in SQL Server

The XML datatype, first introduced in SQL Server 2005, can be very  handy when utilized properly. It is an industry standard, and with it, it is easy to import/export data across different servers, as well as different systems entirely. This … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off

Exception: Microsoft.SharePoint.SPException: User cannot be found – Sharepoint 2010 Installation Failure

Today I found myself trying to install Sharepoint 2010 on my laptop running Windows 7 Enterprise. After reading all of the caveats about doing such a thing, I still needed to get this done. The post that I followed was … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

Death by SQL…an Act in Two Parts

How common is it to run into performance issues with SQL Server? Daily?  Hourly? Maybe for you, it’s a common existence; and for that, I’m sorry. And how are some ways that you deal with performance degradation in SQL? I’d … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

Extracting MySql UTF-8 fields with SSIS

Last week I ran into an interesting task with SSIS.  I’m pulling data from a MySql database (5.0.79-enterprise) using the MySql ADO.Net Connector with SSIS and loading the data into a SQL Server 2008 R2 database.  This has worked pretty … Continue reading

Posted in Uncategorized | Comments Off

2 Days to SQLSaturday #46

Only 2 days until SQLSaturday #46 – if you aren’t registered yet, there’s still time. $10 for lunch, lots of great speakers, and some really interesting presentations – what better to do on Saturday? If you make it out, look … Continue reading

Posted in Uncategorized | Tagged , | Comments Off

How to Restore a Corrupt Database in SQL Server 2008 (Error 1813)

I ran into this issue the other day, and thought that I’d blog about it. I had copied a database from a co-worker (MDF files only, unbeknown to me) that I needed for my work. However, he forgot to include … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off

Migration to Word Press

We recently migrated this site from Community Server to Word Press. Most of the posts came over pretty well, but some of the code samples and pictures didn’t make it. I’ll try and get these updated and fixed over the … Continue reading

Posted in Uncategorized | Comments Off

How to Pivot Data in SSRS

Pivoting data can be tricky to say the least, whether the actual pivot is done in SQL Server or Reporting Services. There are cases to be had for both approaches, only to be constrained by your reporting design requirements. I’ve … Continue reading

Posted in Uncategorized | Tagged | Comments Off