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
Windows Subsystem for Linux gets new ‘mirrored’ network mode, providing IPv6 support. This is huge! Update WSL2 in Windows Insider Program to have experimental IPv6 support.
Sometimes you need to convert a Windows SID (security identifier) to an username, or vice versa (an username to an SID). In this post I show you a couple of methods to translate the one into the other. One is using VBScript and one is using PowerShell.
Quickly get SQL Server backup .bak file header information using PowerShell and SQL Server Management Objects (SMO). Determine the name of the SQL server that wrote the backup set.
Use PowerShell, Performance Counters and WMI to get the current number of active connections to IIS websites. Perfect for monitoring IIS webservers in Zabbix.
Use PowerShell to install SSL certificate in Windows Server and change its FriendlyName property. As a bonus, I show you how to verify a certificate’s Common Name (Subject) and Subject Alternative Name (SAN) using certutil.exe and PowerShell Get-PfxCertificate.
Learn how to reconfigure Windows Server’s TCP/IP stack and IIS for high performing websites. Prevent running out of available ports/sockets (port exhaustion).
Here is a small T-SQL snippet that creates an additional (extra) SQL Server Login (User) for contained databases in SQL Server. It sets memberships too.
Monitor Microsoft SQL Server, databases and performance with Zabbix, PowerShell, Performance Counters and WMI. Keep SQL Server and databases in top shape and performance up! In this post I show you how you can use Zabbix to monitor those important aspects for database administrators (DBA).
Before you can properly debug crash and memory dumps in Windows (Windows 11, Windows 10, Windows Server), you need to install WinDbg -Windows Debugger- and its debugging symbols. In this article I explain how to set up these debugging symbols for WinDbg in Windows. Debug BSOD like a boss!
To extract all files from a .msi file, use the following msiexec command and arguments. Windows has the ability to allow the MSI package (.msi file) contents to be extracted using the command line or via a script.
Connect virt-manager to a KVM host over ssh (qemu+ssh://) in Windows using Windows 11 and WSL 2. This setup allows you to connect to virt-manager through an ssh tunnel and an arbitray port through a bastion host and ssh key authentication.
In this post I showed you how you can turn Windows 11 and Windows 10 with WSL into a fully fledged development environment. Here are the settings and tools I use for DevOps/SysOps on Windows. It may take some getting used to, but if you’re as shortcut-Ninja as I’m (I alt-tab, ctrl-c/ctrl-v a lot), you can work pretty fast in this set up.
