Posts by Brent Ozar Unlimited Team

[Video] Office Hours 2016 2016/05/04

This week, Richie, Erik, Angie, and Tara discuss deadlocks, replication, SQL Server 2016 features, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Transcript: Does NVARCHAR(255) Cost More Than NVARCHAR(30)? Angie Walker: All right. So Steve has a nvarchar(255) column that…
Read More

How to Ask Microsoft a SQL Server Licensing Question

Licensing
Licensing is hard, y’all. It changes often and it’s full of lots of little details. Microsoft puts out licensing datasheets, but they’re in a difficult spot — if they explain absolutely everything, the documents get longer and harder to understand. So they have to balance between brevity and clarity. So when you’ve got a licensing question,…
Read More

Top Classic Country Songs for SQL Server DBAs

Humor
17 Comments
“I Shot a Server in Reno (just to watch it die)” Johnny Cash “AlwaysOn on My Mind” Willie Nelson “WASD, Don’t Take Your Single Thread to Town” Kenny Rogers “Transactions in the (Replication) Stream” Kenny Rogers and Dolly Parton “Stand by Your Maintenance Plan” Tammy Wynette “Ring Buffer of Fire” Johnny Cash “Your Deadlockin’ Heart”…
Read More

We’re Presenting at the #SQLPASS Summit 2012!

#SQLPass
0
All four of us – Brent, Jeremiah, Jes, and Kendra – got sessions approved for the PASS Summit in November!  Here’s what we’ll be covering: Shazam! We’re speaking at the PASS Summit! A Developer’s Guide to Dangerous Queries – Jeremiah Peschka Jeremiah says: “SQL Server does a good job of working with whatever garbage we…
Read More
#SQLCruise Alaska: Class is In Session!

Meet Our SQL Storytelling Winner

#SQLCruise Alaska: Class is In Session! The Brent Ozar Unlimited® crew sailed on SQLCruise Alaska last week. Brent, Jeremiah, and Kendra each taught a session (or two) on the cruise. There was much talk of transactions, performance killers, and SSDs. There were lessons on backups, PowerShell, and boat drinks. As a sponsor, we got to design…
Read More

“Who Wrote This?” Contest

Humor
54 Comments
Over and over, readers leave comments here saying things like “Nice comment, Brent” on a post that Kendra wrote.  We laugh about it – after all, they can’t really be reading that closely if they don’t even notice the name on the bottom of the post, right above where they’re commenting – but we started…
Read More

Monday Guest Post: Phony Robbins on Power

Here at Brent Ozar Unlimited®, we’re very open to alternative viewpoints on information technology. We’d like to help broaden your horizons and introduce you to new possibilities for your servers, so we’re introducing a new Monday series – the Celebrity Guest Post. Our first guest is life coach Phony Robbins, an internationally renowned motivational speaker…
Read More

How to BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008, R2, 2012, 2014, 2016, 2017, 2019

BACKUP LOG WITH TRUNCATE_ONLY is a dangerous command: it empties out the contents of your SQL Server’s transaction log without really backing it up.  Database administrators sometimes run this command right before shrinking their log file with a DBCC SHRINKFILE command, thereby freeing up drive space. Why ‘truncate_only’ is not a recognized backup option. When…
Read More