PostgreSQL is an object-relational database management system (ORDBMS) supporting extensibility and standards-compliance. Just like any...
Month: January 2015
Converting Code to Uppercase
PowerShell ISE 3.0 and later To turn PowerShell code to all uppercase letters in PowerShell ISE, select the text, then press CTRL+SHIFT+U. To turn...
Mapping Drives
PowerShell Version 3 and later To permanently map a network drive, use New-PSDrive with the –Persist parameter. This parameter makes the drive...
Using System Error Colors for Output
All Versions If your script wants to output warnings or error messages, you can use Write-Warning or Write-Error. Both cmdlets will use the default...
The Intrinsic Value of Data Modeling
Maybe you're using Visio, Excel, or a proprietary tool with limited functionality to create a data model. Perhaps you are expanding your job...
Resolving IP Addresses (and Parameter Types, Too)
PowerShell 2.0 and later Here is a function that illustrates two things: it shows how you can limit a parameter to a given data type, and it shows...
How do I get INSERT/UPDATE/DELETE, Table Data Editor and Import to work with Hive?
How do I get INSERT, UPDATE, DELETE, the Table Data Editor and Import to work with Hive? Response Jonathan Powers over 8 years ago With Aqua Data...
Idera SQL Boost 2.9 is here!
I am pleased to announce the availability of SQL Boost 2.9 (formerly known as SQL Traffic Accelerator)! This release is about more than just a...
Conditional Breakpoints
PowerShell 3.0 and later The PowerShell ISE supports line breakpoints only: they make the code stop once the debugger hits that particular line. You...
Detecting 64-bit Operating System
Windows 7/Server 2008 R2 To detect whether a script runs in a 32-bit or 64-bit environment is fairly easy: check a pointer size, and test whether it...
Taming the Wild West of Data
Prior to joining Embarcadero, Ron was a consultant who used ER/Studio as well as a variety of other data modeling suites throughout his career....
Creating NTFS Security Report
All PowerShell Versions If you'd like to audit NTFS permissions on your file servers, here is a suggestion how you could start. This script...
Monyog MySQL Monitor 6.23 Has Been Released
Important note: With the 6.1 release we have changed registration keys. The new key is available for registered users from our Customer Portal....
Knowing Your Storage Basics – 2 Life Lessons
In the software world, it is often the case where everyone wants to learn and master everything. The problem with this approach is that we land into...
Finding Explicit Permissions
All PowerShell versions Typically, NTFS permissions in the file system are inherited. You can, however, add explicit permissions to files and...
Accessing COM Objects without ProgID
All Versions Typically, to access COM objects, these objects need to register themselves in the Windows Registry, and PowerShell needs the...
Data Governance Trends
The volume of data continues to increase and is coming from more data sources. With more data comes increased opportunity, but also increased risk...
Dealing with Hidden Files
PowerShell 3.0 and later When you use Get-ChildItem to list files, by default, hidden files are excluded. To include hidden files, use the...