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 ...

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 ...

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 ...

One of the many qualities of OneLake in Microsoft Fabric is, that it automatically builds SQL Analytics Endpoints for all your delta-tables. In AP Pension, we have a lot of SQL users, who work in ...

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 ...