SQL Server Management Studio (SSMS) is the tool of choice for most developers working with SQL infrastructure and data. Microsoft recently released SSMS version 22, and in the past few months, it has ...

It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL extension for Visual Studio Code. Microsoft recently ended support for Azure Data ...

In this article, I will discuss the Lost Update Concurrency Problem in SQL Server with Examples. Please read our previous article discussing the Dirty Read Concurrency Problem in SQL Server with ...

Microsoft has announced that SQL Server Integration Services (SSIS) is now officially supported in the latest SQL Server Management Studio (SSMS) 22 Preview 3. This release is quite important for ...

Before you can document your SQL Server environment with SQL Power Doc you'll to meet the following requirements: Permissions - SQL Power Doc makes connections to standalone SQL Server instances using ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

In today’s fast-paced business world, time is a valuable resource, and organizations are constantly looking for ways to save it. One area where time-saving can make a huge difference is in the ...

DBCC CLONEDATABASE command generates a schema-only clone or copy of a database. Effective March 1, 2025, Microsoft will no longer support creating copy of a database using the DBCC CLONEDATABASE ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

This simple tool solves a very annoying problem of Management Studio: Open HUGE script files. Microsoft SQL Server Management Studio opens the entire file into memory, and this can be a problem if ...