SQL SERVER DBA ATTEMPTING TO BLOG
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…
I recently set up an Availability Group with the intent of using the secondary as a read only replica for reporting. We have a few AG’s in our environment already but currently none are using this feature. I’m not going to step through setting up the AG or configuring the readable secondary as there are…
I recently gave my first usergroup presentation in Cleveland, closely followed by my first SQL Saturday presentation in Columbus. My chosen topic was row store data compression and I had a few great questions that I plan on answering with blog posts. First up… What happens if I use data compression and backup compression, do…
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…
Well tonight marks three weeks since I gave my first user group presentation and you know what, it’s been a total whirlwind since then so I’ve had little time to reflect. Myself and the fiancé closed on our first house and my parents flew in to visit. It’s very useful to have people on hand…
I was troubleshooting an issue last week which led to me firing up extended events to look at records being written to the transaction log, I typed into the search bar ‘Transaction’ hoping to find something that would do the trick and didn’t quite find what I was looking for. After a few more failed…
First of all thanks to Riley Major (b|t) for hosting this months T-SQL Tuesday. This is a great topic for me as I have mentioned before my goal this year is to work on getting my blog going and starting to give back to this amazing community. I am always impressed by the content people…
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…