We have released the 16.0.3 patch which addresses a few enhancements and defects. We have fixed a number of issues in the Undo-Redo framework in...
Month: March 2015
ISE Auto-Completion Trick
PowerShell 3.0 ISE and later When you want to select the information returned by a cmdlet, you typically use Select-Object: Get-Process |...
Backup and Restore of Windows Azure SQL Databases
A growing number of companies have already moved some level of applications and data to the cloud. An equally growing number of companies are still...
Accessing Non-Microsoft LDAP Servers
All Versions There are free Active Directory cmdlets from Microsoft (part of the RSAT tools) and Dell (Quest). They take the complexity out of...
Finding Read-Only and Constant Variables
All PowerShell versions Some variables are protected and cannot be changed. To identify these, take a look at this line: Get-Variable | Where-Object...
Read-Only and Strongly Typed Variables
All PowerShell versions To make PowerShell scripts more robust, you can code a lot of requirements right into your script variables. When you do...
Your new job as a DBA
Are you a database administrator who just started a new job? Have you just taken administrator responsibilities for a new business unit’s databases?...
Using Constants
All PowerShell versions Variables in PowerShell are volatile. You can overwrite and delete them – unless you create constants. Constants can...
Including Resources with Your Scripts
PowerShell 3.0 and later If your script needs additional resources, like text lists of server names, or picture files, or anything else, then make...
Becoming a Top DBA – Learning Automation in SQL Server
Joseph D'Antoni, Microsoft MVP provides insight and examples from his experience as a consultant. The value you truly bring to your...
Aqua Data Studio 16.0 – Enhanced Charts, Dashboards and Database Support
Since our last release, we have been focused on building on our initial success with Visual Analytics and continuing to enhance our database support...
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...
PowerShell Essentials using SQL Server SMO
Reza KoohrangpourModerator Join our Geek Sync webcast on June 16th at 10:00am CST on the topic of “PowerShell Essentials using SQL Server SMO”. Our...
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 =...
Cybelesoft – Thinfinity Virtual UI for Delphi
Embarcadero Technology Partner Spotlight Cybelesoft - Thinfinity Virtual UI for Delphi Gustavo Ricardi - CYBELE SOFTWARE, INC. Friday, March 20,...
Monyog MySQL Monitor 6.26 Has Been Released
Changes (as compared to 6.25) include: Bug fixes: * When monitoring MySQL 5.6.3 and higher, Monyog reported false notification alert for...
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...
Aqua Data Studio 15.0.15 – Minor Fixes and Enhancements
We have released the 15.0.15 patch which includes several enhancements and addresses several defects. We've dramatically decreased the load...