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...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
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...
Addressing License DLL Issues in SQL Enterprise Job Manager
IDERA has recently updated the license library for all the products. In some situations, customers may see a license prompt upon launching the...
Addressing License DLL Issues in SQL Defrag Manager
IDERA has recently updated the license library for all the products. In some situations, customers may see a license prompt upon launching the...
Addressing License DLL Issues in SQL Safe Backup
IDERA has recently updated the license library for all the products. In some situations, customers may see a license prompt upon launching the...
Addressing License CLL Issues in SQL Compliance Manager
IDERA has recently updated the license library for our products which has caused some of our customers to receive a license prompt upon launching...
Compressing Serialized Data
Multipass: Securely Storing Multiple Credentials
If you’d like to safely store credentials (usernames and password) for your personal use in a file, here is a very simple yet extremely...
A Better (and Faster) Start-Job
Start-Job transfers a script block to a new PowerShell process so that it can run separately and in parallel. Here is a very simple sample...
Using Digital Signatures with Timestamp Server
When you start signing script files, you want to make sure signatures stay intact even if the certificate that signed it expires at some day in the...
Digitally Signing PowerShell Scripts
In the previous tips you learned how you can create a self-signed code signing certificate, save it to a PFX file, and read it back into memory....
Top Performance Metrics to Monitor on MySQL (Connections & Buffer Pool Usage)
As a DBA, your top priority is to keep your databases and dependent applications running smoothly at all times. To this end, your best weapon is...
Loading Certificates from PFX Files
In the previous tip we illustrated how you can use New-SelfSignedCertificate to create new code signing certificates, and store them as a PFX file....
Creating Self-Signed Code Signing Certificates
If you’d like to digitally sign your scripts, the first thing you need is a digital certificate with the designated purpose set to “Code...
Monyog MySQL Monitor v8.3.0: Introducing Trend Graph Analysis
Monyog MySQL Monitor v8.3.0 is a feature-rich release which adds a large number of user requests for quick access to relevant monitoring...
Using LDAP Filters in Active Directory
LDAP filters resemble the query language used by Active Directory, and if you have installed Microsoft’s RSAT tools, you can easily use the...
Comparing Computer Data Received from PowerShell Remoting
PowerShell remoting is a very fast way to query multiple computers because PowerShell remoting works in parallel. Here is a real world use case that...
Generating MD5 Hashes from Text
The Get-FileHash cmdlet can generate hash codes for file content. It cannot generate hash codes for arbitrary text, though. And it is available only...
3 Critical Tasks DBAs Wish They Had More Time to Complete
People are constantly asking me what to do to make money. My answer is, “I spend time with people who have trouble with SQL Server Performance...
Finding File Duplicates
In the previous tip we explained how the Get-FileHash cmdlet (new in PowerShell 5) can generate the unique MD5 hash for script files. Hashes can be...
Creating MD5 File Hashes
MD5 file hashes uniquely identify file content and can be used to check whether file content is identical. In PowerShell 5, there is a new cmdlet...