People sometimes ask me why the avatar that I often use is Yogi Bear. Well, it’s because Yogi is famous for the phrase...
database-tools
Displaying Message Boxes
PowerShell can access all public .NET classes, so it is (fairly) easy to create a message box: $result = [System.Windows.MessageBox]::Show('Do...
Unique Features of ER/Studio Data Modeling Tool
Data modeling can be challenging for large enterprise architecture environments, but it provides the much-needed structure and context for an...
Using a Stopwatch to Profile Scripts
Ever wanted to find out how long a particular command or portion of your script took to complete? Here is a simple Stopwatch object that can help...
Color Week: Using Token Colors in the PowerShell Console
PowerShell 3 or better This week we are looking at how you can change coloring both in the PowerShell console and PowerShell ISE so you can fine...
Color Week: Changing Error Message Colors in the PowerShell ISE
This week we are looking at how you can change coloring both in the PowerShell console and PowerShell ISE so you can fine tune your PowerShell...
Color Week: Changing Error Message Colors
This week we are looking at how you can change coloring both in the PowerShell console and PowerShell ISE so you can fine tune your PowerShell...
The Art of Visibility: Enabling Multi-Platform Database Management
Scott Walz of IDERA joined Dr. Robin Bloor and Dez Blanchfield of The Bloor Group on the recent webinar, The Art of Visibility: Enabling...
Challenge Accepted
My life for the last 2 years has been a constant battle of putting out fires with system performance; finally user complaints have moved getting...
Color Week: Using Transparency in the PowerShell ISE Console
This week we are looking at how you can change coloring both in the PowerShell console and PowerShell ISE so you can fine tune your PowerShell...
product-oriented educational blog posts for Precise
Here is a list of product-oriented educational blog posts for Precise: Microsoft NET Code Evaluation Precise for Oracle Has Low Overhead, Impact...
product-oriented educational blog posts for SQL Safe Backup
Here is a list of product-oriented educational blog posts for SQL Safe Backup: A Short Introduction to the SQL Safe Command Line Interface (CLI)...
Color Week: Setting PowerShell ISE Background Color
This week we are looking at how you can change coloring both in the PowerShell console and PowerShell ISE so you can fine tune your PowerShell...
How Monyog helped CloudMagic detect an RDS issue within seconds
CloudMagic is an email app for iOS, Android and MacOS with over 4 million downloads. CloudMagic has catered to email users across the globe with...
Color Week: Using Clear Names for PowerShell ISE Colors
This week we are looking at how you can change coloring both in the PowerShell console and PowerShell ISE so you can fine tune your PowerShell...
Color Week: Setting PowerShell ISE Console Colors
PowerShell 3+ This week we are looking at how you can change coloring both in the PowerShell console and PowerShell ISE so you can fine tune your...
Saving PowerShell User Defaults
We are about to enter “Color Week” with plenty of tips how you can choose better colors for the PowerShell ISE editor and the console....
Finding ASCII Codes
Here is an easy way to find the ASCII code for any character you may have scraped from a website, or found in a script that you copied from the...
Checking Hard Drive Size (Local and Remote)
WMI can provide the raw data about hard drive size and free space. PowerShell then takes that information and provides user-friendly results like...
Enabling Remote Administration
PowerShell 2+ Many older DCOM-based commands require a “Remote Administration Firewall Exception” to access remote systems. This...
Finding Auto Starts
PowerShell 3+ If you’d like to know which programs start automatically on your machine, WMI may help: PS C:\> Get-CimInstance -ClassName...
Replacing CSV File Headers
PowerShell 2+ When you read in CSV data and would like to rename the CSV headers, here is a simple approach: just read in the text line by line, and...
Receiving Input via Pipeline
In the previous tip we illustrated how Convert-Umlaut was able to convert special characters in a string. This becomes even more useful if a...
The Role of DBA in Data Protection
IDERA recently released a Database Management Report Survey with interesting industry trends such as “nearly 90% of enterprise IT respondents...