PowerShell 3.0 and later Sometimes it is important to know just how long a command takes. For example, to monitor web site response times, you could...
Month: March 2015
Fresh update for ER / Studio Data Architect – 10.0.2
Licensees to ER / Studio 10.0 \ XE6 contract support can install a fresh update to the basic tool Data Architect. The new version 10.0.2 includes a...
Now available: Data Architect 10.0.2
We are pleased to let you know that a minor point release for Data Architect 10.0 is now available! Version 10.0.2 contains a few enhancements from...
New SQL Suites available now!
Today Idera announces a set of three exciting new bundles in addition to its existing popular SQL Management Suite (formerly called SQL Suite)....
Unfolding Object Data Structure
PowerShell 3.0 and later Objects can contain nested properties, and the data you are after may be “somewhere” inside an object. To...
Suppress Confirmation
All PowerShell Versions Some cmdlets (like Remove-ADGroupMember) automatically ask for confirmation. This can be a problem in scripts running...
Team DBA and Collaboration
In previous blog posts I have explored the relevance of the DBA position itself in business and the unique ways that SQL Server DBAs tend to...
Embrace the Future of Data Architecture: Make the Switch to ER/Studio
Sometimes you need to face the inevitable: the tool selected years ago is not the one you need for the future. Have you been struggling with...
Getting Cmdlet Help No Matter What
PowerShell 3.0 and later Beginning in PowerShell 3.0 PowerShell no longer ships its help files. Instead, you need to download them via Update-Help,...
Geek Out with Idera and SQL Experts
You spoke and we listened! You, the voracious members of the SQL community have been saying you want more educational opportunities to take you...
Examining Wi-Fi Adapters and Power Management
Windows 8.1/Server 2012 R2 Windows 8.1 and Server 2012 R2 come with a bunch of highly useful cmdlets for network adapter management. When you want...
Converting A List of Identifiers into SQL Statements
If I had a nickel for every time someone gave me a list of identifiers and asked me to pull a result set for them I would be a very wealthy man....
Using Finally for Crucial Cleanup Tasks
PowerShell 2.0 and later In a previous tip we introduced an “acoustic progress bar” that made PowerShell play a sound for as long as it...
Automating PowerShell ISE
PowerShell 3.0 and later PowerShell ISE is completely scriptable and is accessible through the $psISE variable. This variable is present only within...
Webcast with Andy Warren, "How to deal with an inherited SQL Server"
Join our next webcast on March 11, 2015 in the Geek Sync series. Our speaker, Andy Warren, SQL MVP, will walk you through a set of Week 1 Best...
Integrating Data from Multiple Sources: Making Sense of Conformable Data – by David Loshin, Knowledge Integrity
This is the third post in this series. Read the previous post. In my last post, the discussion focused on the ability to infer metadata about...
Working with StylesData in your FireUI applications
I have been getting some questions recently on how to identify and access style elements using StylesData. StylesData is defined by the style and...
Finding Process Owner
PowerShell Version 3 or better Get-Process gets you a list of all running processes, but it will not reveal the process owner. To find the process...
SQL Enterprise Job Manager 1.1 Released
We are pleased to announce the general availability of SQL Enterprise Job Manager 1.1. Existing users can upgrade to this version through the Idera...
Using JSON-based Web Services
PowerShell 3 and better There are plenty of information web services out in the Internet, and many of them return results in JSON format. Here is an...