Training

This series is an introduction to Microsoft SQL database programming. You’ll need to have a good grip on these concepts before the other classes will be as useful to you.

Read More

Career Development

Current Job Listings in your area of expertise. Search here first!

Read More

Certifications

Details of my certifications and how I got them.

RSS
Manipulating SSIS Executables with PowerShell

Welcome back to my mini-series on Powershell, SQLPSX, and the awesome things you can do with your packages through POSH. You can catch up by ...

PowerShell, SSIS Packages and Writing Variables

Last time, I introduced you to SQLPSX.  Then we spun through our SSIS packages looking for a specific variable.  That’s where I started my PowerShell ...

PowerShell Management for Your SSIS Packages

In addition to working on my database sharding presentation I’ve been working on upgrading an ETL framework.  In learning this new framework I dug into ...

Migration to Windows Azure SQL Database:Step 4 and 5

Now that you’ve completed analyzing your current database, and worked through that list of items that won’t work with Windows Azure SQL Database (WASD), it’s ...

Migration to Windows Azure SQL Database: Step 3b

Last time I walked you through how to see if your database will work with Windows Azure SQL Database (WASD) using the Migration Wizard on ...

Migration to Windows Azure SQL Database: Step 3

As promised we’re going to dive into the details on how we would actually migrate the database from your on premise server to Windows Azure ...

Migration to Windows Azure SQL Database: Step 2

Let’s continue our discussion on what it takes to migrate a database from SQL Server classic to Windows Azure SQL Database (WASD).  At this point in ...

Migration to Windows Azure SQL Database: Step 1

Last time I introduced you to Windows Azure and some of the key features: pay as you go, scalability, and ease of use.  These are ...

On-Premises To Azure Migration

I’ve been presenting this presentation all year. I’ve tweaked it a little after each section.  Funny thing is I never blogged that content… So I’d ...

Windows Azure SQL Database Backups!

If you’ve seen my OnPrem to Azure presentation, then you know one of the two big reservations I had about windows azure was we couldn’t ...