featured article
Convert SqlCe database to SQL Server
Latest articles
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.
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.
Block brute force attacks on SQL Server, block IP addresses in Windows Firewall using PowerShell
This PowerShell solution blocks IP addresses that are trying to brute force your SQL Server logins, by blocking IP addresses in Windows Defender Firewall with Advanced Security, using PowerShell. You can use this to create your own solution to block offending IP addresses in SQL Server’s firewall.
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.
Manually failover all databases in an SQL Server Database Mirroring configuration
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).
ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL
This article provides you with a couple of ASP.NET to SQL Server connection string examples for ODBC and OLE DB. And as a bonus for ASP to SQL Server, MySQL, and SSL encrypted connections too.
How to determine if a SQL Server backup is compressed?
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.
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.
SQL Server versions list
How to Identify Your SQL Server version and edition. An unofficial build chart lists … Read More
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 SqlCe (SQL Server Compact) database from ASP
Connect to SQL Server Compacy (SqlCe) database with ASP. Here is how to install … Read More
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 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