Joseph D'Antoni, Microsoft MVP provides insight and examples from his experience as a consultant. The value you truly bring to your...
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
Using “more” in the PowerShell ISE
PowerShell ISE In the PowerShell console, you can pipe commands to the old-fashioned “more.com”, or better yet, to Out-Host...
Read User Profiles from Registry
All versions To find out which users have a (local) user profile on your machine, and where this profile is located, try this snippet: $path =...
Reading Associated File Extensions from Registry (Part 2)
All versions In a previous tip you learned how a one-liner can read multiple registry keys. In part 2, check out this one-liner: $lookup =...
ER/Studio MetaWizard Does The Magic!
Often times you would hear about moving objects from one Data Modeling platform to another for various reasons. Embarcadero's Meta-Wizard...
Reading Associated File Extensions from Registry
All versions PowerShell code can be extremely dense. Here is a one-liner that reads all associated file extensions from the Windows Registry:...
Sort Things with Type
All Versions Sort-Object is your one-stop solution for sorting. If it’s primitive data, simply pipe it to Sort-Object. If it is object data,...
Agent vs. Agentless Monitoring
With a unified IT monitoring solution like up.time one of the more popular discusses we have with users is agent versus agentless monitoring. In...
Opening Webpages from PowerShell
All versions Let’s assume you would like to open your favorite websites in a browser when you start your day. PowerShell can do this for you...
Service Broker Gone Wild: Dealing With sysxmitqueue Bloat
Have you ever been surprised by suddenly finding out that one of your databases has grown way beyond your expectations? Hopefully, this isn’t...
Measuring Website Response (and Execution Times)
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...
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,...
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...