PASS - September
The PASS Summit is coming this November and SQLServerCentral.com is looking to throw another great party.
Resource Governor
This article is about Resource Governor. A new feature introduced in SQL Server 2008. Special focus is placed on the T-SQL implementation of the new feature.
The Release Schedule
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints
In the latest articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing Service Broker. This article describes the initial setup of components required to demonstrate a distributed implementation, with initiator and target services residing on two separate computers.
SQL Server 2008- SSIS Data Profiling task
By using SQL Server 2008’s new Data Profiling task, you can do a lot to ensure that data being imported via SSIS is valid, and you can develop a system that can take the necessary steps to correct the commonest problems. Bob Sheldon shows you how to get started with it.
The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
An interview with the Exceptional DBA of the Year
Dan McClain was voted the Exceptional DBA of 2008 by the SQLServerCentral.com community. Learn a bit more about this talented professional in his own words.
Databases for Change
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
Blogs
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...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
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