Dallas DBAs

SQL Server Express Size Limit

• by Kevin3NF

• Dallas DBAs

My Pluralsight course for new SQL Server DBAs   (Needs to upgrade to a bigger bowl) Common scenario: Company is using SQL Server Express to save on licensing costs...

2020-07-02

150 reads

The Ironic DBA—My First Year as a DBA [Part 1]

• by Kevin3NF

• Dallas DBAs

Whoo! It’s been six months since my last post. There are reasons for this, none of which are probably valid, but it’s the way it is. I’ve been a...

2020-06-30

31 reads

TIL: Dismount-DbaDatabase and Mount-DbaDatabase

• by Kevin3NF

• Dallas DBAs

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: 2020-06-24)

149 reads

Data Bits – Episode 9 – David Klee

• by Kevin3NF

• Dallas DBAs

SQL Server, Virtualization and Storage expert David Klee (b|t)stops by to tell stories ?? Fun stuff: “English and Gibberish” “Learn it like you’re going to teach it” “Kevin Kline...

2020-06-16

72 reads

TIL: Get-DbaErrorLog

• by Kevin3NF

• Dallas DBAs

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

9 reads

TIL: Measure-DbaBackupThroughput

• by Kevin3NF

• Dallas DBAs

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

6 reads

Data Bits – Episode 8 – Chrissy LeMaire

• by Kevin3NF

• Dallas DBAs

Microsoft Data Platform and PowerShell MVP, Chrissy Lemaire (b|t) sat down with us in the virtual studio Saturday, and we had a blast getting to know her! Quotables: “This...

2020-05-28 (first published: 2020-05-18)

301 reads

TIL: Get-DbaAgentJobHistory

• by Kevin3NF

• Dallas DBAs

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

20 reads

TIL: Get-DbaLastBackup

• by Kevin3NF

• Dallas DBAs

(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

10 reads

TIL: Restore-DbaDatabase

• by Kevin3NF

• Dallas DBAs

(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

8 reads