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 filter To select non domain controllers

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 […]

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 […]

Windows Internal Database Connection String Windows 2012R2 2016

ADSI Edit PKI tree

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 […]

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 […]

Repository Adventures In SQL Server

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

Installing the WebDav client on Windows Server 2016

As many remote storage solutions now provide a WebDav access (from Sharepoint to Nextcloud), having the ability to natively upload and download files from a WebDav Server on Windows Server 2016 may be useful. As opposed to the previous versions, you do not need to install the Desktop Experience feature […]

Microservices architecture best and worst practices

Regularly, the IT world discovers the alpha and omega patterns that should solve all the software or hardware problems. Recently, Microservices has been a trend and of course it is time to list the microservices architecture best and worst practices. In a youtube video “Avoiding Microservice megadisasters”, Jimmy Bogard outlines […]