Dallas DBAs

Virtual Log Files

• by Kevin3NF

• Dallas DBAs

Today’s post is a guest article from a friend of Dallas DBAs, writer, and fantastic DBA Jules Behrens (B|L) One common performance issue that is not well known that...

2020-11-24

21 reads

Renaming SQL Server Databases

• by Kevin3NF

• Dallas DBAs

Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh.  Most commonly when moving a copy from prod to dev. My Pluralsight courses for new...

2020-10-12

5 reads

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)

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

417 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

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

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

168 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

17 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