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.


After getting AD Password Authentication working with my Azure SQL server, I moved on and set up a local Active Directory domain on my home network.  I don’t think this is something every data professional should try and tackle.  I count myself extremely fortunate to have made friends with IT professionals outside the data space, and…

Read More SQL Azure and Azure Active Directory: Part Two

f you’ve been working with Azure in the last few years, you’ve noticed there is a relatively new feature that’s supposed to make identity management easier with your Azure solutions: Azure Active Directory (AAD).  This feature does work with Azure SQL Servers and Azure SQL Databases.  But it may not completely plug and play.  In…

Read More SQL Azure and Azure Active Directory

One of the questions I get when teaching others how to use Biml is how do you deal with sensitive information like usernames and passwords in your Biml Solution. No one wants to leave this information in plain text in a solution.  You need access to it while interrogating your sources and destination connections for metadata.…

Read More SSIS Parameters and Sensitive Information