T-Sql-Tuesday

I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs. In this post, we’ll be taking a look at a very handy combination of dbatools functions for looking at agent job schedules & performance.

Getting Job History

If you don’t have a monitoring suite watching SQL Agent, or you want to get a bigger picture view of when and how your Agent jobs are running, dbatools can help you shortcut getting this information. Get-DbaAgentJobHistory does exactly what its name suggests - it fetches the execution history for one or more Agent jobs on one or more SQL Server instances. Thing is…it can produce a lot of output if you’re not careful. By default, it’ll return the entire job history, with at least two objects per job execution. For example, this is the partial output of Get-DbaAgentJobHistory -SqlInstance localhost\sql19:

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party originally created by Adam Machanic in 2009 and currently curated by Steve Jones.

Each month, a new topic is chosen, published on the first Tuesday of the month and the following month, contributors post their own takes. Anyone can participate. Please publish your post by the end of Tuesday, May 13th in your timezone and on your platform of choice, then leave a comment below or tag me on Bluesky, Mastodon, or LinkedIn with a link to your post and I’ll include it in the roundup.

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Erik Darling (blog) asks us to produce a video

• You can talk about whatever you want, but it has to be a video
• Non-video entries will not be televised
• You don’t have to be on camera
• You can host the video anywhere you want
• You must link back to this post so I get a pingback to find your post
• You must include the T-SQL Tuesday Logo

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Deborah Melkin (blog) asks us to talk about our relationship with mentoring and sponsorship.

This can include:

• What does mentoring and sponsorship mean to you? What value do you see in mentoring and sponsoring?
• How have you benefited from mentorship and sponsors?
• What has worked for you in making these relationships successful?
• On the flip side, what obstacles have you had to work through?
• What do you do to sponsor others in the community?
• As March is Women’s Month, I’d also like to add: How are you mentoring and sponsoring women and other underrepresented groups in our community?

Read the rest of the invitation, where Deborah expands upon the question.

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mala Mahadevan (blog) asks how we manage our database-related code.

Where do you keep your database code? Is it in a GIT-based repo, or just in the database the old-fashioned way?

Read on for the rest of the invitation, where Mala expands upon the question (and there is a lot to dig into).

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Kevin Feasel (blog | twitter) asks us about job interview questions.

What is your favorite job interview question? There’s a lot of latitude in how you answer this, and as a spoiler, that’s the type of question I like a lot.

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. I missed out on January 2024’s edition because I didn’t think I had anything good to talk about, but it suddenly hit me in February so…retroactive T-SQL Tuesday!

For January 2024, Reitse Eskens (blog | twitter) prompts us to talk about our learnings from abandoned or failed projects.

the main intent of this blog is to trigger your stories; what projects did you abandon but learn a lot from OR what’s your favourite learning from a failure.

T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Garry Bargsley (blog | twitter) wants to know what activities we undertake to wrap up the year.

My ask is, what do you have planned for end-of-year activities for your SQL environment? Do you have annual processes or procedures you run? Do you clean up documentation? Do you just take time off and hope someone else does the work?

T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Kevin Kline (blog | twitter) asks us to talk about an IT conference that resulted in a major opportunity.

Tell us the story of how attending an IT conference or event resulted in an amazing career or life opportunity.

It will be a common refrain in this community, but I’m going to pick a PASS Summit. But not my first one.

T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Deborah Melkin (blog | twitter) asks us for a database-related rant.

Who are we kidding? I like to rant. Here we go.