Brent Ozar's Consultant Toolkit

What The Consultant Toolkit Does

Consultant Toolkit
1 Comment
It’s one thing for me to tell you how much easier The Consultant Toolkit makes my job and how clients love how much I can tell them about their server during the initial sales call – but it’s another thing to hear it from a happy customer: Thought I would share a story, with my…
Read More
Adam Machanic, Japanese Snack Connoisseur

sp_WhoIsActive Is Now Open Source.

Tools
21 Comments
Adam Machanic, Japanese Snack Connoisseur If you’re still using sp_who, sp_who2, and Activity Monitor, listen up: there’s a great free replacement, and it’s now open source, too! sp_WhoIsActive is a much more powerful way to analyze what’s happening right now on your server. Here’s what you need to know: sp_WhoIsActive’s home on Github – releases…
Read More
Stack Overflow

Updated (and Smaller!) Stack Overflow Demo Databases

The place that saves your job The nice folks over at StackOverflow.com (shout out, @onlybluefeet) updated their public data dump last month. This time around, I’m giving you two options: Full size circa 2017/12: 19GB torrent (magnet.) Expands to a ~137GB SQL Server 2008 database. Because it’s so large, we distribute it with BitTorrent – if you’re…
Read More
Stack Overflow

Updated Stack Overflow Database Dump Importer v1.4

Stack Overflow Database
0
The nice folks at Stack Overflow publish their entire data set (data included) in XML format. It’s tons of fun for demos, but you need a way to get it into a relational database. The Stack Overflow Data Dump Importer (SODDI) makes this point-and-click easy. Just download the latest release, install it, download the XML exports, and…
Read More

sp_AllNightLog: ¿Por que los queues?

Building stuff I sometimes really hate coming up with ideas, and much prefer someone to just say “I want this” so I can go out into the world and figure out how to do that. Occasionally though, I realize that I’m not going to get all that much direction. That’s what happened with sp_BlitzQueryStore. It…
Read More
Ola Hallengren at the PASS Summit 2014

Ola Hallengren’s Maintenance Scripts are Now on Github.

For some of you, the headline is self-explanatory, and you just want the URL, so here it is: https://github.com/olahallengren/sql-server-maintenance-solution For the rest of you, here’s what it means. What are Ola Hallengren’s maintenance scripts? Ola Hallengren’s maintenance scripts are a widely used replacement for maintenance plans. His backup, integrity check, and index optimization stored procedures are…
Read More

How to Configure Always On AG Backups with Ola Hallengren’s Scripts

With SQL Server AlwaysOn Availability Groups, you can offload backups to a replica rather than running them on the primary. Here’s how to do it: 1. Install Ola Hallengren’s utility scripts on all of the replicas. During the install, it creates a laundry list of SQL Agent jobs, but doesn’t set up schedules for any of them.…
Read More

How to Configure Ola Hallengren’s IndexOptimize Maintenance Script

If you’re a production database administrator responsible for backups, corruption checking, and index maintenance on SQL Server, try Ola Hallengren’s free database maintenance scripts. They’re better than yours (trust me), and they give you more flexibility than built-in maintenance plans. However, the index maintenance defaults aren’t good for everyone. Here’s how they ship: Transact-SQL CREATE PROCEDURE…
Read More