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,156 reads
Blog Posts
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
A New Word: Looseleft
looseleft – the feeling of loss upon finishing a good book, sensing the weight of the back cover locking away the lives of characters you’ve gotten to know so...
2023-05-26
276 reads
Data Platform WIT and DEI Mental Health and Wellness Day: Managing Chronic Pain
Thank you to Data Platform WIT and DEI for hosting Mental Health and Wellness Day! I was honored to be included. To see the full lineup, please visit https://www.meetup.com/data-platform-dei/events/293091941/...
2023-05-26 (first published: 2023-05-05)
121 reads
Top Tools for SQL Server Performance Troubleshooting
When you've got the symptoms of a database issue you can run a series of diagnostic queries to try and drill down on the problem and then start figuring...
2023-05-26 (first published: 2023-05-16)
643 reads
Using ChatGPT for Writing
I have been experimenting more and more with ChatGPT on a regular basis. I’m interested and curious how this will help. I had a friend at one of the...
2023-05-26
30 reads
Branding Yourself for a Dream Job – Houston SQL Server User Group
I delivered a presentation for the Houston SQL Server User Group tonight, virtually from Colorado. I’d love to go down, but couldn’t do it today. The slides for the...
2023-05-25
21 reads
Denver Dev Days
I’m going to attend the Denver Dev Days 2023 in June. I submitted a few sessions and got two picked. I’ll be doing these talks: Blogging for the Tech...
2023-05-25
7 reads
Impact of TDE on Performance
Microsoft states that enabling TDE usually has a performance overhead of 2–4%. That doesn’t sound like very much, and personally I wouldn’t let it bother me if I want...
2023-05-24 (first published: 2023-05-10)
947 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers