SQL Server 2025 includes new features and enhancements. In the previous SQL Server 2025 tips, we have explored many new features. Have you explored the new Product() function? If not, this will walk you through the Product() function with several examples.
Learn how backup and restore work in Azure SQL Hyperscale in this next level in the stairway series.
Steve sees a lot of challenges ahead for AI, especially in the area of labor and employment.
Securing SQL Server isn’t complicated, but it does require consistent attention to the areas where real risks arise, such as privileges, configuration, encryption, patching, and monitoring. This article outlines 15 practical, high-impact steps you can take to harden your SQL Server environment.
This week Steve Jones discusses artificial intelligence and one of the building blocks that will be needed: data.
When using only an LSN to track which changes you have processed, you can lose data. This article shows how to avoid this problem.
In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with tiny T-SQL.
The problem that I continue to struggle with the AI Bubble is not innovation, but who has leverage. The AI industry has quietly constructed a capital stack with too many mutual dependencies and too few independent cash flows. When AI profitability hiccups, the financial impact does not land in one place. It cascades across the entire championship and everyone loses and not all players are equally positioned to survive it. This is the AI Bubble in a foundational nutshell.
Refactoring code is a common task in many software development teams. Steve asks if this is something common for database developers as well.
This article discusses how to work with JSON data in PostgreSQL using Python.
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers