SQL Server

First Responder Kit Updated, and sp_AskBrent is now sp_BlitzFirst

We’ve released the first fully open source version of our SQL Server First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex, sp_BlitzRS, sp_BlitzTrace, and the newest member: the newly renamed sp_BlitzFirst. I wanted to rename sp_BlitzFirst because as an open source project, it’s going to have more than just my own answers as to why your SQL Server…
Read More

[Video] Office Hours 2016/06/22 (With Transcriptions)

This week, Brent, Richie, Doug, and Tara discuss Growing databases, most useful SQL certifications, replication issues, group discounts, backup software 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. Office Hours Webcast – 2016-06-22   Brent Ozar: All right, we…
Read More

30,000 Comments

Blogging, SQL Server
7 Comments
It feels kinda arbitrary, but it’s a champagne moment: Thanks to everybody who’s ever stopped by, left a comment, and taken part in the discussions. (An extra-special thanks to folks who even addressed us by the right names, and didn’t call everybody else here Brent, hahaha.) I started this thing over a decade ago, but you,…
Read More

We’re open-sourcing the sp_Blitz* scripts.

SQL Server
22 Comments
We’re proud to announce that our First Responder Kit is now on Github, and it now uses the MIT open source license. What This Means for Users Good news: it’s still free, and now it’ll be updated even more often. If you’re subscribed to update notifications, we’ll still email you monthly when we release new versions. Today, we’re…
Read More

[Video] Office Hours 2016/06/15 (With Transcriptions)

This week, Brent, Angie, and Tara talk through your questions about monitoring tools, transactional replication, configuration management, source control software suggestions and much 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. Office Hours Webcast – 2016-06-15 Why did some of…
Read More

Let’s Make a Match: Index Intersection

SQL Server
4 Comments
Most of the time, when you run a query, SQL Server prefers to use just one index on a table to do its dirty work. Let’s query the Users table in the StackOverflow database (I’m using the March 2016 version today), looking for people with a certain reputation score OR a certain number of upvotes: Query…
Read More

SQL Interview Question: “How do you respond?”

SQL Server
40 Comments
Brent’s in class this week! So you get me instead. You can just pretend I’m Brent, or that you’re Brent, or that we’re both Brent, or even that we’re all just infinite recursive Brents within Brents. I don’t care. Here’s the setup A new developer has been troubleshooting a sometimes-slow stored procedure, and wants you…
Read More

[Video] Office Hours 2016 2016/06/01 (With Transcriptions)

SQL Server, Videos
0
This week, Brent, Angie, Erik, Tara, Jessica, and Richie discuss SSMS issues, security auditing, snapshot replication, SSIS Cache Connection Manager, AlwaysON Availability Groups, deadlocks, and Jessica’s trip to Mexico. 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. Office Hours Webcast – 2016-06-01…
Read More

[Video] Office Hours 2016 2016/06/08 (With Transcriptions)

SQL Server, Videos
0
This week, Angie, Erik, Doug, Jessica, and Richie discuss DB migration, rebuilding large indexes, recommendation for SQL dev ops tools, best practices for disabling SA accounts, compression, 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. Office Hours Webcast –…
Read More

SSMS 2016: It Just Runs More Awesomely

SQL Server
71 Comments
Step 1: configure SSMS to only show file names on the tabs. Click Tools, Options, Text Editor, Editor Tab and Status Bar, and set all of the tab texts to false except file name. After all, not like all this stuff fits on the tab. Step 1: SSMS tab name configuration Step 2: while you’re…
Read More

Is your SAN’s cache killing tempdb?

SQL Server, Storage, TempDB
3 Comments
Let’s start with definitions Many SANs have caching built in. What kind of cache is important, because if you’re dealing with non-SSD storage underneath, you could be waiting for a really long time for it to respond. Let’s start with some definitions of the most popular caching mechanisms available for SANs. I’m not going to…
Read More