Database Mirroring is Back in Azure SQL Database
Database Mirroring comes back to SQL, at least to Azure SQL Database with Fabric as the destination. Read a few of Steve's thoughts on this feature.
2024-03-30
480 reads
Database Mirroring comes back to SQL, at least to Azure SQL Database with Fabric as the destination. Read a few of Steve's thoughts on this feature.
2024-03-30
480 reads
1202– n. the tipping point when your brain becomes so overwhelmed with tasks you need to do, you feel too guilty to put anything off until later, prioritizing every...
2024-03-29
34 reads
2024-03-29
371 reads
Many of us have a journey, either to SQL Server, or in today's world of many databases, perhaps away from SQL Server. Steve looks at his, and another's, journies.
2024-03-29
132 reads
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can customize them. Another article will cover the Database dashboards. […]
2024-03-28 (first published: 2024-01-29)
4,013 reads
Recently Microsoft released SQL Server Management Studio (SSMS) v20.0, which is a major release of the primary tool that many of us use to work with SQL Server. Over the last few years, the tools team at Microsoft has worked to separate the tools from the various editions, giving us separate SSMS downloads. There have […]
2024-03-27
15,565 reads
2024-03-27
368 reads
Managing costs in the cloud is something many companies are concerned about. Today Steve thinks that technical people will bear more responsibility for this in the future.
2024-03-27
280 reads
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM), which was a new product for us. You can watch the video linked above to...
2024-03-27 (first published: 2024-03-18)
139 reads
Steve does a lot of work with teams trying to adopt DevOps, and today has another description of what this can mean for your team.
2024-03-25
210 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
Ruko Soho Emas, Jl. Klampis Jaya No.39, Klampis Ngasem, Sukolilo, Surabaya, Jawa Timur 60117
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers