What is Continuous Delivery? Agile Software development deals with the shorter development cycles and frequent releases. This development process...
database-tools
Aborting Pipeline
Sometimes you might want to abort a pipeline when a certain condition is met. Here is a creative way of doing this. It works all the way back to...
Aligning Your Models for Master Data Management – by David Loshin
In my last post, I suggested that the conventional “facet” approach to designing master data models (in which each master domain is modeled,...
"Continue" and Labels
When you use the "Continue" statement inside a loop, you can skip the remainder of this loop iteration, and continue with the next....
Get Memory Consumption
To get a rough understanding how much memory a script takes, or how much memory PowerShell puts aside when you store results in a variable, here is...
Use Closures to Lock Variables to Script Blocks
When you use variables inside a script block, the variables are evaluated when you run the script block. To lock variable content, you can create a...
Video: ER/Studio Support for Hadoop Hive
Since data stored in Hadoop is almost always used for analytics, and because of its immense volume and wide variety, the need for data modeling has...
Mutually Exclusive Parameters (Part 2)
Mutually exclusive parameters in PowerShell functions use the "ParameterSetName" attribute to assign parameters to different parameter...
Mutual Exclusive Parameters
Sometimes, PowerShell functions have parameters that should be mutually exclusive: the user should only be able to use either one, not both. To...
Life of a DBA in GIFs
A Database Administrator experiences a wide range of emotions. It could be one those endless meetings, friendly disagreements with fellow...
Model Your Hadoop Hive Databases with ER/Studio
With round-trip database support, data modeling professionals can use ER/Studio Data Architect to easily reverse-engineer, compare and merge, and...
Parsing PowerShell Scripts
If you'd like to create your own color-coded PowerShell scripts, for example formatting them in HTML, here is a sample that gets you started....
Improve Agility and Collaboration with ER/Studio XE7
On April 28, 2015, Embarcadero announced the XE7 release of our award-winning ER/Studio data modeling and architecture suite, with new features to...
Aborting the Pipeline
If you know beforehand how many results you expect from a pipeline, you can use Select-Object to stop the upstream cmdlets. This can save a lot of...
Passing Arrays to Pipeline
If a function returns more than one value, PowerShell wraps them in an array. However, if you pass the results to another function inside a...
Free PowerShell Module for Admins
One feedback we got on a previous tip directed us to "Carbon", a free PowerShell module crammed with useful PowerShell functions. One is...
Converting CSV to Excel File
PowerShell can easily create CSV files using Export-Csv, and if Microsoft Excel is installed on your system, PowerShell can then have Excel convert...
Detecting memory leaks with Precise
Memory leaks in java and .NET can cause major performance issues with the application. Precise helps you to detect those memory leaks. In java,...
Business-Oriented Conceptual Modeling for Master Data Entities – by David Loshin
In my previous post, we examined some of the challenges associated with developing data models for master data entities managed within an MDM...
Who is Accessing Network Resources?
Provided you have Administrator privileges, you can use a simple WMI class to check whether someone is accessing your resources via the network:...
Disable Automatic Reboot After Update
Are you tired of Windows unexpectedly rebooting, just because some newly installed updates required a reboot? Like most things, you can control the...
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' }...