As many of you know, Houston is currently experiencing catastrophic flooding. Houston has a special place in our hearts as it is the home of IDERA...
IDERA’s Hurricane Harvey Relief Efforts
read more
database-tools
Disable OneDrive in Windows 10
Are you also irritated by the OneDrive icon found in the navigation tree in explorer? If you never use OneDrive, here are two easy-to-use PowerShell...
Alternate Get-Service
The cmdlet Get-Service has a number of drawbacks. For example, there is no parameter to filter running or stopped services, and the results do not...
Tell Me A Data Story – Part One
Our new 2 1/2 minute video, "Tell Me A Data Story - Part One" tells the story of a small business who realizes that they need to implement...
Robocopy Light
Robocopy.exe is an extremely powerful and versatile built-in command to copy files efficiently from one location to another. Unfortunately, this...
Create Summary Objects for Inventory
Beginning in PowerShell 3, a PSCustomObject can easily combine valuable information that you gathered from different sources. Here is an example...
Scraping Quotes from WikiQuote
Here is a fun script that may not work forever. It takes one or more topics you choose, then returns one or more random quotes taken from the...
Will the Traditional DBA Role be Eliminated with Cloud?
The cloud is all the buzz lately. New features like Automatic Tuning and Active Geo-replication are now being offered by AzureDB with the majority...
Controlling Audio (Mute and Volume)
Ole Morten Didriksen has dug out some API calls that enable audio volume control (https://gist.github.com/oledid). With this, it is trivial from...
A better Get-History
When you type “h” in PowerShell, you see the history of commands you entered during your session. Inspired by Pratek Singh...
Monyog MySQL Monitor v8.2.0: Introducing same Y-axis scaling for dashboard charts
This release includes some GUI improvements and also fixes a few (also mostly GUI-related) bugs. Additionally, we have upgraded most libraries used...
Getting MAC Vendor List
Prateek Singh has invested some effort in creating a sanitized MAC vendor address list in CSV format which can be found in his blog...
Creating Excel Reports (Part 3 – Individually Accessing Workbook)
Sometimes you may want to create irregularly shaped reports, that is reports in a non-table design. For this, PowerShell lets you connect to the...
How to Ensure That Databases Are Backed Up On a Regular Basis
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases....
Creating Excel Reports (Part 2 – Colorful)
When you load CSV data into Excel, you cannot specify formatting, fonts or colors. This is different when you load HTML data into Excel. Here is an...
Creating Excel Reports (Part 1 – Black and White)
The most simple way of creating Excel reports requires just a couple of lines of PowerShell code: dump the results to a CSV file, then submit it as...
How to Analyze the Health of Database Indexes
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose,...
Creating HTML Reports (Part 5 – Applying Style and Design)
In the previous tip we started to turn PowerShell results into HTML reports. The report content is now just fine. To impress people, the report just...
Use SQL Safe Backup’s Monitor Only Policies with customized backup operations
In my previous blog post, I wrote about how customized backup/restore solutions can be accomplished through the use of SQL Safe Backup's command...
Creating HTML Reports (Part 4 – Renaming Columns)
In the previous tip we started to turn PowerShell results into HTML reports. The report content is now almost done. You just may want to polish some...
Creating HTML Reports (Part 3 – Adding Headers and Footers)
In the previous tip we started to turn PowerShell results into HTML reports. It now needs some headers and footers. This is where we left off:...
A complete MySQL monitoring system with early-warning mechanisms: Liam Terblanche, CTO, Airvantage
Airvantage is a Value Added Service Provider for mobile telecommunication networks. Airvantage offers various gaming platforms, and subscriber...
How to Migrate Databases and Data Files
Do you need to: Move databases from one instance to another (for example, to move a performance-intensive database to a faster hard drive to...
Creating HTML Reports (Part 2 – Fixing Non-String Content)
In the previous tip we started to turn PowerShell results into HTML reports. So far, the report is produced but still looks ugly. This is where we...