SQL Server 2025: What’s New, Features, and Changes
Explore SQL Server 2025 features and changes, including native vectors, AI, JSON, regular expressions, performance, Fabric integration, edition changes, and discontinued features.
Explore SQL Server 2025 features and changes, including native vectors, AI, JSON, regular expressions, performance, Fabric integration, edition changes, and discontinued features.
Learn how to parse JSON in SQL Server using OPENJSON, JSON_VALUE, JSON_QUERY and ISJSON, with examples for arrays, nested objects, table columns and SQL Server 2025.
While deploying a DACPAC project to Azure SQL Database using Azure DevOps, you may encounter an error due to specifying SQL Server 2022 as the target platform. The article provides steps to fix this issue by changing the target platform to ‘Microsoft Azure SQL Database’ in Visual Studio and rebuilding the project.
Learn how transaction batching in SQL Server reduces transaction log pressure, limits blocking, and makes large UPDATE and DELETE operations safer and easier to manage.
Quick answer: This SSIS error can occur when an SSISDB database restored to another SQL Server instance cannot load the
DACPAC file can be used to deploy database code using CICD tools like Azure DevOps. Learn how to open DACPAC file in Visual Studio.
Learn how to find stored procedures that reference a table in SQL Server and Azure SQL using dependency metadata, sys.sql_expression_dependencies, and practical T-SQL queries.
Learn how to find and prevent SQL Server deadlocks using Extended Events, system_health, deadlock graphs, DMVs, Query Store, and practical transaction and indexing strategies.
The server principal is not able to access the database “master” under the current security context.
Learn how to create a DACPAC from a SQL Server database using SSMS or Microsoft SqlPackage. This guide covers prerequisites, extraction commands, validation, troubleshooting, and DACPAC versus BACPAC.