Microsoft SQL

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…

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…

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 reading this, this and this.  You’ve got all that, right?  Good!  Now, do you have a clone of my ManageETLDemo on your machine?  Is it up to date? Great! In…