Backing Up Your Old Systems

I am currently on a project to review some older servers (SQL 2000 and 2005) for SIMPLE recovery (and therefore...

Blogging: Controlling SPAM in Orchard CMS with OpenCaptcha

When I started blogging last year, my first major decision was either to host my own site somewhere using a...

Creating Your Own Certificates

Did you know that you don’t need to go to Digicert or Thawte, or any other company to get a...

Error 14269 on SQL Server 2000

As I noted in my last post, I am currently on a project to review some older servers (SQL 2000...

Execute Multiple 2008/2005 SSIS Packages with a T-SQL

If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this...

February #Meme15 – LinkedIn

It’s the afternoon of the 16th, and time to write my #meme15 post.  Remember, these are due on or around...

Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly

SSIS Expressions
Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables,...

PowerPivot and Market Research

This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...

Spruced up query_io_reader.rb

 I built a small ruby program a while back to help with two things:

1. Quickly identify what tables have the highest IO in a particular
...

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:
 
Quickly identify what tables have the highest...