We have released the 16.0.5 patch which addresses a few enhancements and defects in both Aqua Data Studio and Visual Analytics. The Table Data...
Month: April 2015
Removing Whitespace (and Line Breaks)
You may know that each string object has a method called Trim() that trims away whitespace both from the beginning and end of a string: $text =...
Receiving Error Level from PowerShell Script
Here is a quick script illustrating how a PowerShell script can send back a numeric status code to the caller: $exitcode = 123 $p = Start-Process...
Why "exit" can kill PowerShell
Occasionally, there are misunderstandings how "exit" works. Take this example: function abc { 'Start' exit 100 'Done' }...
Usando Configurações XE8 Migration Tool
RAD Studio XE8 tem uma nova ferramenta para migrar configurações de IDE a partir de uma versão mais antiga, ou dentro de diferentes instalações da...
Understanding break, continue, return, and exit
Do you know off-hand what "break", "continue", "return", and "exit" do? These are powerful language...
Identifying Risky NTFS Permissions
Here is a quick and easy way to find NTFS permissions that are potentially dangerous. The script tests all folders in $pathsToCheck and reports any...
Webcast – MSSQLTips hosts Server Monitoring with Uptime
Come see the newest addition to the Idera family – up.time – a unified and highly scalable IT infrastructure monitoring solution....
The Evolution of Data Modeling – by Ron Huizenga
When we review the evolution of new data architecture and development methodologies, along with the corresponding changes in corporate culture, we...
Get IP Address Geolocation
Would you like to know where a public IP address is located? Provided you have Internet access, you can query one of the public information...
Get Current IP Address
Here is a quick way to get all IP addresses assigned to your computer: #requires -Version 1 $ipaddress = [System.Net.DNS]::GetHostByName($null)...
Validating Domain Credentials
To check credentials (username plus password) against your current domain, you can use this approach: #requires -Version 1 $username =...
Taking Server Monitoring Alerts up a Level
In this blog I wanted to tackle strategies for monitoring that go beyond looking for and responding to alerts. One of the key features of any...
The Challenge of Master Data Modeling – by David Loshin
I had a recent email exchange in which a customer was looking for guidance in developing data models for master data entities used across multiple...
Safely Use UNC Paths
Whenever you use UNC paths in PowerShell, your script may break. Since a UNC path has no drive letter, PowerShell looks at the current directory...
Aqua Data Studio 16.0.4 – Minor Fixes and Major Enhancements
We have released the 16.0.4 patch which addresses a few enhancements and defects in both Aqua Data Studio and Visual Analytics. This version...
Using Splatting
With splatting, you can call cmdlets and programmatically control the parameters you submit. To do this, add the parameters and values to a hash...
Working with TMapView on iOS and Android with RAD Studio XE8
[Random(42), 0="Random(54124)" _i="0" _address="0" theme_builder_area="post_content" /]
2015 State of the Cloud Report
Cloud management provider Rightscale has released their second annual State of the Cloud Report, a survey of 930 technical professionals. It is...
Monyog MySQL Monitor 6.27 Has Been Released
Changes (as compared to 6.26) include: Bug fixes: * Monyog no longer prompts the user to re-type the admin password while upgrading on Windows. * In...
Reading RSS Feeds
RSS feeds can be read by using an XML object, however XML objects do not support proxies. Here is an example that uses Invoke-WebRequest to retrieve...
Getting Registry Values and Value Types
Get-ItemProperty can easily read registry values, but you do not get back any information about the registry value type. Get-ItemProperty -Path...
Finding Information about TV Series
PowerShell can query websites that deliver XML content, and here is an example on how to query a movie database. Simply adjust the name of the TV...
Comparing Folder Content
To quickly compare folder content and find out files that exist only in one of two folders, try this example: $list1 = Get-ChildItem...