Here is a simple example using the PowerShell progress bar. The code displays a progress bar counting down a break. Simply adjust the number of...
database-tools
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- 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
Monitoring Master-Slave Replication in MySQL 8
MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient...
Understanding Script Block Logging (Part 1)
Beginning with PowerShell 5, the PowerShell engine starts to log executed commands and scripts. By default, only commands considered potentially...
Reading Event Logs Smart (Part 1)
When you query an event log with PowerShell, by default you get back a text message with the logged information. For example, if you’d like to know...
Setting up Basic Master-Slave Replication in MySQL 8
Since April 19th, when MySQL 8.0 became Generally Available (GA), the MySQL community has been abuzz with excitement over all of the new features...
Turning Display Off Immediately
If you are about to launch a lengthy automation script, why not turn off the display right away instead of waiting for the screen saver timeout to...
Connecting to PostgreSQL and MySQL via ODBC to IDERA’s ER/Studio Data Architect
Howdy! Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse...
Improve MariaDB Performance using Query Profiling
Query profiling is a useful technique for analyzing the overall performance of a database. Considering that a single mid-to-large sized application...
Data Vault Modeling with ER/Studio Data Architect
Overview I have been asked multiple times if ER/Studio supports Data Vault Modeling. The answer is yes, ER/Studio does support multiple approaches...
Error Logging in MySQL 8
Although only available as a Release Candidate, MySQL 8 is already proving itself to be a huge leap forward in many regards. Error logging is no...
Purging Kerberos Tickets for All Accounts
In the previous tip we covered klist.exe and how it can be used to purge all Kerberos tickets for the current user so that new permissions will take...
Purging Kerberos Tickets for the Current User
No need to reboot a system just to apply new permission settings. Instead, purge your Kerberos tickets so that you will get a new ticket based on...
Using Chocolatey with PowerShell
Chocolatey is a free package manager for Windows that can be used to download and install software. Before you can use Chocolatey from PowerShell,...
Virtual Machine Snapshots versus Database Backups
Virtual Machine Snapshots Virtual machines provide exciting possibilities concerning backup, recovery, and cloning of databases. Convenient...
Positioning the PowerShell Console Cursor
Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to position and format console text. Note that this...
Database Audit Log Monitoring for Security and Compliance
We recently conducted a webinar on Audit Log analysis for MySQL & MariaDB Databases. This blog will further provide a deep dive into the...
Sort IPv4 and IPv6 Addresses Correctly
When you try and sort IPv4 addresses via Sort-Object, this fails: PS> '10.1.2.3', '2.3.4.5', '1.2.3.4' | Sort-Object 1.2.3.4 10.1.2.3 2.3.4.5...
Sort IPv4 Addresses Correctly
In the previous tip we published a super-fast function called Test-OnlineFast, and this function was able to ping an entire IP segment in record...
Final Super-Fast Ping Command
In the previous tip series, we developed a new function called Test-OnlineFast that can ping multiple computers in record time. For some reason, the...
Finding Registered Event Log Source Names
When you write events to an event log using Write-EventLog, you must specify a valid source name. However, there is no easy way of finding out which...
Select-Object and -ExcludeProperty
Here is a line of code that often puzzles PowerShell users: Get-Service | Select-Object -ExcludeProperty Name When you use Select-Object, its...
Converting PowerShell to Batch
Here is a fun PowerShell function called Convert-PowerShellToBatch. Provide it with the path to a PowerShell script, or pipe in the results from...
How to monitor Always On availability groups
Always On availability groups are part of an integrated solution with the goal of achieving the highest level of data availability and disaster...
How to monitor and diagnose SQL query performance
Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL...
Converting User Name to SID
If you’d need to find out the SID for a user name, here is a useful chunk of code that does the job: $domain = 'MyDomain' $username =...
Displaying Data in a Grid View Window Vertically
Out-GridView always produces a table with one object per line: Get-Process -Id $pid | Out-GridView Occasionally, it would be more helpful to display...
Alert Configuration Templates in SQL Diagnostic Manager
Several versions ago, SQL Diagnostic Manager (SQLDM) introduced Alert Configuration Templates, which basically allowed users to preconfigure alert...
Finding All Domain Controllers (no module required)
In the previous tip we explained how you can use the ActiveDirectory module and its cmdlets to find all domain controllers in your organization, or...
Getting Cached Credentials
In the previous tip we talked about a public module called PSCredentialManager that helps you manage cached credentials. Sometime, less is more, so...
Installing Modules in PowerShell Core on Linux
When you’d like to install modules for all users from the PowerShellGet repository, you need Administrator privileges. On PowerShell Core on...