t-sql tuesday

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

Last Updated April 21, 2020

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. …