database-tools Archives

How Do You Collaborate on Enterprise Data?

As enterprise data environments become more complex, the need for full understanding of what the data means becomes more apparent. When you’re...

Unzipping ZIP Files with any PowerShell Version

by ps1

If you do not have PowerShell 5.0 and .NET Framework 4.5 is not available, here is an approach to unzip ZIP files that uses the native Windows shell...

Monitoring High Availability on Galera Clusters for MySQL using Monyog

by whateverTJ

For every online business, there are millions of transactions happening every second including crucial revenue bearing transactions. Therefore...

Unzipping ZIP Files with PowerShell 3.0 and 4.0

by ps1

ZIP file support was introduced in PowerShell 5.0, but if you have installed the .NET Framework 4.5 and possibly want more control over the...

Unzipping ZIP Files

by ps1

In PowerShell 5.0, there is a new cmdlet that can unzip ZIP files: #requires -Version 5 $Source = 'C:\somezipfile.zip' $Destination =...

Finding Computers with PowerShell Remoting

by ps1

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

by ps1

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

by Embarcadero USA

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

by Embarcadero USA

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

by whateverTJ

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

by ps1

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

by ps1

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

by ps1

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

by ps1

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

by ps1

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

by ps1

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

by ps1

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

by ps1

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