JohnyLuky has written 54 articles

Cleanup Windows Update Corrupted Database Error 80073712

Here is what you do when you get the famous “(80073712)” error while trying to apply Windows Updates. Open a command prompt with Run As Administrator and run those commands one by one. You can also paste them all into a batch file, and run it with Administrator privileges;

 

Create a new user on Debian based Linux distro

Very straight forward, create a user, a home folder, assign permissions to it, you’re done ! This create a simple user, with no particular rights.

Anyone wants to pitch in to add a bit more to this ? Add more rights to the users for specific function ? Leave a comment and I’ll gladly…

PowerShell Get Memory used by a group of processes

Get the memory usage of a process, grouped, so you get the total. Example; chrome, always have one process per page, use this to get the total of memory used by all of them.

From Laurent’s comments below, another take on this with the following code, which lists all open processes, with total memory:…

SQL Check Index Fragmentation

Thanks to Ola Hallengren, here is a simple scrip to report the fragmentation level of you database’s index One thing to note, if you don’t see any results after running this, you may have no index larger then 1000 pages, or no fragmentation at all ! Lucky you !

SQL Index Maintenance Script

Small simple scrip to automate SQL Index maintenance. Of course, the best scripts to accomplish this is Ola Hallengren’s SQL Server Maintenance Solution, that you can find here But if you want quick and simple, here it is;

PowerShell Message Tracking in Exchange

Ever wanted to track some messages in Exchange ? Here is a neet trick to will help you track messages quickly. A lot more options are available, of course, this is only a small one liner to verify if a user received an email, from someone, on a particular date.

  See all available…

PowerShell Send Email in one line command

Powerful one liner to send an email with PowerShell.  Useful in scheduled tasks to send status, or additional info. The use of environment variables is totally optional, but make a fine subject line when you want to know from which server it came from ! Suggestions on improvements are welcome, please leave a comment !…

Duplicate Active Directory Group with Members from PowerShell

Fireup your PowerShell ISE, modify to your needs, and run ! Please leave comments, suggestions below !

Get FSMO Roles in domain with Powershell

First, fire up a PowerShell windows with the Active Directory module. If you have the Admins tools installed, it should be called “Active Directory Module for Windows PowerShell” If you don’t have the admin tools install, you must install them, or log on a server that has them, like a Domain Controler. If you do…