Azure. Business Intelligence. SQL Server. Nerd Stuff.
Azure / PowerShell / Scripts / Syndication
by Bradley Schacht · Published November 25, 2019 · Last modified November 23, 2019
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when I would remove most of the resources, this year I removed...
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes organized. I don’t want fruits or veggies on my pizza. And...
by Bradley Schacht · Published November 6, 2019 · Last modified November 7, 2019
It’s that time of the year again. No, not fall, although I do love the weather change that’s around the corner. It’s time for me to rebuild my Azure environment! Each year I try to wipe out as much of...
by Bradley Schacht · Published September 4, 2019 · Last modified August 23, 2019
Most people connect to a database, create tables, run update statements, tune queries, add indexes, and never once think about the underlying data and log files that support all these operations. Database administrators know the importance of managing those files....
by Bradley Schacht · Published August 22, 2019 · Last modified August 21, 2019
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by Microsoft: Adventure Works. The Adventure Works databases follow the sales of...
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....
