Create local user using powershell script

 First of all, prepare the user list as below and save it as users.csv file

username, user, description, password user1, user1, this is user1, password1 user2, user2, this is user2, password2

Create a powershell script with the following code

$localUsers = Import-csv C:\scripts\users.csv foreach( $user in $localUsers) { $Secure_String_Pwd = ConvertTo-SecureString $user.password -AsPlainText -Force New-LocalUser $user.username -Password $Secure_String_Pwd -FullName $user.user -Description $user.description Set-LocalUser -Name $user.username -PasswordNeverExpires:$true Add-LocalGroupMember -Group "Administrators" -Member $user.username }

The scripts will first need to convert the password string from the csv file into a secureString. This is necessary for New-LocalUser cmdlet. After that, the script will set PasswordNeverExpires option as well as add those user into Administrators group.

I am using this script for my test setup which need a lot of dummy users. For production environment, you can actually create random password instead of specifying password in the users.csv file and set the "-ChangePasswordAtLogon $true" option. And obviously, you can also change the User group to "Users" group instead of "Administrators" group.

PowerShell to check MSSQL database status

A very simple Powershell script to check database status.

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null
$s = New-Object ('Microsoft.SqlServer.Management.Smo.Server') ServerName
$db = $s.Databases.item("databaseName")
"status: " + $db.status + " isaccessible: " + $db.isaccessible

Example output:
Database status is normal

status: Normal isaccessible: True

This output is created by renaming the log file.

status: RecoveryPending isaccessible: False

For more status description, please refer to this Microsoft site.