Happy SysAdmin Day 2017

cropped SysAdminDay Header Logo1 - Happy SysAdmin Day 2017

Feeling lucky today…because I am a sysadmin and I have a day to be appreciated for what I do. That day is today, last Friday in every July. And it’s called System Administrator Appreciation Day, aka Sysadmin Day. Don’t be jealous, having a dedicated day to be appreciated could also mean we sysadmins get no respect the rest of the […]

Counting the Number of AD User Accounts in PowerShell

powershell cim 1 - Counting the Number of AD User Accounts in PowerShell

Here are some PowerShell examples that we can use to count the numbers of user accounts in Active Directory. Total number of user accounts in AD

Total number of user accounts in an OU

Replace the SearchBase with your own OU path. Total number of enabled/disabled accounts in AD

Total number of user accounts in a Group […]

Stack Overflow Public Database Available (2017-06)

qHF2K - Stack Overflow Public Database Available (2017-06)

Need a huge SQL database for your data project? Here is one for you. Nick Craver and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and more. It’s available as an XML data dump. Then, Brent Ozar took the data and imported into SQL Server for his teaching performance tuning needs, and generously published it […]

Rules to Choose a Secure Strong Password

How Secure Is My Password  - Rules to Choose a Secure Strong Password

The age-old password rules have changed dramatically over the years and are barely relevant in the modern days, many thanks to the hackers that keep their weapon sharpened when it comes to cracking passwords. Here are a few good readings and materials that summarize very well how to choose a good, strong and secure password in the modern world. How […]

Download Performance Tuning Guideline for Windows Server 2016

Windows Server 2016 - Download Performance Tuning Guideline for Windows Server 2016

Via Windows Server Blog, This updated guide provides a comprehensive collection of technical articles with practical guidance for IT professionals and server administrators responsible for monitoring and tuning Windows Server 2016 across the most common server workloads and scenarios. With this guidance, administrators can tune server settings in Windows Server 2016 and achieve incremental performance or energy efficiency gains, especially […]