Late in 2017, I informed you about a public preview for a new data management tool from Microsoft called SQL Operations Studio. SQL Operations Studio is a very flexible and lightweight data management ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

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

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 part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

According to recent data from the SolarWinds "State of Monitoring and Observability Report," 51% of IT pros believe database performance would benefit from better observability. Oftentimes, database ...

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Microsoft shipped SQL Server Management Studio 22.7.0 on Wednesday, June 10, 2026, in what the team called one of the bigger point releases in the 22.x cycle. Database developers who have spent years ...