In PowerShell 5.0, there is a new cmdlet that can unzip ZIP files: #requires -Version 5 $Source = 'C:\somezipfile.zip' $Destination =...
database-tools
Finding Computers with PowerShell Remoting
In a previous tip we showed how you can test the network port of a computer. When you have installed the free RSAT tools from Microsoft, you could...
Testing a Network Port
To see whether you can access a remote computer via a given network port, here is a test function called Test-Port; it takes a remote computer name...
Working with DBArtisan’s Performance Analyst
In this video, Scott Walz covers DBArtisan's Performance Analyst, a cross-platform real time performance tool. Try DBArtisan free See more DBA...
Enabling Enterprise Agility Through Model-Driven Data Design
There is a growing need to integrate diverse databases with each other and with new data sources. This is accomplished through integration of data...
Introducing actionable charts in Monyog MySQL Monitor
While Monyog MySQL Monitor is being embraced by DBAs and DevOps around the world, we are constantly adding more features to make MONyog the most...
Finding Logged On Users
In a previous tip we explained how you find the physically logged on user. In this tip you will see how you can list the current logon sessions,...
Find Physically Logged On User
There can always be only one physically logged on user on a machine. The physically logged on user is the one sitting right at the machine. Here is...
Accessing an SQL Database with a Connection String
In a previous tip we explained how you can construct the connection string to a SQL database. Whether you use this to create the connection string,...
Getting SQL Server Connection String
If you’d like to contact an SQL Server database via PowerShell, you need a connection string. The connection string contains all pieces of...
Updating Your Office Phone Number in Active Directory
If you have installed the free RSAT tools from Microsoft, you can use PowerShell to update information stored in your AD user account, for example...
Adding Custom Attributes to AD Objects
If you’d like to add custom attributes to an AD object, simply use a hash table, and add the desired attribute names and their values. Then...
Cloning Active Directory Security Settings
Whenever you add delegation rights to an AD object (i.e. allow a user to manage the members of an organizational unit), you really invoke a change...
Get Command History as File
The built-in PowerShell ISE editor that ships with PowerShell 3.0 or better can be customized, and you can add your own menu items. When you run the...
Creating and Identifying Deadlocks in SQL Server
This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health...
Simple AD Group Management
Provided you have downloaded and installed Microsoft’s free RSAT tools, managing AD groups and group members is very simple. Here are some...
Using PowerShell Help
To access the full PowerShell help, you first need to download help information from the Internet. Simply launch a PowerShell console with full...
Top 4 Ways to Intelligently Automate DBA Activities
Being a DBA is one of the most challenging job. Why do you think we are saying so? Think of a normal situation, I have seen developers say this is...
Tips of the Week for SQL Server DBAs
Here are 10 quick SQL Server tips and tricks for DBAs compiled by SQL Server expert Pinal Dave. RAISERROR in the format RAISERROR integer...
Setting AD Account Expiration Date
To safely use temporary AD accounts, for example for guests or consultants, always make sure to set an expiration date. Here is some sample code...
Bulk-Remove Protection for Accidental Deletion in AD
By default, AD objects are protected from accidental deletion. To remove this protection for all objects in a given scope (i.e. all objects in an...
First Steps Automating AD
When you download the free RSAT tools from Microsoft, these include the ActiveDirectory module. It contains a rich set of cmdlets to manage Active...
Changing Local Administrator Account Password
To access local user accounts and assign a new password, you can use the low-level WinNT: namespace. Note: you do need Administrator privileges to...
Encrypting Text
There are many ways to encrypt text. Here is an approach that does not use an explicit “secret”. Instead, the secret is defined as your...