Programmer's Edge

Speaking at IndyPASS in November

I will be speaking at the IndyPASS meeting in November. The topic will be Powershell in SQL Server 2008. Look out on the IndyPASS website for more information to be posted in the next few days! http://www.indypass.org [http://www.indypass.org/] AJ

Cross Page Posting in ASP.NET

I answered a question on the forums today with someone asking about the PreviousPage property that we have access to now. Basically, the question was Okay now I have the previous page but I want to cast it to that partial class type and it says it can’t find

SMO Tips & Tricks: BEWARE the scary Connect option!

So if you are playing around in the SMO codescape you may have noticed the in the server object you have a connect method available …specifically Server.ConnectionContext.Connect While it may seems perfectly reasonable that you would want to control the destiny of your connection object…you will want

SMO Tips & Tricks: Improving SMO Performance.

One of the few limiting factors with SMO is that if you do not know what you are doing and iterating through large numbers of databases it will seem extremely slow…..If you would look through profiler you would see why. Everytime you call on an object property it makes

SSIS Tips & Tricks: Easiest way to implement SFTP

So if you are trying to use SSIS to do SFTP for a project and do not have a budget to just go out and buy a widget then here is a pretty quick solution for you. 1. Download and install WinSCP from here [http://winscp.net] 2. Create a

Using SMO Part I : Enumerating Servers

I should be posting a different but smaller network monitoring application [https://indeni.com/network-monitoring/] that I have had to code in the last week or so, to help me out at work. I have created one previously but I wanted to tackle a new version since both would demonstrate

Clustering SQL Server 2005 Integration Services

For those of you that have ever clustered SQL Server 2005 before. Here is a good reference from Microsoft about clustering Integration Services. As you may well know, Integration Services is not ‘clusterable’ out of the box during the installation which is kind of a drag when your trying to

SQL Server 2005: Using Web Services in SSIS Data Flow

Here is a good trick.I have used this to teach people how they need to ensure that they know what limitations there are in SSIS. Basically, if you are only using what SSIS, or any system for that matter, gives you out of the box, then you are missing

Writing to a Variable in SSIS Script Component

Someone had asked me over the weekend a very interesting question. They are needing to grab the values from a particular column and then input them into a series of variables. 1 column entry = 1 variable. They were wondering how to accomplish this with SSIS. So I thought I would

IndyTechFest 2008!

Well for those of you whom decided to miss IndyTechFest [http://www.indytechfest.org] because you slept in on Saturday missed out on one hell of an event. With about 500+ people in attendence this was one of the most electrifying events of the year and it’s good to

SSIS: Using IF(IIF) logic in Derived Column

Just a short reminder for myself really. A lot of people tend to use a custom script in order to accomplish this logic simply because the interface for the derived column data object simply does not spell out how to accomplish this. In order to place an IF statement for

Advanced Excel Manipulation in SSIS: Part I

This is a 2 part post of some advanced techniques that I am hoping to demonstrate this weekend in my IndyTechFest presentations. The premise is that you need to take an Excel workbook and process all of the sheets within the workbook in some way. Now SSIS is normally cool

Microsoft/Oracle Event Presentations

Good Morning everyone! Well, we got through the joint Microsoft/Oracle and it seemed to be a rousing success. We had well over a hundred people in attendance which seemed great to me. Everyone engaged with a lot of energy and enthusiasm. Thanks to everyone who came. Here are my

Reporting Services Introduction

A introduction to reporting services with a short demo report application. Download Files [https://www.programmersedge.com/Files/SSRSExample.zip]

SSIS Introduction

An introduction to SSIS with a small example project. Download Files [https://www.programmersedge.com/Files/SSISExample.zip]

IndyPASS Presentation: SMO and RMO introduction.

Here are the presentation slides and sample website code for my IndyPass presentation tonight. I am presenting a talk on using Server Management Objects (SMO) and Replication Management Objects (RMO). Once you learn how to use these your life as a DBA can become a whole lot easier. IndyPASS presentation!

T-SQL Enhancements in SQL Server 2005 & 2008

Here are the slides and some of the demo code I used for my T-SQL Enhancements presentation on the 14th. T-SQL Enhancements [https://www.programmersedge.com/files/T-SQL%20Enhancements.zip] Cheers, AJ

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 [https://www.

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

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 [https://www.programmersedge.com/Files/SSIS_HandsOnClass.zip] Cheers, AJ

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

SQL Server 2008 Release Pushed Back!

You can read the depressing news here…… The Data Platform Insider [http://blogs.technet.com/dataplatforminsider/archive/2008/01/25/microsoft-sql-server-2008-roadmap-clarification.aspx] 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

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

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

PTI Learning Series 1: Post-Morten

As promised, here are the slides from my presentation. Thanks to all whom attended the event and hopefully you will join us for the next one. Feel free to contact me with further questions by using the contact tab and keep looking on http://events.perptech.com for further event