Top 3 Upgrade & Migration Mistakes
This is a guest post by another friend of Dallas DBAs – Brendan Mason (L|T) Upgrading and migrating databases can be a daunting exercise if it’s not something you...
2020-12-22
46 reads
Kevin3NF
- Interests: Cycling, family, sci-fi, DBA stuff
Virtual Log Files
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-12-07 (first published: 2020-11-24)
380 reads
Renaming SQL Server Databases
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
34 reads
The Ironic DBA—My First Year as a DBA [Part 4]
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)
648 reads
The Ironic DBA—My First Year as a DBA [Part 3]
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)
439 reads
The Ironic DBA—My First Year as a DBA [Part 1]
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)
688 reads
SQL Server Express Size Limit
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
223 reads
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: 2020-06-24)
210 reads
Data Bits – Episode 9 – David Klee
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
87 reads
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
23 reads
Blogs
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Advice I Like: Tipping
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Forums
Migration related issue
I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...
How Much AI Code Would You Use?
Comments posted to this topic are about the item How Much AI Code Would...
Browsing for Instances
Comments posted to this topic are about the item Browsing for Instances
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers