SQL Saturday
The SQL Server community has a new event to attend in local markets. The Orlando Users Group put on SQL Saturday recently and here's a short look at how this event came about, and how you might run your own event.
SSW Tech Breakfast - SharePoint (MOSS)
If you are near Sydney, Australia, Marten Ataalla will provide an introduction to Microsoft SharePoint 2007 with the aim of evaluating its effectiveness for Enterprise Content Management (ECM).
XML Workshop XI - Default Namespaces
The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.
Featured Blog: CHECKDB From Every Angle: Can CHECKDB repair everything?
What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.
Beginning Database Design - Spot the Flaws
A new series by Steve Jones that tackles a basic design of a few tables. Read the scenario, look over this design, and see if you can find the problems.
.NET Building Blocks: Build a Configurable Database Credential Selector
This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types.
Enterprise Architecture: Connect-Dots for Adults, Part 2
This article, the second in a series, discusses what items could be contained in the enterprise architecture and touches briefly on how to organize the objects.
Monitoring on a Budget
Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this
Open Enrollment
It's the time of year where employment benefits renew for many US employees. Steve Jones talks about how much your company should care about your health.
The Weekly News for November 19, 2007
A few comments on the news of the past week: SQL Server 2008 CPT5, a 1.6SSD Array, Non-Compete agreements and more.
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
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
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...
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