Create an additional SQL Server Login
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.
Windows Server
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)
Monitor SQL Server and databases in depth using 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 / WMI and Zabbix for in depth monitoring of your SQL Server server and databases.
Configure Windows Debugging Symbols in WinDbg
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!
Extract files from an MSI package
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 to a KVM host through an ssh tunnel and arbitrary port in Windows 11 and WSL 2
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 and ssh key authentication. Here is how.
Windows 11/10 and WSL 2 DevOps environment
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.
YubiKey support in OpenSSH for Windows 11 and Windows 10
In this post, I’ll show you how to properly install Microsoft OpenSSH client in Windows 11 and Windows 10, and how to configure your YubiKey.
Monitor .NET CLR Garbage Collected heap from your web application
Use Zabbix to monitor your web application and application pool’s .NET CLR Garbage Collected heap by utilizing WMI and PowerShell.
Quickly check EnableTrailerSupport isn’t set in your network for http.sys (CVE-2022-21907)
Find out fast if your IIS webservers have EnableTrailerSupport enabled for https.sys in the registry. Here is a small PowerShell method.
Adding VirtIO drivers to Windows Recovery Environment (Windows RE)
If you need to add VirtIO drivers to your Windows Recovery Environment (Windows RE) to recover your Windows virtual machine, here is how. The following steps come in handy if you found out the hard way you don’t see any disks in Windows RE after a hard crash. Learn hto customize your Windows System Restore (how-to)
Retrieve SSH public key from Active Directory for SSH authentication
How to configure SSH public key authentication for Windows Server in Active Directory (AD)? In this article I’ll explain how to store and retrieve your SSH public keys from Windows Server Active Directory.
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!
Remove computer object from Windows Server Update Services (WSUS) in PowerShell
Here is a short PowerShell snippet for you to remove a computer object from Windows Server Update Services (WSUS).
How to add, list and remove IP addresses in Windows Firewall
Here is how to bulk add IP addresses in the Windows Firewall, list an IP address and remove all IP addresses from Windows Defender Firewall with Advanced Security. In Windows 11, 10 and Windows Server
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.