Monthly Archives: September 2010

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

Less than 2 Weeks till SQLSaturday #48

Posted on September 21, 2010 by jwelch

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

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

Prevent SSRS 2008 from Overwriting Datasets

Posted on September 13, 2010 by Melinda Cole

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

Posted on September 10, 2010 by jwelch

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

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