Kevin3NF

Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialities include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs
  • Interests: Cycling, family, sci-fi, DBA stuff

Blog Post

TIL: Get-DbaErrorLog

Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in addition to normal DBA stuff™ Today’s dbatools command is Get-DbaErrorLog, which is very similar to...

2020-05-29

22 reads

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

17 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

51 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

21 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: )

502 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

15 reads

Blogs

Visualising SQL Server in Kubernetes

By

The other day I came across an interesting repo on github, KubeDiagrams. What this...

Picking a Starting Table in Test Data Manager

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

SQL Server Migration Using a Distributed Availability Group

By

SQL Server migrations are a headache, ask anyone who’s been through the pain of...

Read the latest Blogs

Forums

Counting Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Bits II

Unreliable Narrators

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unreliable Narrators

Understanding Data Type Conversion Functions in SQL Server with PARSE, TRY_PARSE, and TRY_CONVERT

By Noman072

Comments posted to this topic are about the item Understanding Data Type Conversion Functions...

Visit the forum

Question of the Day

Counting Bits II

What is the result of this query in SQL Server 2022+?

select bit_count('7')

See possible answers