Let's Talk Shop
When You Love Data as Much as I Do…
I’ve been working in data for a long time. After a while, you recognize the issues that everyone runs into sooner or later—and hopefully, can come up with some pretty creative solutions. I love being able to wax profound (or at least, long-winded) about why these issues come up and how I like to go about resolving them. Or just pose a question to my fellow data professionals so we can discuss. Check out my past blog articles here, or get in touch if there’s a topic you think I should cover.
Featured
Why Become a PowerShell DBA
If you find this article valuable and you decide that you want to get your learn on with PowerShell and
Recent
Contained Availability Groups using DbMail Query
Call to action for Microsoft. Contained Availability Groups came out in SQL 2022 and they definitely have their use. But
PASS Data Community Summit Presentations part 2
To all who came to my PASS Summit sessions and those that gave feedback about my presentations, I say Thank
TSQL Tuesday – One of my favorite Extended Events
In honor of TSQL Tuesday for September, the mother post is with Grant Fritchey – TSQL Tuesday 166. I wanted
PowerShell for DBAs Office Hours
To celebrate PowerShell month with Brent Ozar (b | i ) and his free PowerShell class, I am hosting Office
Ola Hallengren Maintenance part 1
Many of us are using Ola Hallengren’s maintenance solution. This post will assist you in configuring this solution when you
SQL Server Agent PowerShell Job Step with #NOSQLPS
In researching some things for a presentation, I was to give at Intersections, Spring 2022, I came across this documentation
How is the pandemic going for you? (T-SQL Tuesday #132)
At the first of this year, things were going well. Just before the pandemic was in full swing, the company
UpdateHadronTruncationLsn messages in SQL 2019 Errorlog
If you have SQL Server 2019 installed and are using Availability Groups you may incur messages that look like the
Insights from your Database using PowerShell and TSQL
Hello All. I have been looking for ways for quite sometime to understand my databases better. There are a lot