• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

  • Services
    • SQL Server Health Check
    • Fractional DBA
  • Pocket DBA®
  • Blog
    • Speaking
  • Testimonials
  • Contact
  • About

video

Code That Writes Code

April 28, 2023 by Kevin3NF Leave a Comment

“Work Smarter, not Harder”

We’ve all heard it before, pretty much any job, anywhere.

In our DBA slice of the IT world, this is very relevant to how we manage SQL Servers and the databases on them.

From scripts to check for Bad Things™, to writing efficient code.

In this video, I show a simple way to get SQL Server generate scripts you can run.  In this case I needed to run the same command against a large number of databases. Running it manually, or worse, doing it in the GUI is just not an option.  Enjoy!

The code that I will now use as a starter script:

-- Don't run this if you don't understand it 100%

Select 'ALTER Database ['+[name]+'] set Page_Verify Checksum, recovery Full, auto_shrink off;
go'
From master..sysdatabases
Where DBID > 4

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: SQL, TSQL, video Tagged With: SQL, syndicated

Renaming SQL Server Databases

October 12, 2020 by Kevin3NF Leave a Comment

Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh.  Most commonly when moving a copy from prod to dev.

My Pluralsight courses for new SQL Server DBAs

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: SQL, video Tagged With: syndicated, video

Getting Started With SQL Server Maintenance

August 25, 2020 by Kevin3NF 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:

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!

Pluralsight courses require a paid subscription.

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

Thanks for watching!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Accidental DBA, Career, Pluralsight, Training, video

SQL Server Identity Skipping

February 4, 2020 by Kevin3NF 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

Follow @Dallas_DBAs

Filed Under: Configuration, video Tagged With: syndicated

Unboxing Azure Data Studio

October 4, 2019 by Kevin3NF Leave a Comment

Watch me embarrass myself by completely failing to find things in my first look at ADS:

Comments?  Put them on the video…but be nice 🙂

Thanks for watching!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: Tools, video

Video: SQL Server HA/DR Overview

June 24, 2019 by Kevin3NF 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

Follow @Dallas_DBAs

Filed Under: HADR, video

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!

Home Blog About Privacy Policy
  • Home-draft
  • Blog
  • About Us

Copyright © 2025 · WordPress · Log in

 

Loading Comments...