SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals. Here ...

Are you ready to unlock the power of Microsoft SQL Server 2014? In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization ...

In announcing SQL Server Management Studio (SSMS) 21 Preview 1 this week, Microsoft revealed Copilot AI for the tool is also being previewed, privately. A Copilot for the tool that helps users manage, ...

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse. It also ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...