Monthly Archives: August 2009

SSIS and SQL Azure – Getting Started

Since SQL Azure is currently in a Community Technology Preview, the technology and this information provided below is subject to change. This post is based on the August 18th CTP. Now that I’ve been working with SSIS against Azure for … Continue reading

Posted in Uncategorized | Comments Off

SQL Azure, CREATE TABLE, and USE

I’ve been playing around with the SQL Azure CTP for a little bit, and generally, it’s going well. However, as with any new technology, there are plenty of things to learn.  I’m planning a series of posts around SQL Azure … Continue reading

Posted in Uncategorized | Comments Off

Adding Custom Components to SSIS

Below are the basic steps for adding custom components to SSIS; however, for more in-depth information I highly recommend reading Matthew Roche’s post about deploying and testing custom SSIS components.  1. Register the custom assembly in the Global Assembly Cache … Continue reading

Posted in SSIS | Tagged , , , | Comments Off

Presenting at the SQL Server Best Practices Conference

I’m going to be presenting two sessions at the SQL Server Best Practices Conference on August 24-26 in Washington, DC. This conference has a different focus than many of the technical conferences that I’ve presented at in the past. Instead … Continue reading

Posted in Uncategorized | Comments Off

The Path Specified Cannot Be Used At This Time

This morning I needed to check the properties for one of our SharePoint application pools so I logged onto the server and opened Internet Information Services (IIS) Manager.  To my surprize the root was empty; it should have automatically connected to the … Continue reading

Posted in SharePoint | Tagged , , | Comments Off