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: Dismount-DbaDatabase and Mount-DbaDatabase

We have a double feature for today’s dbatools blog post, as these two commands go hand-in-hand. Todays commands: Dismount-DbaDatabase and Mount-DbaDatabase Detach-DbaDatabase and Attach-DbaDatabase can be used as aliases....

2020-07-01 (first published: )

217 reads

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

30 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

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

56 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

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

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

Blogs

T-SQL Tuesday #196 – Two risky career decisions I made

By

The T-SQL Tuesday topic this month comes James Serra. What career risks have you...

T-SQL Tuesday #192: What career risks have you taken?

By

This T-SQL Tuesday is hosted by the one and only James Serra – literally...

T-SQL Tuesday #196: Taking Risks

By

This month we have a new host, James Serra. I’ve been trying to find...

Read the latest Blogs

Forums

OPENQUERY Flexibility

By Steve Jones - SSC Editor

Comments posted to this topic are about the item OPENQUERY Flexibility

A Full Shutdown

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Full Shutdown

Going Native with Fabric Spark Pools: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Going Native with Fabric Spark...

Visit the forum

Question of the Day

OPENQUERY Flexibility

Which of these are valid OPENQUERY() uses?

See possible answers