Archive | February, 2008

Eli Lilly Lunch & Learn Slides

Here are the slides from my presentation today for the Eli Lilly Lunch & Learn session. It is an overview of replication titled. Replication Demystified   It has a lot of good stuff in it..so enjoy and if you have any questions feel free to ask! Replication Presentation Cheers,AJ

Read more

SMO Presentation Slides

Here are Server Management Objects(SMO) presentation slides from the February 21st event. Feel free to email me if you find any thing that you have issues with concerning SMO. I will be trying to put up a short series of blogs demonstrating some of the things programmatically you can do using SMO. Slides Cheers,AJ

Read more

SSIS Hands-On Class: Slides and Booklet

The link for the slides and the handout booklet for the exercises for last week’s SSIS class can be found at the link below. Presentation Files Cheers,AJ

Read more

SMO Presentation

This Thursday is PTI’s next Learning Series Event. I will be presenting on DBA Toolkit:SMO. It should be a fun 3 hour run through as I have plenty of demos ready to show how powerful the SMO paradigm is. If you haven’t signed up yet please go to the PTI events page below…http://events.perptech.com Cheers,AJ Powered […]

Read more

SQL Server 2008 Release Pushed Back!

You can read the depressing news here…… The Data Platform Insider If you read the whoe blog entry it makes it sound like this is a fanatastic thing and I guess you have to put the best spin on things. What depresses me is that I have asked several times at various events about the […]

Read more

SSIS: Excel Import in a 64 bit Environment……

Another handy tip for everyone out there deals with handling an Excel file import on a 64bit environment. Now the problem that arises is that there is no 64bit compatible JET provider to use. This causes a slight problem when you are trying to do something like ‘upload an Excel file’ which needs the JET […]

Read more

SSIS: Running Packages in SQL Server Agent

At my talk today I ran into a couple of individuals that asked me the same question. “Why can’t I run this package as a scheduled job?”. I run across this many times in my consulting because there is a lot of documentation on deployment out there but none of it really seems to click […]

Read more