2020 Year In Review
TL;DR – It was great and not great I think we can all pretty much agree that in some regards 2020 was horrible, globally. So lets move on… Good...
2021-01-01
20 reads
Dallas DBAs
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
48 reads
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)
385 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
39 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)
652 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)
444 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
234 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)
693 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)
217 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
91 reads
Blogs
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers