Welcome to our new blog series, Improving the Daily Life of a Database Developer. This series will examine several of the most common database...
database-tools
Adding Numbers to a String (Part 2)
In the previous tip we illustrated a number of ways how to safely add variables to string content. Adding variables to double-quoted text can expose...
Adding Numbers to a String (Part 1)
Double-quoted strings can easily expand variables, however this concept is not foolproof: $id = 123 # this is the desired output: # Number is 123: #...
Build your Queries Fast with the Query Builder
Howdy, folks! Welcome to another fun-filled blog post on Aqua Data Studio. Let's face it, building queries may not be everyone's cup of...
Get-PSCallStack and Debugging
In the previous tip we have used Get-PSCallStack to determine the “nest level” of code. Let’s today take a look at how this cmdlet...
Amazon Redshift Magic with Aqua Data Studio
Howdy! Welcome to another blog post on Aqua Data Studio! This time we will diving into the wonderful world of Amazon Redshift!...
Aqua Data Studio – Working with Complex Data Environments Can Be A Challenge.
Companies are expanding their systems beyond relational databases to incorporate big data and cloud deployments, creating hybrid configurations....
Why should you learn about DevOps?
DevOps integrates software development and IT operations into a single continuous process that delivers significant benefits to common business...
Discovering Nesting Level
Get-PSCallStack returns a so-called “Call Stack” which – in its simplest form – tells you the nesting depth of your code:...
Aqua Data Studio – From Database to Excel to Data Source – A Primer
Howdy! Welcome to a series of blogs on Aqua Data Studio - The leading universal database IDE and productivity tool on the planet! In this quick...
IDERA Live 2019! Free Virtual Conference
Join us for our third-annual IDERA Live Virtual Conference designed to educate and inform users of any level in a fun, engaging atmosphere....
Super Simple Random Password Generator
Here is a super simple approach to create random passwords. The approach makes sure no ambiguous characters are used but does not care about other...
Announcing Precise 10.0 General Availability
We are pleased to announce the release of Precise 10.0, the company’s application performance monitoring platform. This latest release...
Preferring WLAN Connections
When you are connected both to a LAN and a WLAN, and would like to prefer one network over the other, you can adjust the network metric. The lower...
Adding Personal PowerShell Commands to the Context Menu
You can add personal context menu commands for file types like PowerShell files. These context menu commands appear when you right-click a .ps1...
Locking the Screen with PowerShell
Here is a PowerShell function called Lock-Screen that can lock the screen and prohibit user interaction. There can be a custom message, and the...
Blocking User Input
If a PowerShell script needs to perform critical steps, and user interaction must be prohibited, you can use API calls to temporarily disable all...
The Impact of Cloud on DBA
The DBA is the information technology professional responsible for ensuring the ongoing operational functionality and efficiency of an...
Passing Arguments to Encoded Commands
Encoding PowerShell code is a great way to run PowerShell code outside the PowerShell environment, i.e. in batch files. Here is some sample code...
Database Backup & Restore – Free Resources
World Backup Day This year, World Backup Day was on Sunday, March 31, 2019. Per my blog post from two years ago “Guidelines for Backup and Recovery...
Deleting Registry Keys that can’t be Deleted
Deleting registry keys is typically trivial and can be done with Remove-Item. However, every once in a while, you may come across registry keys that...
DB PowerStudio 17.0.3 General Availability
We’re excited to announce the general availability of DB PowerStudio 17.0.3. Existing users may upgrade to this version through the Idera...
Repairing PowerShell Context Menus
When you right-click a PowerShell script in File Explorer, you typically find a context menu entry called “Run with PowerShell” which...
Launching PowerShell Scripts for Dummies
Assume you want to hand a PowerShell script to an unexperienced user. How can you reliably get that person to correctly launch your script file?...