Sysadmins of the North (Page 16)

Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security

Add websites and application pools to IIS with PowerShell, in a for loop

How to use Powershell to create websites and application pools in IIS

Windows Live Mail error 0x80041161 (Fix)

After not using Windows Live Mail for quite some time, it gave me an error code 0x80041161. This Windows Live Mail error can have several different reasons, like corrupt files or services that aren't started, not easing the task of identifying the cause. Read on to learn how to fix this Windows Live Mail error 0x80041161...

Create your own CDN using IIS Outbound Rules

Offloading content is important for the performance of your website, because then content is downloaded in parallel and thus faster. A faster website attracts more visitors, is more user friendly, improves CTR and Google SEO. Here is how to create a Content Delivery Network (CDN) using IIS outbound rewrite rules.

Bash: Grep through a large number of files - "Argument list too long"

/bash/grep and /bash/rm give me an error Argument list too long. Here is how to overcome this grep error.

WordPress CMS admin password reset

How to reset your WordPress password? If you've lost or forgotten your WordPress admin password, you can easily reset the password. Either use the following MySQL statement to reset your WordPress admin password, or change it through functions.php.

Fix "Could not establish trust relationship for the SSL/TLS secure channel" error

Here is how to resolve the ASP.NET exception "System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

ASP.NET performance: what to keep in mind

A lot of information is available on this subject. In this post I'll share some valuable posts, and I continue to update this post when I find something new. Posts about ASP.NET performance I frequently pass on to customers so they can improve their ASP.NET web applications.

Don't turn off CURLOPT_SSL_VERIFYPEER and fix your PHP configuration

Do not turn off CURLOPT_SSL_VERIFYPEER in your PHP configuration, but learn how to fix your PHP config instead.

Installing Debian GNU/Linux 7.0 (Wheezy) on HP EliteBook 8570w

I was FedUp with Fedora Core 17/18 after a day, so I decided to return to my old love: Debian GNU/Linux. It's been a couple of years, but I'm happy to be back! Just run the netinst installer which will take care of the most.

Connect to SqlCe (SQL Server Compact) database from ASP

Here is how to install the Microsoft.SQLSERVER.CE.OLEDB.4.0 Provider and use classic ASP to connect to an SqlCe (SQL Server Compact) database sdf file, as a Microsoft Access database replacement.

How to send authenticated SMTP over a TLS encrypted connection, in PHP, ASP and ASP.NET?

Learn how to send email securely from your website using TLS with ASP.NET, PHP, WordPress and Classic ASP!

Grep for forensic log parsing and analysis on Windows Server IIS

How to use GnuWin32 ported tools like grep.exe and find.exe for forensic log file analysis in Windows Server.

Drop all tables, SPs, triggers, constraints and dependencies in one SQL statement

Drop all tables, SPs, triggers, constraints and dependencies in an SQL Server database in one SQL statement.

Connect to MS SQL Server with PHP 5.3+

Learn how to conditionally add Google Analytics tracking code to your WordPress Multisite

MySQL Connector/NET and Entity Framework

How to let MySQL Connector/NET and [Entity Framework](https://learn.microsoft.com/en-us/aspnet/entity-framework) play nicely. This blog post is a quicky and an oldy… Since we still receive a reasonable amount of questions about this topic at the customer service of my employer I'm posting this here, with some commonly made mistakes and points of attention.