Howdy! Welcome to the next installment of the series. In today’s series, we will explore the options for Oracle Client Setup needed for ER/Studio....
database-tools
Reading XML Content
Reading XML formatted text is easy when you use an XML object for it. With its method Load(), you can read in content from a file path or a URL. In...
Designing XML Documents
Today we start a little mini series about XML. To create sample data to play with, you will first create a well-formed XML. While you can create XML...
The Shield
How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are always saying no or they have to wait? I know many...
Setting up Oracle for IDERA ER/Studio – Part 1
In this blog post, I will be covering how easy it is for one to setup Oracle, in order to successfully work with IDERA’s leading Enterprise...
Setting up IDERA’s ER/Studio Repository with Microsoft SQL Server in Microsoft Azure Virtual Machines
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Microsoft Azure Cloud. Now I will not be going...
Finding Out UTC Time
When you work in a global environment, it sometimes becomes necessary to translate the local time to UTC (Universal Time). The conversion is done by...
Setting up ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud Environment. Now I will not...
Fast String Operations
String concatenation is a frequent thing in scripts but when you use the "+=" operator to append text to a string, this slows down your...
April #SQLChat – “Migrating SQL Server"
Did you know SQL Server 2005 falls out of service April 12? Join us for a Twitter Chat and you’ll be fully prepared for future Server migrations!...
Parse an Exact Date
If you need to parse a date or time information out of raw text, and if the date and time format does not adhere to the standards of your operating...
Faster Array Manipulations
The "+=" operator is pretty convenient and can add new elements to an array. If you need this more than once, for example in a loop, then...
ER/Studio Model Repository Database Sizing Guide for Oracle
Howdy! In a previous article, I showcased on how to implement table statistics and Index Re-orgs in SQL Server for the Model Repository. In...
Copy Command History to a Script
Sometimes you may have played around with the interactive PowerShell and suddenly realized that some of the commands you played with were pretty...
IDERA ER/Studio Repository Database Sizing Guide SQL Server Edition – Best Practices
IDERA ER/Studio Database Sizing Guide – Best Practices Howdy! In this blog post, let us shed some light on how to better leverage Capacity...
March #SQLChat Wrap-Up
Our March #SQLChat took place Wednesday, March 9 at 11 AM CT. This Twitter Chat was hosted by both John Sterrett and Robert Vandervoort and was...
Compare Versions
Ever wanted to compare software versions? If you do it like this, the result is off: PS> '3.12.11.100' -gt '11.1.22.91' True...
Cleverly Aborting Endless Loop
In a previous tip you have seen how an endless loop can be used to continuously monitor things - until PowerShell is closed, or a user presses...
Finding Executable Path
Here is a one liner telling you the exact location of the executable of any running process. The example returns the path to the PowerShell...
Analysis Services: Solving Hierarchy Errors of Uniqueness
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group...
Thinking Strategically about SQL Server on Linux
People all over the database world were in for a stunner this week when Microsoft announced that they will be supporting SQL Server installations...
Doing Things Forever
If you want PowerShell to run forever, for example in order to continuously ping a site, use a simple endless loop: #requires -Version 2...
Switching Keyboard Layout with PowerShell
Next time you find yourself with a PowerShell console that uses the wrong keyboard layout, keep your fingers off the mouse! Do it with PowerShell...
New Query Analysis Features in Monyog
While looking to optimize your MySQL, you are needing to spot slow/bad queries at a glance and get deep insights about them with ease. The latest...