🌐 What is Azure SQL Migration Extension? The Azure SQL Migration Extension for Azure Data Studio is a powerful tool that simplifies the process of migrating on-premises SQL Server...
2025-08-27 (first published: 2025-08-06)
234 reads
Migrating databases to the cloud can be complex, but Azure Database Migration Service (DMS) simplifies the process with a robust, fully managed solution. Whether you’re transitioning from SQL Server, MySQL, PostgreSQL,...
2025-08-20 (first published: 2025-07-31)
434 reads
Migrating SQL Server databases is a critical task for IT teams aiming to modernize infrastructure, improve performance, or transition to cloud platforms. One of the most widely used tools...
2025-08-15 (first published: 2025-07-30)
329 reads
🚀 Introduction SQL Server 2025 is a landmark release that redefines how developers and data professionals interact with data. With the rise of AI, unstructured data, and real-time analytics,...
2025-08-13 (first published: 2025-07-29)
1,923 reads
When deploying SQL Server in enterprise environments, choosing the right service account model is critical for security, manageability, and scalability. Traditionally, DBAs have relied on standard domain accounts with static passwords,...
2025-08-12
30 reads
In today’s hybrid and multi-cloud world, managing SQL Server instances across diverse environments can be a daunting task. Enter Azure Arc—Microsoft’s game-changing solution that brings the power of Azure to...
2025-08-07
21 reads
PostgreSQL is a powerful open-source relational database system, but over time, its tables and indexes can become bloated due to frequent updates and deletions. This can lead to inefficient...
2025-08-05
53 reads
Introduction Migrating databases can be a complex task, especially when dealing with large-scale systems or transitioning to cloud environments. The SQL Server Migration component in SQL Server Management Studio (SSMS) offers...
2025-08-01
121 reads
Upgrading SQL Server is a mission-critical task for DBAs, especially when the goal is zero disruption to application connectivity. Whether you’re modernizing for performance, compliance, or supportability, choosing the right...
2025-07-28
133 reads
📘 What Is TempDB and Why It Matters TempDB is a shared system database in SQL Server used for: Because it’s used by every session and process, TempDB is often a performance bottleneck—especially...
2025-07-24
1,356 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers