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
read more
database-tools
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...
Getting Prepared for GDPR
GDPR goes into effect on May 25, 2018. Anyone who captures personal data for EU members will be subject to meeting these compliance guidelines or...
Creating Balloon Tips Safely
Inspired by an article by fellow MVP Boe Prox, below you’ll find a sophisticated function that creates balloon tip dialogs. You can find...
Using Business Processes for Data Governance
Business Processes can be a huge asset for you when you are trying to define your Data Governance Policies. While they aren't specifically...
Creating Leading Zeros
Did you ever need to convert numbers into strings with leading zeros, for example to compose server names? Simply use PowerShell’s...
Demystifying Error Handling
Any error in PowerShell code surfaces as an error record object. Check out the function below which extracts all relevant error information from...
HIPAA Compliance for Data Professionals
While medical facilities are most at risk for a HIPAA violation, most organizations in the United States have to comply with the law and can be hit...