The challenges of SQL Server consolidation
Despite the benefits of SQL Server consolidation, some IT pros are still reluctant to make the move. Learn which scenarios could pose a challenge to those looking to consolidate.
Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
LinkedIn - Part 3
As I've covered in my two earlier posts I've been investing a little time to figure out how to make LinkedIn work for me. This time I wanted to talk about some extra tools they provide that you may find useful. One that I mentioned previously...
Shapes in the Clouds
Continuing on with his week in the clouds, Steve Jones looks at how SQL Server might appear in the cloud world.
Shapes in the Clouds
Continuing on with his week in the clouds, Steve Jones looks at how SQL Server might appear in the cloud world.
Shapes in the Clouds
Continuing on with his week in the clouds, Steve Jones looks at how SQL Server might appear in the cloud world.
SQL Server 2008 Resource Governor primer
In this chapter excerpt from "Microsoft SQL Server 2008 Management and Administration", learn how Resource Governor can improve SQL Server performance.
Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
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