featured article
How to set SVN_EDITOR environment variable in Windows Server
Latest articles
Month: October 2018
Manually failover all databases in an SQL Server Database Mirroring configuration
2018-10-25
A manual SQL Server failover can only be initiated from the principal server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state). In this article I will show you how to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017 and up.
ASP and ASP.NET connectionstring examples for Microsoft SQL Server and MySQL
2018-10-17
Modern connection string examples for ASP.NET Core, Legacy ASP.NET, and Classic ASP. Learn how to use MSOLEDBSQL, ODBC 18, and fix MySQL UTF-8/Emoji support.
MySQL Connector/ODBC C# test script
2018-10-03
Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used