In this skill sprint we cover ISQL editor features in DBArtisan and Rapid SQL. Learn about the options available in the ISQL window for different...
database-tools
Splitting Text at Uppercase Letters
To split a text at each uppercase letter, without having to provide a list of uppercase characters, try this example: $text =...
Finding Uppercase Characters
If you'd like to find uppercase characters, you could use regular expressions. However, you would then provide a list of uppercase characters to...
Using Green Checkmarks in Console Output
In a previous tip you have seen that the PowerShell console supports all characters available in a TrueType font. You just need to convert the...
Using Symbols in Console Output
Did you know that console output can contain special icons like checkmarks? All you need to do is set the console to a TrueType font like...
MSSQLTips Reviews Top New SQL Free Tools from Idera
Most of you are aware of the variety of free tools Idera offers to the SQL community to help with SQL Server tasks. Some of you have even mentioned...
Finding Your Top Offending Statements with Extended Events
Finding the top offending statements for a specific workload can be hard if you are not using the best tool in your toolbox. On SQL Server 2012 and...
Test Nested Depth
When you call a function, PowerShell increases the nest level. When a function calls another function, or script, this will again increase the nest...
Continuous Delivery in the Database
What is Continuous Delivery? Agile Software development deals with the shorter development cycles and frequent releases. This development process...
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...