Monthly Archives: September 2010

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

Less than 2 Weeks till SQLSaturday #48

It’s under 2 weeks to SQLSaturday #48 Continue reading

Posted in SQL Saturday | Tagged , | Comments Off on Less than 2 Weeks till SQLSaturday #48

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

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

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

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

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

Prevent SSRS 2008 from Overwriting Datasets

Report development is one of my favorite areas of Business Intelligence and I have to say I’ve been fairly happy with the new interface for SSRS 2008.  Except for when it comes to MDX queries.  Off the top of my … Continue reading

Posted in SSRS | Tagged , , , , , , | Comments Off on Prevent SSRS 2008 from Overwriting Datasets

Presenting at SQLSaturday #49 in Orlando, FL on October 16, 2010

I have a very busy schedule in October. As already mentioned, I’m presenting at SQLSaturday #48 in Columbia earlier in the month. I also have the privilege of presenting at the Orlando, FL SQLSaturday #49 Continue reading

Posted in SQL Saturday | Tagged , , | Comments Off on Presenting at SQLSaturday #49 in Orlando, FL on October 16, 2010

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