Category Archives: Uncategorized

XML as Source in SSIS

Posted on May 9, 2011 by jjames

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 on XML as Source in SSIS

SQLSaturday #48 Recap

Posted on October 5, 2010 by jwelch

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 on SQLSaturday #48 Recap

Create XML Fragment in SQL Server

Posted on October 5, 2010 by jjames

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 on Create XML Fragment in SQL Server

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

Posted on September 23, 2010 by jjames

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 on Exception: Microsoft.SharePoint.SPException: User cannot be found – Sharepoint 2010 Installation Failure

Death by SQL…an Act in Two Parts

Posted on September 20, 2010 by jjames

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 on Death by SQL…an Act in Two Parts

Extracting MySql UTF-8 fields with SSIS

Posted on September 19, 2010 by ddarden

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 on Extracting MySql UTF-8 fields with SSIS

2 Days to SQLSaturday #46

Posted on September 16, 2010 by jwelch

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 on 2 Days to SQLSaturday #46

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

Posted on September 14, 2010 by jjames

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 on How to Restore a Corrupt Database in SQL Server 2008 (Error 1813)

Migration to Word Press

Posted on September 13, 2010 by ddarden

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 on Migration to Word Press

How to Pivot Data in SSRS

Posted on September 10, 2010 by jjames

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 on How to Pivot Data in SSRS