Category Archives: sql server

Tonight: RegEx for DBAs session online!

Update: This session is finished, but here is the recording!

Sean is presenting his Regular Expressions class tonight, online,  for CACTUSS, but you can join too!

Details:

CACTUSS Sept Meeting
Tue, Sep 19, 2017 6:30 PM – 8:00 PM CDT

Please join my meeting from your computer, tablet or smartphone.
https://global.gotomeeting.com/join/263088021

You can also dial in using your phone.
United States: +1 (646) 749-3131

Access Code: 263-088-021

First GoToMeeting? Try a test session: http://link.gotomeeting.com/email-welcome

You can also dial in using your phone.
United States: +1 (646) 749-3131

Access Code: 263-088-021

First GoToMeeting? Try a test session: http://link.gotomeeting.com/email-

Webinar: Introducing Minion CheckDB!

productimg_checkdb

Minion CheckDB is available for download as of February 1, 2017!

In celebration, we’re having a Minion CheckDB webinar on two different days:

And, we will be giving away 3 licenses of Minion Enterprise to one lucky winner* at each webinar. Must be present to win! 

Save the Feb 1 event to your calendar: Outlook (ics)

Save the Feb 3 event to your calendar: Outlook (ics)

Minion CheckDB completes the MinionWare maintenance and backups suite in style. Each solution is plug-and-play for the busy DBA, and deeply configurable for those shops with in-depth needs.

This new module is MinionWare’s most ambitious free release yet, featuring all of the rich scheduling and logging functionality in previous products, plus remote CheckDB, multithreading, custom snapshots, rotational scheduling, and more.

In this webinar we’ll show you how this FREE tool by MinionWare can meet your needs with almost effortless management. You are going to LOVE it.

 

*(Giveaway offer is not open to previous ME winners.)

Database snapshots for everyone!

Database snapshots have been available in SQL Server Enterprise edition in the last several versions. But if you’re lucky enough to have 2016 at work, go on and upgrade to SP1….you get extra-lucky special database snapshots in any version!

(Be sure to read the footnote for “Database snapshots” in that link.)

What are database snapshots for?

Oh what’s that? You don’t use snapshots? Well let’s see a couple of good use cases for them:

  • Take a database snapshot before an upgrade, data load, or major change. It’s WAY faster than a backup, and you can roll back the changes if you need to, almost instantly.
  • Customize integrity checks. When you run DBCC CheckDB or DBCC CheckTable, behind the scenes SQL Server creates a snapshot of the database to run the operation against. You can also choose to create a custom snapshot…among other reasons, so you can specify where the snapshot files are placed. This is especially useful for shops running tight on disk space.

Speaking of integrity checks and snapshots, Minion CheckDB is slated to come out on  this coming February 1.  Be on the lookout…it’s going to blow your mind.

Happy days,
Jen