When you override the ToString() method of an object you control how this object is displayed. The object content stays untouched, though: $a = 123...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Adding Additional Information to Objects
When you retrieve results, you may want to add additional properties to the results so later you know where they came from. Attaching additional...
Appending Extra Information to Primitive Data Types
Maybe you'd like to tag a variable and provide some extra information. In PowerShell, use Add-Member and attach NoteProperties or ScriptProperties...
Simple Replacement for INI Files
If you'd like to keep settings outside of your script and store them in a separate config file, then you can use all kinds of data formats for...
Remove Array Elements
Did you ever need to compare two arrays? Compare-Object might help. Check this out: $array1 = 1..100 $array2 = 2,4,80,98 Compare-Object...
Quickly Getting IP Addresses
You want to quickly get a list of IP addresses for your own computer or a network machine? Here is how: #requires -Version 3 $ComputerName =...
Shortening Text
Let's assume you want to chop off some text at the end of a string. This is the traditional approach using string operations: $text = "Some...
The Hidden Elephant in ‘Big Data’ Modeling – by Len Silverston
The Elephant “We must understand the data and therefore continue to develop data models, even in this 'Big Data' era." exclaimed the data warehouse...
Avoid Using Redirection
While you can still use the old redirection operator to write command output to a file, you should rather use PowerShell cmdlets instead. Here is...
Breaking Down Business Barriers with Enterprise Architecture – Slide Presentation
Below is the slide presentation from our recent webinar Breaking Down Business Barriers with Enterprise Architecture. See the companion webinar at:...
Encode PowerShell Commands
When you need to run code as a PowerShell command in a separate powershell.exe, it is not always safe to submit the code. Depending on from where...
Define Multiline Text
When you need to define multiline text, in PowerShell you typically use here-strings like this: $text = @" I am safe here I can even use...
Current Script Path
In PowerShell 1.0 and 2.0, you needed a lot of weird code to find out the current script location: # make sure the script is saved and NOT...
Discovering Dynamic Parameters
In a previous tip we showed how you find cmdlets that expose dynamic parameters. Let's explore what the dynamic parameters are. The function...
Finding Cmdlets with Dynamic Parameters
Some cmdlets expose dynamic parameters. They are valid only in certain contexts. Get-ChildItem, for example, exposes -File and -Directory only when...
Change ISE Zoom Level
The PowerShell ISE sports a zoom slider at its lower right edge, and you can control this slider with PowerShell code. So you could set defaults for...
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
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
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
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
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
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...