SQL SERVER DBA ATTEMPTING TO BLOG
In my last Desired State Configuration (DSC) post a couple of weeks ago I covered some of the concepts involved with DSC, and I also have a T-SQL Tuesday post to get you started writing your first configuration. So today we are going to look at the next step in the process: what happens after…
I’m currently working on a pretty interesting project to explore using PowerShell’s Desired State Configuration (DSC) to manage SQL Servers. DSC uses declarative language to define the desired state of your infrastructure. Ensuring that the directory C:\Test exists is a simple example. A more complicated example would be the complete configuration of a SQL Server.…
This weekend, while I was having a great time at SQL Saturday Cleveland, I ran into my friend Bert (b|t). He had some dbatools questions, which I was happy to help him with. Now that dbatools has over 500 commands, it is both awesome and terrifying. Bert wanted to know how to automate his database…
Automation is something that interests me greatly, and I think if you have read even one of my previous posts you’ll know that my favorite tool for this kind of work is PowerShell. This is the perfect topic to kick off T-SQL Tuesday for 2019 so thanks goes to Garry Bargsley for hosting this month.…
I came across a situation this week where I wanted to add the option of running an existing script, for a specific server/database combination. The script currently has no parameters and runs against all servers in the environment from a scheduled task. I wanted to make sure that behavior didn’t change. The other requirement was…
It’s T-SQL Tuesday time again, I have struggled in the last month or two to get anything up on my blog. Turns out weddings are pretty time consuming 😊! Now that I’m happily married and home from an amazing honeymoon in Hawaii it’s back to work on my blog and professional development. Which makes this…
As soon as I saw Bert Wagner (t|b) post his T-SQL Tuesday topic last week I knew this was going to be a great one. I’m really looking forward to reading about everyone’s favorite code snippets so thanks Bert for hosting and choosing a fantastic subject! A lot of the code I can’t live without…
Thanks to Jens Vestergaard for hosting T-SQL Tuesday #101. When I saw the topic for this month’s T-SQL Tuesday, I knew instantly which tool I would write about. Although there are many great tools out there that make my job as a DBA easier (and I’m excited to read the summary for this month to see what…
Folks, there is something fantastic coming from the creators of dbatools! Chrissy LeMaire (blog|twitter) and Rob Sewell (blog|twitter) just announced something big at SQLBits 2018, a new PowerShell module that combines dbatools with Pester to ensure your environment is “as expected”. I’ve been lucky enough to get to know both Chrissy and Rob by contributing to…