SQL SERVER DBA ATTEMPTING TO BLOG
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…
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…