Azure. Business Intelligence. SQL Server. Nerd Stuff.
SQL Server / Syndication / Windows
by Bradley Schacht · Published July 30, 2019 · Last modified July 24, 2019
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able to collect metrics for minutes, hours, or even days to gain...
SQL Server / Syndication / Windows
by Bradley Schacht · Published July 23, 2019 · Last modified July 18, 2019
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or looking to make a move to the cloud there are a few key performance metrics you’re going to want to collect. How do you know if...
Azure / Syndication / Windows
by Bradley Schacht · Published July 16, 2019 · Last modified July 19, 2019
In a recent post about creating Azure VMs using PowerShell, I noted a common issue that I run into where the name of the OS disk does not conform to naming standards. The format for a VM OS disk when...
Azure / Syndication / Windows
by Bradley Schacht · Published July 9, 2019 · Last modified July 19, 2019
Every so often I set out to create new resources in my Azure subscription using the command line tools (PowerShell or CLI) just to keep up to date on the changes and improvements in the different methods. While the Azure...
Azure / SQL Server / Syndication
by Bradley Schacht · Published June 5, 2018 · Last modified May 30, 2018
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your own key was through PowerShell and T-SQL. Thankfully, that has changed....
Azure / PowerShell / Scripts / Syndication
by Bradley Schacht · Published May 29, 2018 · Last modified May 22, 2018
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that you need to get right but are unsure of the exact value that should be there. In the Azure Portal...
Azure / PowerShell / Scripts / Syndication
by Bradley Schacht · Published May 22, 2018 · Last modified July 19, 2019
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do training with a customer. Part of that meant creating 6 data...
Azure / SQL Server / Syndication
by Bradley Schacht · Published May 22, 2018 · Last modified May 30, 2018
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure SQL Database there has long been an option to enable TDE...
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2. You can watch the recording here if you missed it. In this follow-up I answer all the important questions that...
Azure / SQL Server / Syndication
by Bradley Schacht · Published April 25, 2018 · Last modified April 23, 2018
It’s an exciting time to be a database professional. The technology is advancing quickly, large datasets are easier to handle than ever before, and the cloud is opening up new functionality and use cases that we couldn’t tackle before. My...
