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...
Month: May 2015
SQL Diagnostic Manager 9.1 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 9.1. Existing users may upgrade to this version through the Idera...
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...
May 13 Webcast on Database Automation
Join us for our next Geek Sync webcast topic – Database Automation on May 13, 2015 with special guest, Yaniv Yehuda Co-Founder and CTO of...
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...
CORS on DataSnap REST Server
Cross-origin resource sharing (CORS) is a mechanism that enables resources to be shared across domains. Typically this isn’t allowed to...
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...