Search Results for “Ola Hallengren”

  1. Home
  2. Search Results

Backups 4: Setting Up Ola Hallengren’s Maintenance Scripts

If you’re a full time database administrator, then rather than using maintenance plans, you should upgrade to Ola Hallengren’s maintenance scripts. They’re free, open source, and are used all over the world to do powerful, configurable maintenance tasks. For support and feature requests, head to Ola’s Github repository.  

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Fundamentals of Database Administration or Recorded Class Season Pass, or log in if you already shelled out the cash.
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 Maintenance Scripts

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

When You’re Troubleshooting Blocking, Look at Query #2, Too.

When I’m troubleshooting a blocking emergency, the culprit is usually the query at the head of a blocking chain. Somebody did something ill-advised like starting a transaction and then locking a whole bunch of tables. But sometimes, the lead blocker isn’t the real problem. It’s query #2. Here’s a sample scenario: A long-running select with…
Read More

08 Partitioning Is a Great Partner for Columnstore

To be honest, I’m not a big fan of table partitioning in most scenarios. It’s a data loading & unloading feature thanks to the sliding window scenario, but… most folks just don’t load their data an entire partition at a time. However, when we need to do index maintenance for columnstore indexes, that’s exactly what we…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.
Read More

Backups 3: Setting Up Maintenance Plans

Developers and sysadmins: the easiest way for you to protect your servers is by using maintenance plans. Full time production database administrators should watch the Ola Hallengren maintenance script setup module instead. I’m specifically targeting this video at developers and sysadmins who need an easy, safe way to protect stuff without knowing T-SQL.

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Fundamentals of Database Administration or Recorded Class Season Pass, or log in if you already shelled out the cash.
Read More
How I Use the First Responder Kit

Updated First Responder Kit and Consultant Toolkit for February 2020

We spent Valentine’s Day removing the bugs from your chocolates. You’re welcome. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers: check your email for the updated version from Gumroad,…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}