Daily Coping 2 Nov 2022
Today’s coping tip is to be kind to yourself today. Remember, progress takes time. I am usually good at this. I work on many things that take time, so...
2022-11-02
12 reads
Blog Posts
Getting Help Online
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
150 reads
Organize Your Tabs in SQL Server Management Studio
I blogged about this in August, but wanted to do this video as well: Thanks for reading and/or watching! Kevin3NF Follow @Dallas_DBAs
The post Organize Your Tabs in SQL Server...
2022-11-02
142 reads
Tales From The Field Weekly Wrap Up for the Week of 10-17-2022
Hello Dear Reader! I hope you had a fantastic weekend. This weekend we celebrated my parents 50th wedding anniversary, my oldest daughter flew into town for an early birthday,...
2022-11-02 (first published: 2022-10-24)
118 reads
Daily Coping 1 Nov 2022
Today’s coping tip is to be kind to yourself. Remember progress takes time. I’ve spent most of this year trying to better manage my weight and become healthier. I...
2022-11-01
13 reads
SQL Kilts #SeattleSummitMoments
This is another memory of the PASS Summit, this one an idea from Grant Fritchey, who wanted support the Women in Technology (WIT) events. And have a few laughs...
2022-11-01
35 reads
T-SQL Tuesday #155 Round Up
It’s time to look back at the 155th blog party. I was the host this month, asking about Dynamic SQL. I got quite a few responses, which I’ve gone...
2022-11-01 (first published: 2022-10-31)
14 reads
Daily Coping 31 Oct 2022
Today’s coping tip is to find a new perspective on a problem you face. I don’t face many big problems, but I do face lots of small ones on...
2022-10-31
11 reads
Granular Cost Management for Azure Data Factory
A new feature has been launched that allows you to have more granular control over the execution costs of your pipelines. By enabling the feature, you have a cost...
2022-10-31 (first published: 2022-10-19)
426 reads
Paid Flyway Advantages–Undo and Check
The Community edition of Flyway has some nice basic features, and it works well for many people. However, it requires you to do a lot of the heavy lifting...
2022-10-31
163 reads
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers