Investing for AI
Steve looks to the future of Microsoft and AI after listening to a podcast with Satya Nadella
Running SQL Server in Local Containers with VSCode MSSQL Extension
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.
Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform
In this next article on the Fabric Modern Data Platform, we examine setting up an on-premises gateway.
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Learn about dbt, a tool used by lots of data engineers to move data between systems.
Your Security Checkup
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.
5 Strategies to Refactor SQL Code
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.
How Important Are Real Time Decisions?
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.
T-SQL in SQL Server 2025: The UNISTR Function
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 […]
How to Query JSON Data Quickly in SQL Server, Part 2: SQL Server 2025
SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and querying it quickly.
SQL Server Licensing is Simple
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 […]
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCU BLOK A CIPETE Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta...
BCA KCP Taman Sari TLP/WhatsApp 08216366654
Jl. Taman Sari Raya 47-47A, Taman Sari, Kec. Taman Sari, Kota Jakarta Barat, Daerah...
BCA KCP Santa Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus...
Question of the Day
Creating a JSON Document III
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