You are here: Sysadmins of the North » Windows Server

Windows Server

Windows Server logo small Microsoft Windows Server 2016 logo

Windows Server articles and howtos. With Windows Server you can scale to run your most important workloads with robust recovery options. You’ll achieve value quickly with a wide range of cost-effective, high-performance storage options and simplified delivery of multi-tenant IT services. You can build, deploy, operate, and monitor applications on premises and in the cloud. Empower users with secure access to corporate resources on the devices they choose.

Microsoft SQL Server database: security, performance, code, T-SQL, PowerShell and information

(featured image credit: Freddy2001 on Wikipedia)

You are here: Sysadmins of the North » Windows Server

Get SQL database backup details with PowerShell

Microsoft SQL Server logo

Learn how to query the .bak file for header information. Whenever I need to restore an SQL Server .bak backup file, I want to know some properties of the backup file to make sure I’m working with the correct file(s). Luckily, the .bak file and PowerShell provide all the information I need, so I don’t have to start a Restore procedure in SQL Server Management Studio (SSMS) just to view the header information. As you know, SSMS is slow…

Get IIS Current Connections using PowerShell

Do you want to know how to get the current number of connections to IIS hosted websites? The information is stored in Windows Server Performance Counters, and you can get it using Get-Counter cmdlet in PowerShell of course. But in post I’ll show you a different -and perhaps even faster- method using WMI/CIM and Win32_PerfRawData_W3SVC_WebService. Read on…

Tune Windows Server TCP/IP and IIS

When you have set up your ASP.NET / .NET or PHP configuration for high performing websites in Windows Server, it sometimes becomes important to reconfigure Windows Server’s TCP/IP stack and IIS too. You may have to increase network throughput and performance, or you just might run out of available ports / sockets (aka port exhaustion). And, as you know, fast page loads are more and more important nowadays for seach engine optimization (SEO) and user experience. Therefore we’ll dive into tuning IIS and TCP/IP stack for high performance websites and high volume of web requests a bit.

Monitor SQL Server and databases in depth using Zabbix

Microsoft SQL Server logo

SQL Server performance monitoring in Zabbix: Keeping your SQL Server and databases in top shape is key for a good performing SQL Server database server and its databases. A good performing server makes happy customers, and that’s what puts bread on the plank, right? In this post I’ll show you how you can use Windows Performance counters, PowerShell and Zabbix for in depth monitoring of your SQL Server server and SQL databases.

Connect to a KVM host through an ssh tunnel and arbitrary port in Windows 11 and WSL 2

Virt-manager image

If you need to connect virt-manager to a KVM host over ssh in Windows, then Windows 11 and WSL 2 made things a whole lot easier for you. Even if you need to connect virt-manager through an ssh tunnel and arbitrary port because your network is reachable only through a bastion host with ssh key authentication. Here is how.

YubiKey support in OpenSSH for Windows 11 and Windows 10

OpenSSH logo

Since Win32-OpenSSH version 8.9.1.0p1-Beta there is decent support for FIDO/U2F hardware authenticators. This means we can use a YubiKey with Windows 11 and Windows 10, w00h00! In this post, I’ll show you how to install Microsoft OpenSSH client in Windows 11 and Windows 10, and how to configure your YubiKey. If you follow this guide and all goes well, you no longer need additional tools like Git Bash or MremoteNG/MobaXterm.

Monitor .NET CLR Garbage Collected heap from your web application

Are you worried about your .NET webapp running out of memory? In order to let your .NET (web) application run smooth over a longer period of time, it is important to monitor the .NET CLR Garbage Collector (GC) and collection. The what? The .NET Common Language Runtime Garbage Collector. Here is how you can monitor this in a Zabbix template using Powershell WMI / CIM and Win32_PerfRawData_NETFramework_NETCLRMemory Windows Performance Counters.

Scroll to Top