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

• by Kevin3NF

• Dallas DBAs

My Favorite and Recommended Training Resources As I’ve been in intense, focused SQL Server training for the last year, I thought it would be a great time to share...

2020-07-31 (first published: 2020-07-21)

560 reads

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

• by Kevin3NF

• Dallas DBAs

T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and this month’s edition is hosted by Kerry Tyler...

2020-07-22 (first published: 2020-07-14)

410 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-07-13 (first published: 2020-06-30)

604 reads

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

189 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)

161 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

13 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)

307 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

7 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

28 reads