Dallas DBAs

My Pluralsight course for new SQL Server DBAs Image credit to Jeff (t) Back in June of 2019, I published this YouTube video covering the highlights of the various...

2020-03-25

46 reads

SQL Server Identity Skipping

by Kevin3NF

Dallas DBAs

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:...

2020-02-04

13 reads

Blogs

Friday Basics: the CIA Triad

By Brian Kelley

In information security (INFOSEC), there several foundational concepts and principles. One of the ones...

A New Word: the standard blues

By Steve Jones

the standard blues– n. the dispiriting awareness that the twists and turns of your...

How Redgate Flyway Can Boost Your DevOps Journey

By Chris Yates

A brief introduction to the tool and its advantages for database migrations DevOps is...

Read the latest Blogs

Forums

Question of the Day

The Marked Transaction

I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?

See possible answers