You are here: Home ยป Archives for October 2018

Month: October 2018

How to set SVN_EDITOR environment variable in Windows Server

On a newly installed workstation or server, you might encountered the following subversion error when you commit a change: 2,210 views Did this post helped you solve a problem? Or dit you find it interesting? Support Sysadmins of the North with a direct donation via Paypal of by bank wire transfer IBAN: NL31 ABNA 0432217258 …

How to set SVN_EDITOR environment variable in Windows Server Read More »

File cabinet image

Manually failover all databases in an SQL Server Database Mirroring configuration

How to manually failover an SQL Server database mirroring session? How to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017+. This 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’ll show you …

Manually failover all databases in an SQL Server Database Mirroring configuration Read More »

ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL

A connection string is sometimes a bit obscure. Do I need ODBC or OLE DB? When you need one and Google for it, you often find old ones that either don’t work at all anymore, or are not optimal. This article provides you with a couple of ASP.NET to SQL Server connection string examples, and …

ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL Read More »

14 queries, took 0.374 seconds running PHP version 7.4.8