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...
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
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...
Logical to Physical Data Modeling
In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to...
Finding Installed Updates (and searching for missing) (Part 4)
Sometimes, the Microsoft.Update.Session object is used to check whether a given update is present on a machine. Some authors query the text title...
Oracle, SQL, Sybase, DB2 Performance
Every DBA knows that they are guilty until proven innocent when performance problems arise. You are one of the usual suspects and it makes...
Why consider an End-to-End APM / Real User Management performance solution?
Precise is appropriate for third-party & homegrown Java and .NET applications plus the traditional ERPs: SAP, PeopleSoft, E-Business Suite, and...
Finding Installed Updates (and searching for missing) (Part 3)
When you want to examine installed updates on your machine, rather than searching for updates online and then comparing the installation status with...
New patch releases available for ER/Studio 16.5.0 (2016+) and also ER/Studio Team Server 16.1.x (2016)
For customers using ER/Studio 16.5.0 (2016+), the 16.5.1 patch release is now available. This patch contains a number of performance...
Finding Installed Updates (and searching for missing) (Part 2)
When PowerShell asks Windows for updates via the Microsoft.Update.Session object, some information seems to be unreadable. The code below dumps...
How to Monitor the Health of Database Instances
Determine the health of instances by collecting real-time statistics (including backup devices, databases, error logs, locks, logins, performance...