To create or change an environment variable in the user context, use this low-level call: [environment]::SetEnvironmentVariable('Test',...
database-tools
Using Wildcards with Environment Variables
You can use the env: PowerShell drive to list all Windows environment variables like this: PS> Dir env:*user* Name Value ---- ----- USERNAME...
Creating PowerShell Menus
PowerShell is console based, so its default menus are console based as well. To offer choices to your users, here is some sample code to create a...
Scanning Registry for ClassIDs
The Windows Registry is a repository filled with various Windows settings. Get-ItemProperty can read Registry values and accepts wildcards. So, with...
Bypassing Execution Policy
When execution policy prevents execution of PowerShell scripts, you can still execute them. There is a secret parameter called "-" . When you use...
Why does selecting a file in the filechooser on OSX not select the file extension with the full file name?
I run the Import Tool, and click browse to select a file to import. When I select one of my files, which has a .CSV extension, the full file name is...
I get the warning “Server returned invalid line number (0)” when debugging a Sybase procedure, am I doing something wrong?
I am not sure why I am getting the warning "Server returned invalid line number (0)" when debugging Sybase stored procedures. Response Niels Gron...
Why are certains operations of Aqua Data Studio very slow with MySQL?
I have a server registration to MySQL and other databases. When I execute queries in the Query Window for MySQL they are fast. But If I try to...
Why isn’t there a Procedure Editor for MySQL like there is for the other database vendors?
I can right mouse click on a procedure in Oracle, DB2 and SQL Server and choose the "Edit in Procedure Editor", but in MySQL this option doesn't...
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. What do I do?
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. Response Jonathan Powers over 11 years ago Unstable...
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another?
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another? Response Jonathan Powers over 11 years...
Scripts with multiple statements return errors. Some database commands or symbols do not work in Aqua Data Studio while they do work in the database vendor’s command line tool.
Scripts with multiple statements return errors. Some database commands or symbols (such as “;”) do not work in Aqua Data Studio while they do work...
Aqua Data Studio is running out of memory. How do I increase it?
Aqua Data Studio is running out of memory. How do I increase it? Response Jonathan Powers over 11 years ago Memory Allocation in Aqua Data Studio If...
Aqua Data Studio gets disconnected after a certain period of time.
Aqua Data Studio gets disconnected after a certain period of time. Response Tariq Rahiman over 11 years ago Timeouts: ADS periodically gets...
How do I connect to PostgreSQL using SSL and my personally created certificate
I want to connect to my PostgreSQL server using SSL. I've created a certificate on my PostgreSQL server, but I can't configure Aqua Data Studio to...
Controlling Automatic Updates Installation Time
To find out when Automatic Updates wakes your PC to install new updates, here is a script that will retrieve that information: $updateObj =...
Controlling Automatic Updates
To control whether Windows download and/or installs updates silently or prompts for permission, use this script and set the appropriate...
How do I connect to Teradata with LDAP?
How do I connect to Teradata with LDAP authentication using Aqua Data Studio? Response Niels Gron over 11 years ago The authentication mechanism for...
Retrieve Yesterday’s Error Events
To retrieve all error events from a system log that occurred yesterday, here is how to calculate the start and stop times: PS> $end = Get-Date...
Creating Intelligent Variables
To create variables that calculate their content each time they are accessed, use access-triggered variable breakpoints. This line, for example,...
Setting Breakpoints in PowerShell Scripts
Most sophisticated PowerShell editors have built-in debugging support. PowerShell can handle breakpoints natively, too, though. To make PowerShell...
PowerShell Script Security Auditing
When you digitally sign scripts, you can easily tell whether a script was manipulated or comes from an untrusted source. Here is a function that can...
Re-Encoding ISE-Scripts
When you save scripts with the PowerShell ISE script editor, they are saved with the rather unusual "Big Endian Unicode" encoding....
Digitally Signing PowerShell Scripts
In a previous tip, we illustrated how you access a code signing certificate that was installed on your computer. With such a certificate, you can...