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

In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. (You can read the full announcement blog post at ...

As SQL Server 2016 approaches end of support in July 2026, a look back at its groundbreaking innovations reveals how it reshaped Microsoft's data platform and why it's time to move forward.

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

SQL Server 2025 delivers major performance upgrades alongside licensing changes that can reshape both operational speed and budget strategy. Smarter query execution, refined CPU scheduling, and better ...

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

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

Microsoft only just officially released SQL Server 2019 at its Ignite conference in Orlando, Fla., but it announced some key changes to licensing a little bit earlier. Don't worry -- they're all ...

A newly released SQL Server baseline guide outlines how to collect and analyze historical performance data to define normal workload patterns and detect anomalies. It recommends using tools like DMVs, ...