Author: Shannon Lowder

Shannon Lowder is the Database Engineer you’ve been looking for!
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.

Web: www.toyboxcreations.net

20140114 by Shannon Lowder 0 comments

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 managing SSIS journey. After I was able to spin through all my packages and see that some of my packages weren’t following the “standard”, I need to go into several…

20131210 by Shannon Lowder 4 comments

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 the business logic as to what the framework was trying to load, looked into all the auditing that was currently captured, and I looked for gaps when packages didn’t perform…

20131118 by Shannon Lowder 1 comment

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 time to begin testing your new solution. Testing begins with setting up your test instance of WASD, and loading your test data, then you point your application to that new…