SQL Server

Umbraco logo blue

How to optimize Umbraco 8 performance

Out of the box, Umbraco is a well built and pretty fast content management system. However, it is important you perform some steps to further optimize Umbraco’s performance and loading speed. Here on Sysadmins of the North, I wrote about “11+ tips to optimize Umbraco CMS” earlier, and in this post I write about implementing them. On a just installed and running website.

Microsoft SQL Server logo

Install SQL Server cumulative updates silently

Installing SQL Server cumulative updates is always a cumbersome, and quite daunting task. Unpacking and running the CU installer is a slow process, you have to click through a lot of screens, and it’s hard to get it to install silently. But here is how!

Learn how to install SQL Server cumulative updates (CU) silently using PowerShell opposed to the cumbersome task of running the GUI installer.

Umbraco Project Belle

11+ Tips to optimize Umbraco 7 CMS

Umbraco 7 is a popular, ASP.NET powered, content management system (CMS). Even though it performs pretty well, here are 11+ tips to optimize the performance of Umbraco 7 powered websites on IIS.

How to install Microsoft’s SQL Server Driver for PHP

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.

Umbraco Project Belle

Configure SQLServer sessionState for Umbraco

Configure Umbraco for SQLServer sessionState storage, for your ASP.NET sessions. This post explains how to prepare your Umbraco website for a high performance web garden or web farm, and load balancing environments: Store your ASP.NET / Umbraco sessions out-of-process (OutProc). As opposed to the default in-process (inProc) sessions, where sessions are saved in the worker process. Create a high performing, fast loading Umbraco website.

Connect to MS SQL Server with PHP 5.3+

As of PHP 5.3.2 you have to use the SQLSRV API functions to connect to an MS SQL Server database from PHP. For example, use sqlsrv_connect() to create a connection resource and open a connection. The main difference with the older mssql functions of PHP is that SQLSRV requires an Array() with connection information, instead of strings.

Umbraco logo blue

Umbraco CMS admin password reset

If you forgot your Umbraco admin password, use the following SQL query to reset your Umbraco admin password in SQL Server Management Studio (SSMS) or MySQL