In this article I’ll show you how to force a failover in SQL Server 2017+, in an SQL Server Database Mirroring configuration. This can only be initiated from the principal SQL Server server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state).
This article provides you with a couple of ASP.NET to SQL Server connectionstring examples for ODBC and OLE DB. And as a bonus for ASP to SQL Server, MySQL, and SSL encrypted connections too.
Compressed SQL Server backups can be verified in PowerShell using a handy PowerShell function. This comes in handy when you need to verify if existing SQL Server backups are compressed.
In this article I'll show you how to install the Microsoft SQL Server Driver for PHP 7+. This makes the use of an SQL Server database back-end for your PHP website easy. This post walks you through the steps necessary to install the SQL Server driver and SQLSRV extension for PHP 7+, on Windows Server IIS of course.