Products

All products


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


Storing sp_configure settings in a stored procedure

All SQL Server DBAS are familiar with sp_configure to change the instance global settings. However when you need to modify temporarily those settings from within your code, such as storing sp_configure settings in a stored procedure, the process can become awkward You need to store the configuration setting you change […]

instmdb sql file excerpt

visual studio community 2017 web page screenshot

Trial period reset of Visual Studio Community Edition 9

Although Visual Studio Community Edition is supposed to be free, you are required after 30 days by the graphical interface to have an account on Microsoft’s online services to continue to use the product. The trial period reset of Visual Studio Community Edition can however be easily achieved by editing […]


‘MEDIALAYOUT’ in SQL Server ConfigurationFile.Ini 2

While trying to install new instance of SQL Server using command line and the ConfigurationFile.ini unattended answer file, you may receive the following error message : MEDIALAYOUT in SQL Server ConfigurationFile.Ini Don’t waste your time searching in different documentations about the allowed keywords for the configuration file. This error means […]

SQL Server Logo