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 SQL Server, there is a SQLSkills class that I am teaching this year, please join me to get a great start in how to get your toolset growing by adding PowerShell to your toolbelt. Early
February 20, 2019
Recent
PowerShell for SQL Server DBAs Course is Finally Here!
I have finally finished preparing my Fundamentals of PowerShell for SQL Server DBAs Course. You can see the curriculum at this link PowerShell for DBAs Fundamentals | DBADuck Training School. The class is scheduled to be delivered live and the recordings will be available to you for a year as part of the class. The
November 28, 2024
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 there were some artifacts left behind that need some fixing. Namely when you use DBMail while in the Availability Group jobs or operations. Let’s see what there is left. First, here is the link to
October 13, 2024
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 You! I read the feedback and understand the comments made. Based on the feedback I am adding a Part 2 for both presentations. Add PowerShell to your DBA Toolbox! and SQL Server 2022 Contained Availability
November 20, 2023
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 to share one of the Extended Events I always put on a server when I am in charge of it. It has to do with File growths and captures some important things for me. Before
September 12, 2023
PowerShell for DBAs Office Hours
To celebrate PowerShell month with Brent Ozar (b | i ) and his free PowerShell class, I am hosting Office Hours on Twitch.tv and the questions that I will be answering are those posted by you on the Pollgab/dbaduck site. This is my pollgab room that you can add questions to and upvote them for
March 1, 2023
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 add it to your SQL Servers. Jobs are created with this solution. You download it at the link above. I recommended creating a database to use for this solution or even installing it into an
January 31, 2023
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 page for SQL Server PowerShell that in the SQL Server Agent section it indicates that there is a way to get the Agent Job Step to skip loading the SQLPS module and you get to
April 5, 2022
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 I worked for merged with another company. This added a lot of extra things and stress to the current situation and I found that it was a welcome blessing to work from home all the
November 10, 2020
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 below message in your SQL Server Errorlog. UpdateHadronTruncationLsn(6) (force=0): Primary: 0:0:0 Secondary: 892:4720:2 Partial Quorum : 0:0:0 Aggregation: 892:4720:2 Persistent: 892:382:4 According to Microsoft (unofficially as I did not hear this personally), there will be
July 22, 2020
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 of DMVs and even some DMFs that help us get some information from the SQL Server engine that can be very insightful. Many shops use monitoring tools and they are great because they watch things
July 1, 2020
Microsoft has been confirmed as the Premium Sponsor for PASS Virtual Summit
The formal announcement is here (Announcement). What does this mean to you? This means that you will have 1 on 1 time with Microsoft Engineers and highly sought after content from Microsoft for the Summit. If you have not had a chance to interact with the engineers at Microsoft with yours or your company’s issues,
June 23, 2020
Using Clipmate for great lookback ability #tsql2sday
#TSQL2sday is today. The theme is Tips and Tricks NOT related to SQL Server or RDBMS systems. My tip today is about a utility that I have been using for a long time thanks to Lars Rasmussen (b | t) long time very good friend. The utility is called Clipmate and it is a clipboard
June 9, 2020
PASS Summit has gone Virtual in 2020
Hey all, this is a historic moment in the SQL Community. PASS Summit will be virtual this year. As a PASS Blogger I wanted you to know of the news. All the information is in the link and the registration if you just want to go there now, is here (Register for PASS 2020 Now).
June 4, 2020
PowerShell at Michiana PASS User Group Meeting
Issues during Presentation I had an issue during the demo of this presentation on Gathering Data for Trending using PowerShell and I indicated that I would blog the solution. I found the solution. First the problem. Problem Code in v3.0 [code lang=”powershell”] $dbobj = New-Object [PSObject] -Property ([ordered]@{ ID = $db.ID Name = $db.Name Size
January 30, 2020
PowerShell at #SQLSatOregon with @DBAduck
Mastery Session – Leveling Up with PowerShell for the DBA I know that most of you have used or heard about using PowerShell, but I am sure that you have things you could learn about using PowerShell in your DBA career. This mastery session is meant to get you closer to mastery of PowerShell for
October 21, 2019