fbpx

DallasDBAs.com

Explaining SQL Server in plain english

Header Right

video

Getting Started With SQL Server Maintenance – Pluralsight

by Leave a Comment

My second Pluralsight course for Junior and Accidental DBAs is finally released!

This course covers many of the SQL Server Maintenance items I do every day, week, and month for my servers:

If you don’t have a Pluralsight account, you can sign up for a free 10 day trial. They also run sales quite a bit, so keep an eye out for that.

My first course is a good (but not required) starter, covering history, installation, some configuration and the SQL Server tools:

I’d love to get your opinions, questions and ratings for either or both of these. I’m already planning the next one!

If you want some FREE training, check out my YouTube channel.

Thanks for watching!

Kevin3NF

SQL Server Identity Skipping

by 2 Comments

My Pluralsight course for new SQL Server DBAs

SQL Server may skip 1000 numbers on an Identity column if the server crashes. Here’s why:

Too long, didn’t watch version:

SQL Caches 1000 numbers at a time to boost insert performance. In a crash and recovery, those numbers are gone.

SQL 2016 and earlier – use instance-wide trace flag 272 to turn off this behavior (performance might suffer).

SQL 2017 and later – its now a database scoped config item:

use MyDB;
go
ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE = OFF
GO

Video shows a walk-through of before and after each fix, plus a “Two guys walk into a bar” joke when I disappeared to troubleshoot a broken demo…

Thanks for reading and/or watching!

Kevin3NF

My Pluralsight course for new DBAs

Video: SQL Server HA/DR Overview

by Leave a Comment

This is meant to be a high-level overview, not an exhaustive setup guide.  I skip over some relevant bits so the main points don’t get buried.

In my DBA Fundamentals pre-conference, we spend a good hour going over the various High Availability and Disaster Recovery options available in SQL Server.  From simple Backup/Restore up to Distributed Availability Groups.

This video is a more succinct version of that conversation.   Enjoy!

If you have questions or comments, please add them in the YouTube comments, so I’ll see them more quickly.

Thanks for reading!

Kevin3NF

Video: Moving SQL Server Data Files

by Leave a Comment

If you are like me, when you look at certain pieces of SQL Server documentation the sheer volume of information can be a little overwhelming.

ALTER DATABASE is one of those documents, due to the number of things that can be ALTERed.  The documentation has been improved since I was a young newbie DBA, but still…

Anyway, here is a simple video showing me moving a LOG file from my D drive to the C drive:

If you have comments or questions, please leave them on the video, or ping me on Twitter.

Thanks for watching!

Kevin3NF