May 2006 - Posts

SSIS 64 Bit Gotchas - Part 1

I'm at a client engagement this week, which has been extremely fun in learning the more subtle issues isses with 64 bit with SSIS. The first gotcha I alread knew but need to make sure you have a heads-up on is that Visual Studio is only a 32 bit application, which means you will not see BIDS on a 64 bit box by default. You can see Managment Studio though.

I was doing performance testing of the DB2 driver and noticed that it was working great until I deployed to the SQL Server's IA64 server. Once I deployed, and executed the package by using Management Studio from the Package Store, it took anywhere from 40%-100% slower. After much tormoil and some great help from some great people, we found out that when you execute a package from the Package Store in Management Studio on the box, it uses the 32 bit version of DTSExec.exe. The marshalling process of going back and forth between 64 bit and 32 bit caused a larger slowdown. Problem was fixed upon scheduling the package or copying the command out of DTSRunUI and executing DTSRun.exe from the command prompt, which uses the 64 bit version of the utilitiy. After that, everything worked great!

We've found loads more gotchas so more to come!

-- Brian Knight

Using the Dedicated Administrator Conection

You should only use a dedicated administrator connection (DAC) in special occasions. For example, in some cases, you may find that a user is running a query that has utilized all of your systems resources. The user may be using so much of the system’s resources that no other users, including yourself can login to the system to kill the users connection.

This would be a great use for the DAC. Under this situation before, you would have to stop and start the SQL Server if some time had passed. With the DAC enabled, you as a DBA can login if you had sysadmin rights by qualifying the server with ADMIN:. For example, if you wanted to login into the localhost machine you would use ADMIN:localhost. You will receive an error if the feature is disabled. To enable the feature, go to the SQL Server Surface Area Configuration. After it is enabed, you must stop and start the SQL Server instance.

For more information about Surface Area Configuration, go to

-- Brian Knight

New SSIS, SSAS, and SSRS Classes Available

Wow, I've broken the number one blog rule. I've been busily writing these three BI classes, that I haven't had time to eat, much less blog. My apologies! Well back from the long lull, the classes are now complete and will be given in Jacksonville (Jax) and other cities around the country soon. Here's the upcoming schedule. Each topic is two days in total and the combo makes 4 days. After giving the SSIS class a number of times, we're expanding it to give you more hands-on topics so when you leave the class, you will truely know how to implement solutions.

Designing and Implementing SSIS Solutions  - July 18th - 21st in Jacksonville
Designing and Implementing SSIS Solutions - July 24th-27th in Orlando
Designing and Implementing SSIS Solutions - Oct 2-5, 2006 in Orlando

--- End Series 1 ----

SSIS / SSAS August 22nd - 25th in Jax
SSIS / SSRS Sept 19th - 22nd in Jax
SSAS / SSRS Oct 24 - 27th in Jax

Email for any of these three above classes.
--- End Series 2 ----


Price: The classes run  $2,200 for 4 days.

-- Brian Knight


Free High Availability Event in Many Cities

Microsoft, HP, and PolyServe, in conjunction with AMD and Avanade, are sponsoring SQL Server 2005: Make it Real, an informative half-day event where attendees can learn how to quickly and easily migrate to SQL Server 2005. With proven techniques and technologies around consolidation, simplification and scaling, Microsoft, HP and PolyServe can cut SQL Server management costs by over 50% and enable breakthrough performance from your database. Upcoming locations include Boston, New York, Chicago and Dallas. To register, and for more details, visit
Here is the agenda for the Boston show. The presentations are the same, but the speakers change from city to city.

8:30am - 9:00am
Registration and Breakfast

9:00am - 9:40am
“The Benefits and Features of Migrating to SQL Server 2005”
Alex Onik, ISV Platform Advisor, Microsoft

9:40am - 10:20am
“Finally, a Consolidation Solution for Mission-Critical SQL Server 2005”
Michael Callahan, Chief Technology Officer & Founder, PolyServe

10:20am - 10:35am

10:35am - 11:15am
”Beyond a Better Server – HP BladeSystem”
Steve Tramack, HP Alliance Team, Hewlett-Packard

11:15am - 11:50am
“Accelerating the Time to Benefits for SQL Server Migration”
Allan Hirt, Senior Consultant, Technology and Infrastructure Practice, Avanade

11:50am - 12:00pm
Wrap-up & Raffle Drawing

12:00pm - 1:00pm

-- Brian Knight