SQL

Alll things MS SQL Server

To-do lists

SQL Padre SQL

Something on your “to-do list” that never gets done.

Well, this WordPress prompt is really quite easy to answer: writing blog posts!! Ha ha

I always have great intentions of writing, but I always fall short. I truly thought being a new “empty nester” I would have more time on my hands. Well, that didn’t go as planned.

And the embarrassing thing is I absolutely love training, learning new things and imparting that knowledge. For the past 15+ years, I have been an adult volunteer for the Boy Scouts of America. In that time, I have participated in local, regional and national training courses. I was instrumental in beginning out council’s University of Scouting. I have staffed multiple local, regional, and national training courses for both youth and adults. I have presented multiple times at various SQL Saturdays. I saw all that not to brag, but to show I truly do love training and imparting knowledge. I guess I am more of an in person trainer, not a writer.

One of the hardest part of writing is determining the subject matter. I believe if given a topic, I could figure it all out. Another issue with flogging is the fear that I am writing about things that have been done to death. No one wants to read duplicate topics. It is hard to be original.

I hope to do better. I will set new goals and task myself with doing one blog post a month to start. If I can accomplish that, maybe increase frequency of blog posts. Maybe, haha!

B2B: SQL Checklist

SQL Padre SQL

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

SQL Padre SQL

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!

SQL Padre SQL

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.