There are many ways how a script can store data information. One is especially convenient. Here is the code: Import-LocalizedData -BaseDirectory...
database-tools
Webinar Highlights: What’s New in Monyog & Roadmap Update
Thank you everyone who attended our webinar on “What’s new in Monyog & Roadmap update”. In this webinar, Shree Nair, Product Manager at Webyog...
Understanding .NET Type Name Variants in PowerShell
PowerShell can use .NET type names, for example to convert values to a given type. Frequently, scripts use a variety of formats to define .NET...
Minimalistic Error Handling
Error handling does not necessarily have to be complex. It can be as simple as checking whether the last command executed successfully: # suppress...
December #SQLChat – A Discussion on Diversity in Tech with WIT
A lot of emphasis has been placed on diversity in tech of late, with good reason. Research has shown that a more diverse team finds more innovative...
Temporarily Disabling PSReadLine Module
Beginning in PowerShell 5, the PowerShell console features colorized text, and there is a wealth of other new features provided by a module named...
Top 12 Tips for Safe Online Shopping on Black Friday
Online shopping has become a popular way to purchase items without the hassles of traffic and crowds. Online shopping offers convenience and comfort...
Using Windows EventLog for Script Logging
Updated Free Tool: PowerShell Scripts for SQL Server 4.0: Added 13 Scripts
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release supports SQL Server 2016 and 2017, and Windows Server...
General Availability of Secure 3.1.200
Announcing SQL Secure 3.1.200 General Availability We are pleased to announce the general availability of SQL Secure 3.1.200. Existing users may...
Getting File Extension
By converting a path to a FileInfo object, you can easily determine the path parent folder or file extension. Have a look:...
MySQL Performance Tuning Tips for the Shopping Season
With Halloween all but a distant memory, the time has come to turn our attention to the upcoming holiday season. First, Thanksgiving, then Black...
The SQL Song That’s About to Hit The Billboard Hot 100 Chart
Homer McEwen, aka Killa DBA, has always loved music – from his early years in the church choir to today's gigs as a singer and songwriter....
Working with [FileInfo] Object
Often, code needs to check on files, and for example test whether the file exists or exceeds a given size. Here is some commonly used code: $logFile...
Install Precise PMDB in an Oracle PDB
Working in tandem with David's announcement of Precise version 9.8, here is a one screen how-to. Precise version 9.7 supports installing the...
Install Precise PMDB in an Oracle PDB
Precise version 9.7 supports installing the Performance Management Database in a PDB. Precise version 9.8 supports monitoring Oracle...
Script Logging Made Easy
Beginning in PowerShell 5, you can use Start-Transcript in any host to log all the output created by your script. Here is how you can easily add...
Multi-Language Voice Output
On Windows 10, the operating system ships with a bunch of high-quality text-to-speech engines and is no longer limited to just the English language....
Precise V9.8.0
We are pleased to announce the general availability of Precise V9.8.0 Here are some of the highlights: Oracle 12CR2 support on Solaris...
Precise 9.8.0 GA
We are pleased to announce the general availability of Precise V9.8.0 Here are some of the highlights: Oracle 12CR2 support on Solaris...
Removing Text from Strings
Occasionally, you might read about Trim(), TrimStart(), and TrimEnd() to remove text from strings. And this seems to really work well: PS C:\>...
Meet the IDERA ACE Class of 2018!
We are excited to introduce our new 2018 IDERA ACEs! This program helps active members of the database and data modeling community share...
Addressing License DLL Issue
Upgrade your license library if required Should you determine that you have a problem with your SQL Secure license keys, please follow the procedure...
Uncompressing Serialized Data
In the previous tip you learned how you can use Export-CliXml to serialize data and then use Compress-Archive to shrink the huge XML files to only a...