Free Training Webinar Series - October
A series of free webinars from Pragmatic Works that cover a variety of topics in October.
From One of the Pack to ‘Top Dog’ – Honeymoon Period Over!
In part two of his editorial series on moving to being a manager, Justin H-Davies talks about the challenges that are evolving of being a manager.
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
Policy-based Management and Central Management Servers
Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.
T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
SQLSaturday#59 Speaker Session Schedule Announced
SQL Saturday is bringing a free day of training to NYC this November.
Writing Nearly Codeless Apps: Part 2
In this article, learn why it makes sense to build a more standarized, more robust database based on rules and see how data modeling works in the RAP software.
Yikes!
Did malware cause a plane crash? Not likely, but Steve Jones warns us it could and we need to be very security conscious when we have computers linked together in transportation systems.
Early October Free Training from PASS VCs
More Free Training is coming to a computer near you from the AppDev, BI, and DBA Virtual Chapters of PASS.
Restore from LiteSpeed
Learn how to restore a LiteSpeed backup on a server without the software in 2 Simple Steps.
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