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…

How to move the SQL tempDB database files

Open SSMS (If you don’t know what is SSMS, you shouldn’t be doing this…) Paste and execute this query, modifying it to your needs

Restart the MS SQLSERVER Services. A new tempDB data and log files will be created in the newly specified location. You can deleted the original ones. Do not forget, you…