Find the MS SQL Servers by using SPN in your AD

In an old post, I was writing about the commands you could use to retrieve the list of your RDS Licensing servers in a domain. Generalizing this LDAP Filter example, you can retrieve a list of Service Principal Names enabled accounts. The examples are as follows: In the powershell syntax […]

WMI filters to target sites and non Domain Controllers

Designing Group Policy Objects is sometimes tricky. Let’s review some useful WMI filters in Group Policy Objects for sites and domain controllers inclusion or exclusion. When linking Group Policy Objects, you are always bound to the LSDOU rule, which means that GPOs are processed in the following order: L for […]

WMI filter To select non domain controllers

Windows Internal Database Connection String Windows 2012R2 2016

How to connect to a Windows Internal Database WID such as WSUS

The Windows Internal Database is nothing more than an embedded lite SQL Server instance running under specific credentials and with a few protocols enabled. Therefore in order to connect, you can use any SQL Server client tool: SQL Server Management Studio, SQLCMD, … Starting with Windows Server 2012, the named […]

Publishing certificates in the Active Directory

Deploying certificates and CRL in a domain or a forest in an automated fashion can done using GPO like many other settings. However a less well-known possibility is to use the certutil -dspublish command. Let’s review how it works. When using that option, certificates are stored in one of the […]

ADSI Edit PKI tree

Repository Adventures In SQL Server

Who’s making your log file grow in SQL Server?

Determining what T-SQL query or SQL Server client application is the source of log file growth is an often asked question. “Old” SQL DBAs would sometimes refer you to KB 317375 which unfortunately is no longer hosted as a Microsoft KB Article, but sadly infinitely loops on one new Docs […]

Windows updates history list

Here are the links to the KB articles listing the security and monthly updates for every Windows Server OS: Windows Server 2008 Windows Server 2008 R2 Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019