Get acquainted with SQL Server configuration tasks so that you can configure a Database Engine instance to meet performance and availability requirements. When a database is deployed into production ...

Troubleshoot Database Mirroring Configuration (SQL Server) [!INCLUDE SQL Server] This topic provides information to help you troubleshoot problems in setting up a database mirroring session. Note ...

When configuring the SQL Server for remote access, you must allow certain ports and programs through the firewall to ensure clients can connect to the database securely. Before we begin, make sure you ...

Here, you will find out how you can repair a corrupted database in SQL Server by using some manual methods or with a help of a dedicated app.

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip.

A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...