When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...

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.

Azure Data Studio will officially be retired on February 28, 2026. Microsoft just announced the retirement in a blog post, recommending that all users try out the alternatives: Visual Studio Code and ...

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

I am a system administrator with ten years of experience in the IT field. I am a system administrator with ten years of experience in the IT field. I am a system administrator with ten years of ...

This Azure PowerShell script example creates a single database in Azure SQL Database and configures a server-level firewall rule. After the script has been ...

Have you used PSEdit to open a file in a new tab in your PowerShell ISE session? PSEdit is a built-in function that runs only on PowerShell ISE. It’s simple and easy to use. Enter in a filename and ...

Microsoft released new Azure SQL database configurations with more compute power cores and higher processing rates. The cores are based on the latest Intel and AMD processor generations. The tech ...

It is that time again! We are excited to bring new and exciting updates to Azure Data Studio. These updates include the general availability of the Azure SQL Migration Extension, the introduction of ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...