B2B: SQL Checklist

Working with a SQL Server Checklist

This is the 2nd post in my “Back 2 Basics” series following the introduction of topics.

Part of a DBAs role is to ensure SQL Server is installed and configured properly for optimal performance. Just about every DBA that has any experience validates their SQL installations with a checklist.  For years, my “go-to” checklist was Brent Ozar’s SQL Server Installation Checklist.  It has been a few years since it has been updated; but it still is the standard.  Based off his and many other I wrote my own check list of things to do on installation of a SQL Server.

These are the important things you need to remember when it comes to an installation checklist or a checklist for optimal performance.

For me, if I am given a new SQL instance to manage or installing a new SQL instance these are my personal checklist items:

  1. Server Level Configurations
    1. Enable DAC
    1. Configure TempDB
    1. Max Degree of Parallelism
    1. Cost Threshold for Parallelism
    1. SQL Server MAX Memory
      1. Memory Management
    1. Ad Hoc Workloads
  2. Database Configurations
    1. Individual Volumes for Data (mdf) and Transaction Log (ldf) files
    1. Auto Growth Settings
    1. Auto-Shrink
    1. Auto-Close
    1. Auto-Update Stats
    1. Compatibility Level
  3. Setup Maintenance – I recommend Ola Hallengren Scripts for this.  Ola’s scripts are world famous script used to manage all your databases.  On smaller setups, you can install and configure with a single script and never have to worry again.  However, I strongly recommend you learn the ins & outs of his scripts to customize them for your needs.  You can even extend its functionality with Configuration Tables.
    1. Backups
    1. Integrity Check
    1. Index
  4. SQL Agent Alerting
    1. Database Mail
    1. Configure Operator
    1. SQL Agent Failsafe
    1. SQL Agent Alerts

Revisiting and Restarting

Today is a new day. I now have a domain (http://sqlpadre.com) and I now have an email address Robert@sqlpadre.com and I hope this is a new beginning. This morning I revisited my old blog posts and discovered that I am not very consistent at blogging. In fact I was pretty terrible. I hope to change that.

Many years ago, I tried to begin two different blogging series called “B2B: Back to Basics” and “8 Weeks of Indexes”. These series were stared over 6 years ago and completely lost steam…translation I dropped the ball. Couple that with the fact two new versions of SQL have been released plus SQL Database in Azure, my blog is way behind the time.

I hope this is truly the beginning of a new chapter for me. I hope to restart both these series, producing one post a week alternating the topics. I have even set reminders.

The first post will be an introduction to both topics and provide an outline of the up coming posts (hey, I’m trying to stay organized).

Quarantining is HARD!

For the last year (almost to the date), I have been working from home. At first I thought it would be temporary. I thought it would be “neat”. I thought I could be more productive since I would not be driving 2+ hours a day. Boy was I wrong!

Let me set the record straight, quarantining is HARD! Harder than going to the office. I do enjoy not being on the road for 2+ hours a day and I do enjoy not spending $150 in gas week (I drive a truck). Staying focused is not easy when you have 4 cats vying for your attention.

In November, I started a job with a new company that hired me as 100% remote. So, it seems I will be “quarantining” even after the quarantine period is over.

But, I am also going to do my best to get back on the preverible horse and ride! I do enjoy blogging and I have a tremendous amount of learning to do when it comes to PowerShell and Azure Cloud technologies.

In the coming week, I hope to outline a blogging goal for the next 3 months (baby steps). Hopefully, I can stick with this since I have 2 extra hours a week, right?

I hope to also get back involved in presenting topics to virtual groups, in person groups and conferences. Keep a loog out, you might find me here soon Data Architecture Virtual Group (davg.org). But, first comes baby step #1: time table/outline for blogging!

stay tuned.

Don’t forget me when I’m gone!

It has been almost exactly one year since my last post and quite frankly, I am embarassed, ashamed and down right just feeling close to failure.

But I hope to change that!

My last post announced that I was going to document my learning with PowerShell. Since then, SQL 2019 has been released and there are so many new “toys” with SQL! But before I go into that, I really must finish what I started.

Today, I not only downloaded SQL 2019 Developer Edition to install, but I also actually installed DB Tools for PowerShell!!!

Let’s get this Party Started!!!