A Successful Blogger on Making the Switch
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and brand that she never thought was possible.
2021-09-27
44 reads
Blog Posts
Book Review: Lights Out
I have always been interested in GE since I was a kid. My best friend in high school had a parent that worked for the company for a bit...
2021-09-27
46 reads
Daily Coping 27 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-27
36 reads
Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-09-27
6 reads
My upcoming Online Trainings and Speaking Engagements
Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the...
2021-09-27 (first published: 2021-09-15)
177 reads
Wednesday Webinar with Pavilion – SQL Server Performance
I’m thrilled to announce a new webinar with Pavilion Data for this Wednesday, September 29, 2021, at 10:00am Pacific time entitled “Achieve 3x SQL Server Performance While Doubling VM...
2021-09-27
105 reads
Daily Coping 24 Sept 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-24
46 reads
How to Design Backups in SQL Server?
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be recovered and the time that it will take to recover....
2021-09-24
15 reads
Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available
Last week, Kerry and I delivered a webinar with tips on how to set up your Data Factory. We discussed version control, deployment, naming conventions, parameterization, documentation, and more....
2021-09-24 (first published: 2021-09-16)
166 reads
T-SQL Tuesday #142–What is Bicep?
It’s time for the monthly blog party, and this month the host is Frank Geisler. I was reaching out to various people last year to find hosts, and also...
2021-09-24 (first published: 2021-09-14)
312 reads
Blogs
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...
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...
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