#tsql2sday

Want a Better Work/Life Balance? Use Jira at Home. #TSQL2sday

Last Updated August 10, 2021

I’m only half-joking. Hear me out. If you’re frustrated at how much you work, and how little time you spend with your family & friends, think about how much planning and task management you’re required to do at work. You’ve probably got a ticketing system that tracks a backlog of work you need to do.…

4 Things I Love About Integers #TSQL2sday

Last Updated March 9, 2021

Brent Ozar

Development

I love integers. Furthermore, I think we’ve all been taking them for granted. Integers are clean, elegant datatypes that do exactly what they’re supposed to. They’re the Golden Retrievers of the database world: they have a few shortcomings, but so, so few. And so for this month’s T-SQL Tuesday, I wanna share my love for…

Databases Are Like Walk-In Coolers. #tsql2sday

Last Updated October 13, 2020

Brent Ozar

Production Database Administration

In the back of a restaurant, there’s a walk-in cooler (or a few of ’em.) When a chef needs to make something, she goes into the walk-in cooler, gathers the necessary ingredients, and then comes out to the kitchen to do the cooking. She doesn’t cook inside the walk-in – that wouldn’t be efficient. She just…

#TSQL2sday: How Much Plan Cache History Do You Have?

Last Updated April 21, 2020

Brent Ozar

Execution Plans

For this month’s T-SQL Tuesday, Bert Wagner asked, “What code have you written that you would hate to live without?” I bet you think I’m going to say sp_Blitz, and I would indeed hate to live without that, but you already know about that one, dear reader. Lemme show you something else cool. Before I…

#TSQL2sday: System-Maintained LastUpdatedDate, LastUpdatedBy Columns

Last Updated July 3, 2018

Brent Ozar

T-SQL

For this month’s T-SQL Tuesday, we’re talking about interesting Connect requests to fix or change SQL Server behavior. T-SQL Tuesday In our Senior DBA Class, one of the exercises involves figuring out changes to a table after an Always On Availability Group failover. In every class, several students always say the same thing: “I really…

Announcing T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests

Last Updated July 3, 2018

Brent Ozar

T-SQL

I know this is going to come as a stunning shock to you, dear reader, so you may want to be sitting down. SQL Server isn’t perfect. It’s okay. Deep, calming breaths. We’re going to get through this together, and here’s how: Go to Connect.Microsoft.com, the place where we file bug reports and enhancement requests…

T-SQL Tuesday: Stop Tuning with Wait Stats Percentages

Last Updated July 3, 2018

Brent Ozar

SQL Server, Wait Stats

For this month’s T-SQL Tuesday topic, Michael J. Swart told us to argue against a popular opinion, and man, is that right up my alley. I’ve told you to stop worrying about index fragmentation, stop backing up your logs once an hour, and to stop running $14k of licensing on $3k of hardware. You’re probably checking…

Lemme borrow your car to get tacos - yeah, of course I'm a good driver.

T-SQL Tuesday: Why Do You Need DBA Skills?

Last Updated July 3, 2018

Brent Ozar

Production Database Administration

This month’s T-SQL Tuesday topic asks why you need DBA skills. Lemme borrow your car to get tacos – yeah, of course I’m a good driver. I say you probably don’t. Every now and then, you just need someone else to have good DBA skills. Most of my clients don’t have full time database administrators. …