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...
database-tools
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...
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...
Changing GPO Description/Comment
GroupPolicy Module When you create a new Group Policy, you can set a comment (or description). There is no apparent way, however, to change the...
Checking PowerShell Security
PowerShell 2.0 and later This sample code finds all PowerShell scripts in a given drive, then checks the scripts for valid digital signatures, and...
Holiday Time Resources
Have a little free time over the holidays while providing coverage for work, or like to brush up on technical information? In addition to the many...
Dealing with %ERRORLEVEL%
All PowerShell versions When you run native EXE console commands inside your scripts, these commands typically return a numeric return value. This...
Automating Data Modeling Tasks
Finding ways to automate common tasks can make your data modeling more productive. By investing a little bit of time initially, you can save time...
Compacting Paths
[WindowsAPILib.Helper _i="0" _address="0" theme_builder_area="post_content" /][WindowsAPILib.Helper _i="1" _address="1"...
Get the OU from an LDAP Path
All Versions To extract certain parts from raw strings, you can often use a combination of text splitting and text substring commands. For example,...
Proof of Concepts made Easy with The Cloud
As a Solutions Architect, there are times when you actually need to replicate customer scenarios, often becomes a challenge, unless you have your...
Creating Huge Dummy Files
All PowerShell versions If you need to stress test systems, or need large dummy files for other purposes, here is some code that can create even...
Data Modeling for Agile Environments
Agile Development has always been at the forefront of new ways of developing software. So why should Data Modeling be left behind? In this short...
Limiting Maximum String Length
All Versions To make sure output text is not excessively long, you can use logic like this to shorten text that is longer than a given maximum...
Consistent Data in Distributed Systems
This is a video replay from the DataU online conference. Data types that are not consistent across multiple systems where data movement occurs could...
Integrated cross-platform SQL IDE for increased database development efficiency
Have you ever wanted a SQL IDE that would help you code SQL for multiple platforms using a Single IDE? Now you can! with Embarcadero's RapidSQL...
2 Ways to identify that we have a bad plan in SQL Server
SQL Server is a complex RDBMS with a lot of capabilities in it. I am sure most of us have just scratched the surface when it comes to working with...