You are a developer using SQL Server for your applications, and you need to quickly setup a local development environment. How can you make sure the environment is OS agnostic, so it can run on any operating system? Let’s see how we can quickly create a local container to run SQL Server using the VSCode MSSQL Extension.
In this next article on the Fabric Modern Data Platform, we examine setting up an on-premises gateway.
Learn about dbt, a tool used by lots of data engineers to move data between systems.
We often find security issues come from holes in the way we've set up systems. Steve asks if you perform security checkups on your systems.
Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality code – yet somehow often gets overlooked in SQL.
There has been a push to build real time analytics and decision support systems. Steve discusses whether this is a good idea for many organizations.
I am not much for working in languages other than English. That's my native language and I know little about others. However, the last few years I find myself using emojis more and more in quick communications as they seem to add some fun to the interaction. And those interactions need to be stored in […]
SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and querying it quickly.
Over the years I've had no shortage of licensing questions for SQL Server. At times it's felt a little crazy. Look at the licensing guide. Choose EE or SE and the number of cores. Then check if you're using VMs. Oh, and consider the cloud, and which cloud you're running a workload on. It's simple […]
In this level, we learn about the database file size growth in Hyperscale.
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...
J & K, Jl. Caman Raya No.17, RT.003/RW.003, Jatibening, Kec. Pd. Gede, Kota Bks,...
Jl. Astana Anyar No.128, Cibadak, Kec. Astanaanyar, Kota Bandung, Jawa Barat 40241
BCA KCP Mega Kuningan tlpn/wa: (0831)10703017 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan,...
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