Featured Blog
Empowering Law Firms: How SQL Server and Idera Tools Safeguard Legal Data
Creating an Overflow Menu on Android
During my CodeRage 8 session I talked about creating an Action Bar with an Overflow menu, so I wanted to provide some step-by-step instructions. On...
How to load custom styles at runtime
During my session at CodeRage, I briefly talked about how to load custom styles at runtime. I wanted to elaborate on this topic and provide some...
Bridging the NoSQL, Cloud and Big Data gap with Studio 14!
With increasing adoption of NoSQL, Cloud and Big Data databases, we have released our new 14.0 version of Aqua Data Studio with full support for...
Mobile app lifecycle events handling in Delphi XE5
The lifecycle of a mobile app is more complex and different from a desktop app. On a mobile device an application runs either in the foreground or...
Are you asking about app size? (by Delphi for Android)
You're asking about app size? Not a news. Since Delphi 1 people're asking "why Windows calculator is 33 kb, while Delphi version of...
Playing Audio Clips on Android
I have been working with our R&D team on the samples and snippets for RAD Studio XE5. Our mobile snippets are designed to showcase key...
Manipulating File System Paths (Part 3)
In previous tips we illustrated how you can turn file system paths into arrays and then create new paths by changing or excluding parts of the...
Manipulating File System Paths (Part 2)
When you turn a path into an array to manipulate parts of the path, if you access path elements by fixed index numbers, then this approach will only...
Manipulating File System Paths
PowerShell lets you access multiple array elements. With the help of -split and -join, you can easily manipulate file system paths this way. To...
Writing DWORD-Values to Registry
In PowerShell 2.0, Set-ItemProperty by default always creates REG_SZ (String) values. PowerShell 3.0 is smarter. When you submit a numeric value,...
Importing Website Tables into Excel
Sometimes, you might see interesting information on websites. For example, navigating to http://www.ssa.gov/OACT/babynames/index.html will open a...
Negating Variables
Let's assume you have a variable with a negative value, and you'd like to make it a positive value. Here's a simple way: Basically, this...
Determining Registry Value Data Type
PowerShell can read and write Registry keys and values easily, but there is no a built-in way to check the data type of a given value. To find out...
Creating Colorized Excel Output (Part 2)
In a previous tip, we illustrated how you can feed HTML data to Excel in order to create formatted Excel sheets. Today, we'll show you an easy...
Creating Readable CSV-and HTML-Output
When you convert PowerShell results to CSV or HTML output, you may have discovered that some properties don't display correctly. PowerShell...
Creating Colorized Excel Output
PowerShell can send data to Excel using CSV files easily. Here's a short script creating a list of running services and opening it in Excel...
Finding Unused Drive Letter
Here's a simple way of finding unassigned drive letters: If you just want any unused drive letter, pipe the result to Get-Random. This approach...
Using Bitwise Shift Operators
PowerShell 3.0 introduces two new operators to bitwise shift. You can use these, for example, to convert GB to MB or KB to GB: -shr 10 basically...
Preventing Debugging (Part 2)
In a previous tip we explained how you can tell PowerShell not to debug certain functions by adding a special attribute: function test {...
Adding Suggestions to PowerShell Console
Suggestions are little pieces of text that can appear next to a PowerShell error message to better explain what went wrong. Suggestions only work in...
Printing from an Android device using FireMonkey
Printing from an Android device requires a little bit more setup than in iOS where you simply connect to an AirPrint capable printer (like my Epson...
Examining Certificates
Here's how you can pick a certificate from your certificate store. This line will return certificates that have "Tobias" in the...
Removing Certificate Plus Private Key
Starting with PowerShell 3.0, the certificate provider has become a lot more powerful. It can now easily delete certificates plus their associated...
Preventing Flashing Console Window
When you run a console command inside a non-console PowerShell host (like the ISE editor), there will be a flashing window, indicating that the host...
Changing Current Time Zone
In a previous tip you learned how PowerShell can list all available time zone IDs. Today, we show you how to set the time zone using the utility...
Get Time Zone Info
There is a little known utility called tzutil.exe which can both set the current time zone and get all available time zones. Today, let's check...
Finding Office Installation Path
Microsoft Office has many different versions and exists as a 32-bit and 64-bit edition. Finding the installation path with PowerShell can still be...
Hiding Code from ISE Debugger
Typically, when you set breakpoints in your script and then step through your code using F11 or "Debug/Step Into", the debugger will visit...
Exploring PowerShell "Suggestions"
In the PowerShell console, you may have noticed "suggestions" that appear with common errors. Suggestions are designed to help you better...
Analyzing PowerShell Errors
PowerShell logs all errors in $error variable (unless the cmdlet uses -ErrorAction Ignore). $error contains the error records which in turn contain...