Dallas DBAs

Blog Post

TIL: Measure-DbaBackupThroughput

Today’s dbatools command: Measure-DbaBackupThroughput This one’s a smaller command, but that doesn’t mean it’s without use. If you need information on backup speeds (throughput) or early warning of possible...

2020-05-26

22 reads

Blog Post

TIL: Get-DbaAgentJobHistory

Another blog post, another dbatools command. Today’s command: Get-DbaAgentJobHistory Basic command, gets all the job history info and pipes it to gridview, because there’s a LOT of info here....

2020-05-14

55 reads

Blog Post

TIL: Get-DbaLastBackup

(This post comes from one of our Junior DBAs – @SQLDork) I’ve been learning dbatools over the past week or so, you can read the previous blog posts here...

2020-05-06

26 reads

Blog Post

TIL: Restore-DbaDatabase

(This post comes from one of our Junior DBAs – @SQLDork) If you haven’t read it already, i recently wrote a blogpost where i go over Backup-DbaDatabase, you can...

2020-04-29

26 reads

Blog Post

TIL: Backup-DbaDatabase

(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...

2021-04-26 (first published: )

538 reads

Blog Post

IRL #7: Test Restores and CheckDB

My Pluralsight course for new SQL Server DBAs Problem: My client asked me for a way to automate test restores and CheckDB either ad hoc or on a schedule,...

2020-04-29 (first published: )

516 reads

Blogs

Are you getting value from your reporting?

By

Do you spend so long manipulating your data into something vaguely useful that you...

The Book of Redgate: SQL Server Central

By

It was neat to stumble on this in the book, a piece by me,...

Git forked

By

Forgive me for the title. Mentally I’m 12. When I started my current day...

Read the latest Blogs

Forums

Microsoft Security Changes and SQL Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Microsoft Security Changes and SQL...

Expanding into Print

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expanding into Print

Downtime Caused by the Postgres Transaction ID Wraparound Problem

By Chandan Shukla

Comments posted to this topic are about the item Downtime Caused by the Postgres...

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled.

See possible answers