Robocopy.exe is an extremely powerful and versatile built-in command to copy files efficiently from one location to another. Unfortunately, this...
Robocopy Light
read more
database-tools
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...
How to Ensure that Databases Do Not Have Fragmented Indexes
Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation...
Creating HTML Reports (Part 1 – Creating HTML)
To turn PowerShell results in a HTML report, simply pipe the results to ConvertTo-Html, then save the result to file. So in its most basic form, it...
Control Console Transparency on Windows 10
On Windows 10, when you open a PowerShell console, simply hold CTRL+SHIFT, then turn your mouse wheel, to control console background transparency....
Guilty Until Proven Innocent
Every DBA knows that they are guilty until proven innocent when performance problems arise. You are one of the usual suspects and it makes...