If you need to parse a date or time information out of raw text, and if the date and time format does not adhere to the standards of your operating...
database-tools
Faster Array Manipulations
The "+=" operator is pretty convenient and can add new elements to an array. If you need this more than once, for example in a loop, then...
ER/Studio Model Repository Database Sizing Guide for Oracle
Howdy! In a previous article, I showcased on how to implement table statistics and Index Re-orgs in SQL Server for the Model Repository. In...
Copy Command History to a Script
Sometimes you may have played around with the interactive PowerShell and suddenly realized that some of the commands you played with were pretty...
IDERA ER/Studio Repository Database Sizing Guide SQL Server Edition – Best Practices
IDERA ER/Studio Database Sizing Guide – Best Practices Howdy! In this blog post, let us shed some light on how to better leverage Capacity...
March #SQLChat Wrap-Up
Our March #SQLChat took place Wednesday, March 9 at 11 AM CT. This Twitter Chat was hosted by both John Sterrett and Robert Vandervoort and was...
Compare Versions
Ever wanted to compare software versions? If you do it like this, the result is off: PS> '3.12.11.100' -gt '11.1.22.91' True...
Cleverly Aborting Endless Loop
In a previous tip you have seen how an endless loop can be used to continuously monitor things - until PowerShell is closed, or a user presses...
Finding Executable Path
Here is a one liner telling you the exact location of the executable of any running process. The example returns the path to the PowerShell...
Analysis Services: Solving Hierarchy Errors of Uniqueness
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group...
Thinking Strategically about SQL Server on Linux
People all over the database world were in for a stunner this week when Microsoft announced that they will be supporting SQL Server installations...
Doing Things Forever
If you want PowerShell to run forever, for example in order to continuously ping a site, use a simple endless loop: #requires -Version 2...
Switching Keyboard Layout with PowerShell
Next time you find yourself with a PowerShell console that uses the wrong keyboard layout, keep your fingers off the mouse! Do it with PowerShell...
New Query Analysis Features in Monyog
While looking to optimize your MySQL, you are needing to spot slow/bad queries at a glance and get deep insights about them with ease. The latest...
Getting Basic Networking Information
Beginning with Windows 8.1 and Server 2012 R2, the operating system adds a wealth of new cmdlets for OS management. With these cmdlets, it is almost...
Investigating AD Classes
Active Directory organizes its content in classes like "user" or "computer". Each class has a predefined set of attributes, like...
Use Ctrl+Space in ISE!
The PowerShell ISE opens IntelliSense menus frequenty and helps you write code. Sometimes, however, IntelliSense does not pop up automatically,...
PowerShell Killing Itself
If you schedule a script as a scheduled task, or call it externally, and want to make sure the PowerShell process really ends, here is a brute force...
Converting Arrays to Strings in CSV Exports
When you export objects to CSV--for example to display them in Excel--arrays won't be output correctly. Here is a simple way that converts...
Exploring PowerShell Automatic Variables
Here is an easy way to get a list of all currently defined variables, their values, and their purpose. #requires -Version 2 Get-Variable |...
Invoking Code Repeatedly
Sometimes you might want to run some command multiple times until it runs successfully. Here is a function that shows a way to do this: #requires...
Saving Persistent Data
Sometimes a script needs to save information in a persistent way. Maybe you have a list of computers that you'd want to contact, but only some...
March #SQLChat – “DBAs Role in Data Modeling”
We are excited to welcome the data modeling audience into IDERA! And to prove it, we are hosting a #SQLChat! IDERA’s next Twitter Chat will be held...
Use WMI the Modern Way!
WMI is a powerful technique to find out information about local or remote computers, and you may have used Get-WmiObject before to do so (if not,...