This article describes how to configure an instance of the SQL Server Database Engine to listen on a specific fixed port by using SQL Server Configuration Manager. If enabled, the default instance of ...

This article describes how to configure SQL Server Agent to use Database Mail to send notification and alerts in SQL Server by using SQL Server Management Studio. The user creating the profiles ...

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

Although there was significant fanfare surrounding SQL Server Query Store's initial release in SQL Server 2016, many companies have been hesitant about adopting the performance monitoring and ...

Microsoft SQL Server Integration Services (SSIS) is an enterprise platform for setting up data integrations and data transformations. The main elements of the SSIS architecture are two engines. These ...

According to Microsoft, you can use the contained database model to make the database more portable. This prevents orphaned users after a restore by authenticating accounts directly at the database ...

Discover how to use Google Cloud Database Migration Service to shrink Cloud SQL for SQL server disks with minimal downtime.

Learn about the latest features and future of SQL Server 2022 in this interview with Asad Khan, VP of SQL Products and Services at Microsoft. Microsoft has officially released its highly-anticipated ...

When it comes to the type of storage you might use for a cloud-based SQL Server deployment, all the major cloud providers provide a bewildering array of options. Azure offers Standard HDD as well as ...