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
Certifications
Details of my certifications and how I got them.
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
What I Do…
Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.
