Archives : November-2014

This procedure will work many version of Ubuntu. I personally tested this on all Ubuntu versions from 12 and up, and should also work fine, or be a very good indicator of what to do, on any Debian based Linux distribution. Like many OS out there, right after installation, everything is configured to use DHCP. ..

Read more

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. useradd johnyluky passwd johnyluky mkdir /home/johnyluky chown johnyluky:users /home/johnyluky Anyone wants to pitch in to add a bit more to this ? Add more rights to the users for specific ..

Read more

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. $Processes = get-process chrome,iexplore | Group-Object -Property ProcessName foreach($Process in $Processes) { $Obj = New-Object psobject $Obj | Add-Member -MemberType NoteProperty ..

Read more

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 ! DECLARE @DatabaseID int SET @DatabaseID = ..

Read more

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; DECLARE @IndexName varchar(255) DECLARE @TableName varchar(255) DECLARE @Frag float DECLARE @FragCount as int DECLARE @DbName as varchar(255) ..

Read more

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 ! ..

Read more

Fireup your PowerShell ISE, modify to your needs, and run ! Please leave comments, suggestions below ! Import-Module ActiveDirectory # Determine the base OU $Path = ‘OU=Accounting,OU=-Department,OU=Office,DC=MyDomain,DC=net’ # Determine the new path where the groups will be created. Can be different or the same. $NewPath = ‘OU=HR,OU=-Department,OU=Office,DC=MyDomain,DC=net’ # Get all security groups to duplicate. You ..

Read more

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 USE master GO ALTER DATABASE TempDB MODIFY FILE (NAME = tempdev, FILENAME = ‘d:\data\tempdb.mdf’) GO ALTER DATABASE TempDB MODIFY FILE (NAME = templog, FILENAME = ‘e:\logs\templog.ldf’) GO Restart the MS SQLSERVER ..

Read more