If you are introducing DevOps workflows into a large organization, you’ll need to plan carefully and prioritize tasks, adapt, maintain a thick skin, communicate constantly, and ensure that all...
Andy Mallon explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.
In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.
Today Steve Jones looks forward to the next version of SQL Server, with his curiosity to see if you feel the same way.
Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.
Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
The path to becoming a data scientist isn't simple or easy, but it might be for you.
Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers