SQL
Database Optimization: Purging SQL Logs (LDF)
Learn how to optimize your SQL database by purging logs (LDF). Reduce your log file size and enhance your database performance.
SQL
How to Modify Over 200 Rows in SQL Management Studio
Learn the step-by-step process to efficiently modify more than 200 rows in SQL Management Studio. Discover how to adjust settings in the SQL Server Object Explorer to increase the default row limit
SQL
Searching Column Names in SQL Tables
Search for column names across all SQL tables using a straightforward query. This method offers a quick way to locate specific columns within your SQL database.
ADDS
Automating User Account Creation for Lab
Learn how to automate the creation of multiple user accounts for lab environments using a CSV file and a PowerShell script. Efficiently manage and set up testing accounts in Active Directory
SQL
Configuring SQL Server Ports with netsh in Windows
Learn how to efficiently open the required SQL ports using the netsh command-line tool in Windows. This guide provides step-by-step instructions to manage firewall rules for SQL Server communication.
IIS
Setting Up a Secure FTP Server in IIS with SSL
Learn how to set up a secure FTP server using IIS with an SSL certificate
SQL
Resolving SQL Account Conflict: Addressing Database Restoration Errors
Learn how to resolve the error encountered when restoring a database on a new SQL server if the SQL account already exists. This guide provides a simple command solution to address the issue.
SQL
Mastering SQL Joins
Explore the intricacies of SQL joins and learn how to effectively create SQL queries for your database operations.
MDT
Integrating WSUS TargetGroup with MDT
Explore the process of integrating the « TargetGroup » variable with MDT for WSUS. The article provides a step-by-step guide on setting up the WSUSServer variable and modifying the ZTIWindowsUpdate.wsf script to manage WSUS Target Groups.
ADDS
How to Disable Windows Update using GPO
Learn how to effectively disable Windows Update using Group Policy Object (GPO). The article provides two methods, one involving blocking the Store and another without doing so
ADDS
Guide to Installing and Configuring an Enterprise Root Certificate
guide on how to install and configure a company’s root certificate. From setting up Active Directory Certificate Services to deploying the root certificate via GPO, this article covers all the essential steps to ensure secure certificate management in an enterprise environment.
ADDS
Installing RSAT Tools with PowerShell
A concise guide on how to view and install the Remote Server Administration Tools (RSAT) using PowerShell commands. The article provides commands to view available administration tools, install all RSAT tools, or install specific tools like Active Directory.
WDS
Setting Up PXE UEFI Booting with Windows Deployment Services
Learn how to install and configure Windows Deployment Services (WDS) for both Legacy BIOS and UEFI BIOS. Follow step-by-step instructions, including DHCP authorization, adding boot images, and enabling PXE boot for seamless deployment of operating systems. Ideal for labs or production environments, this guide covers known client integration, boot image storage, and DHCP server considerations
ADDS
Central Store and ADMX Update
Dive into the process of creating a central store to add supplementary ADMX files for GPO creation, ensuring accessibility for all administrators. This guide covers the steps to set up the central store in the SYSVOL directory, integrate third-party ADMX files, and update ADMX for Windows 11, all while ensuring seamless integration with the GPMC console.
Desktop Authority
Guide pour installer KACE Desktop Authority
Guide complet sur l’installation de KACE Desktop Authority. Découvrez les prérequis système, les ports nécessaires, les exceptions antivirus, les configurations SQL, et les étapes d’installation pour une mise en place réussie de Desktop Authority.
ADDS
Manage LAPS Configuration Using MSI
To set up LAPS on a domain controller, start by installing it with management tools and extend the AD schema using PowerShell commands. Set up a central store for ADMX files and create a GPO to manage local admin passwords. Give appropriate permissions for reading and resetting passwords in AD, and install LAPS on client computers using a GPO for automatic password backup in AD.