Today Idera announces a set of three exciting new bundles in addition to its existing popular SQL Management Suite (formerly called SQL Suite)....
New SQL Suites available now!
read more
database-tools
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,...
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...
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...
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...
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...
Resurrection of SQL with Big Data and Hadoop
Did you really think that SQL was going away? Attend this session to learn how SQL is a vital part of the next generation of data environments. Find...
Using Arrays as Parameter Default Values
PowerShell 3.0 and later If you define a PowerShell function with some parameters, and you want a given parameter to have a default value that is an...
Overlapping Filter Application?
How do overlapping filters get handled by Compliance Manager. For example, I want a general filter that brings in anything from domainuser1 for all...
Shorten the Prompt
PowerShell 3.0 and later By default, PowerShell includes the current path into the prompt, and when you launch PowerShell as regular user, the...
Getting DELL Warranty Information (Part 2)
PowerShell Version 2.0 and later In a previous tip we illustrated how you can use a web service to retrieve warranty information for DELL computers....
The Future of ER/Studio: A Roadmap Outlook
Customers often ask us what we plan to do for future releases of ER/Studio. Many times we hold that information close, and only provide information...
Normalizing File Extensions
PowerShell 2.0 and later Let’s assume you want the user to submit a list of file extensions, or you are getting them from some other source....
Using the PowerShell ISE Debugger
PowerShell 3.0 and later Sometimes, it is hard to find out why a PowerShell script is not doing what it should do. To get a better understanding of...
The Top Productivity Solution for DBAs
Why has Monster Energy drink become standard operating equipment for DBAs? Join us for a hard-hitting look at the state-of-the-union for DBAs, what...
Using Code Regions in ISE
PowerShell 3.0 and later PowerShell ISE already supports collapsible code regions. When you write functions, loops, or conditions, you will notice a...
Process Killer (and some gotchas)
PowerShell 3.0 and later In a previous tip we explained how you can turn Out-GridView into a selection dialog, and suggested a couple of ideas. One...