Background jobs can be a great thing to speed up scripts because they can do things in parallel. However, background jobs only work well if the code...
Month: June 2014
Understanding the statement "exit"
PowerShell supports the keyword "exit" which is a scope-based. It may work much differently than you assumed it would. Let's take a...
Using break, continue, and return
There are two special keywords in PowerShell that you can use in loops: break and continue. With continue, the loop continues but skips the...
Time for an Upgrade?
I don’t know about you, but deciding when to pull the trigger on an upgrade is not that easy for me. What is to be upgraded usually doesn’t...
Webinar – Monitoring MySQL and MariaDB databases with Monyog. Register now
Monitoring MySQL and MariaDB databases without a powerful tool like Monyog can be challenging. However, if you already use Monyog you might not be...
Monyog MySQL Monitor 6.1 Has Been Released
Important note: With this release we have changed registration keys. The new key is available for registered users from our Customer Portal. Please...
Dealing with Environment Variables
To read a Windows environment variable in PowerShell, simply use the prefix "env:": PS> $env:windirC:\WindowsPS> $env:USERNAMETobias...
Aqua Data Studio 14.0.17 – Minor Fixes and Enhancements
We have released the 14.0.17 patch which addresses a few defects and includes a few enhancements. Patch: dd1.aquafold.com/.../ads-14.0.17-patch.zip...
Using Nested Hash Tables
Nested hash tables can be a great alternative to multidimensional arrays. They can be used to store data sets in an easy-to-manage way. Have a look:...
Speeding Up Arrays
When you assign new items to an array often, you may experience a performance problem. Here is a sample that illustrates how you should not do it:...
Welcome to the Idera Azure SQL Database Backup forum
June 23, 2014 at 8:24 pm #815 Vicky HarpKeymaster Welcome to the Idera Azure SQL Database Backup forum. Please feel free to post your questions,...
Uploading images to the cloud with BaaS in RAD Studio XE6
In Delphi, C++Builder and RAD Studio XE6, we integrate with leading Backend as a Service (BaaS) providers to add functionality and platform services...
Using Event Logs Instead of Log Files
Often, people use file-based logging. There is nothing wrong about that, but using the built-in event log system provided by Windows may be much...
Reading Registry Values the Easy Way
With PowerShell, it can be a piece of cake to read out Registry values. Here is your simple code template: $RegPath =...
Webcast: Edge Case Testing for the Database Professional
UPDATE: Slides are available here. This Thursday at 11 AM CDT, I will be presenting an educational SQL Server webcast entitled “Edge Case...
Handling Cmdlet Errors without Interruption
When you want to use error handlers with errors that occur inside a cmdlet, then you can only catch such exceptions when you set the -ErrorAction of...
Fun with Path Names
You can use the -split operator to easily split a path in its components. The result is always an array. Simply use comparison operators to exclude...
Get Better Integration with SCOM using SQLdm SCOM Management Pack
It’s an age old problem in IT, one IT department has one standard and tools they use to manage their systems. Another IT department has another...
Aqua Data Studio 14.0.16 – Minor Fixes and Enhancements
We have released the 14.0.16 patch which addresses a few defects and includes a few enhancements. Patch: dd1.aquafold.com/.../ads-14.0.16-patch.zip...
Survey: Idera’s new SQL Server job management solution
We are currently working on a new SQL Server agent job monitoring and management tool, to become available later this year. This first release will...
Skipping Profile on Keystroke
Maybe you'd like to be able to occasionally skip certain parts of your profile script. For example, in the ISE editor, simply add this...
Using Profile Scripts
You probably know that PowerShell supports profile scripts. Simply make sure the file found in $profile exists. It's a plain script that gets...
SQL Compliance Manager v 4.5 Beta
We are pleased to announce that SQL Compliance Manager 4.5 will soon be available for beta testing. Please note that this is pre-release code and...
Monyog MySQL Monitor 6.02 Has Been Released
Changes (as compared to Monyog MySQL Monitor 6.01) include: Bug fixes: * CSV exports from Query Analyzer did not include the 'Db' (database)...