PGSQL Phriday #009: On Rollback
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty simple, database change management. Now, I may have, once or twice, spoken about database change...
2023-06-02
26 reads
Blog Posts
Restore One Backup From Many in a Device–#SQLNewBlogger
I wrote recently about finding multiple backups in a file. This post looks at how to restore one of those. The one you choose. Another post for me that...
2023-06-02 (first published: 2023-05-17)
214 reads
Running SQL Server in a container with sqlcmd
One of the options that I completely missed with the new go-sqlcmd CLI tool is the ability to spin up a container running SQL Server. Let’s have a look...
2023-06-02 (first published: 2023-05-19)
502 reads
Summit Launch Pricing Ends June 7
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023. It’s in person only, and if you can come, you should register today. Launch pricing...
2023-06-01
36 reads
Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a bit behind this week. I will do better next week!As you may have heard last...
2023-06-01
53 reads
Using Docker on Windows with Persistent SQL Server Settings and Databases
This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases...
2023-05-31 (first published: 2023-05-15)
490 reads
Why you still need DBA resource in the cloud
Why a DBA, rather then being redundant, is even more valuable when your databases run in the cloud.
2023-05-31 (first published: 2023-05-19)
434 reads
Migrating from EverNote to Joplin
Recently I got a message that my Evernote subscription was going up. It’s been a $3 a month service, but moving to $4 for me. From USD$35 to USD$50...
2023-05-30
1,158 reads
Pulling Azure Analysis Services logs from Azure Log Analytics into PowerBI using Kusto Query Language (KQL)
We have very large Analysis Services(SSAS) cubes with billions of records and hundreds of users so we need to be able to monitor the performance of queries. 95% of...
2023-05-29 (first published: 2023-05-17)
211 reads
Query Store – Useful Tool for DBAs
SQL Server is a robust and flexible database management system that offers a variety of features and capabilities to help organizations effectively manage their data. One of the key...
2023-05-29 (first published: 2023-05-18)
545 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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...
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