November 2014

Aqua Data Studio 15.0.11 – Minor Fixes and Enhancements

We have released the 15.0.11 patch which addresses a few defects and includes a few enhancements. For Generic JDBC connections we now display Index...

Tips Database Developers Must Know Reading Query Plans

by Tim DelChiaro

If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help you in understanding...

Pinging via IPv4

by ps1

All PowerShell versions You can use ping.exe just like any other command inside PowerShell scripts. By adding “-4” to the command line,...

The 3Vs may require NoSQL, but data modeling is still required – by Rob Loranger

by Joy Ruff

We live in an exciting time where technology is entering our lives in areas that many of us never expected. For example, at home, once unintelligent...

Knowing your Storage Basics- 2 Life Lessions for a DBA

by Tamarian D2278

IF_THEN_ELSE_RapidSQL

by Tamarian D2278

This week I’ll take a look at IF-THEN-ELSE-ELSEIF syntax. Next blog I’ll take a look at the similar CASE syntax and compare/contrast the...

CASE Syntax using Rapid SQL

by Tamarian D2278

Hi, Last blog we visited the IF-THEN-ELSE conditional syntax. This blog, I’d like to convert those examples using the newer CASE...

Use F1 in PowerShell ISE

by ps1

PowerShell ISE 3 and later When you have downloaded the PowerShell help files (using Update-Help from an elevated shell), you can use the Get-Help...

Monyog MySQL Monitor 6.21 Has Been Released

by Ritesh

Important note: With the 6.1 release we have changed registration keys. The new key is available for registered users from our Customer Portal....

Functions Always Beat Cmdlets

by ps1

All PowerShell versions Functions always have higher rank than cmdlets, so if both are named alike, the function wins. This function would...

Auditing is More Than a Way to Get the Security Team Off Your Back

by ideracommunity

As a DBA, you probably look at auditing tools as a something forced upon you by the security officer. You are asked to provide continuous auditing...

Securing your Data Modeling Assets – ER/Studio Repository

by Anil M

SQL PASS Summit 2014 – An Extraordinary Experience!

by Anil M

What a Fabulous Week at @SQLPASS #Summit14. Met new prospects and also current customers!! We had a lot of folks come to our booth and...

Encrypting and Decrypting Files with EFS

by ps1

All PowerShell versions Provided EFS (Encrypting File System) is enabled on your system, and you are saving files to a NTFS location, then this is...

Use Out-Host instead of More

by ps1

PowerShell Console Note that any of this will only work in a “real” console. It will not work in the PowerShell ISE. To output data page...

Aqua Data Studio 15.0.10 – Minor Fixes and Major Enhancements

by Jonathan Powers

We have released the 15.0.10 patch which addresses several defects and includes a few enhancements. SQL Server 2008 and above now have support for...

Invoke-Expression is Evil

by ps1

All PowerShell versions Try and avoid Invoke-Expression in your scripts. This cmdlet takes a string and executes it as if it was a command. In most...

Display Command History in PowerShell Console

by ps1

All PowerShell Versions In the PowerShell console (not the PowerShell ISE), you can open a list with the last commands you entered, simply by...

Importing and Installing Certificate

by ps1

All PowerShell versions To programmatically load a certificate from a file and install it in a specific location inside the certificate store, have...