There are three types of replication that people in the MySQL and MariaDB Server world care about: asynchronous (the default), semi-synchronous, and...
database-tools
Finding the Right Place in the Cloud for Your MySQL Databases
Here’s the scenario. You’re a DBA at a medium-sized company that has serious growth aspirations. You are one of the team members...
Testing Password Strength
In previous tips, we already talked about services such as haveIbeenpwned.com. They harvest leaked passwords from previous hacker attacks so you can...
What do customers have to say about SQL Diagnostic Manager for SQL Server?
Are you curious about who the customers of SQL Diagnostic Manager for SQL Server are in terms of the type of organization, industry, and...
Which top metrics should you monitor for MySQL databases?
As tables increase in size and more and more users come online, it becomes necessary to finetune the database server from time to time. The secret...
Identifying Hidden Value with Visual Data
There is a staggering amount of data with which modern businesses are expected to cope to remain viable in their chosen market. It is estimated that...
Converting SecureString to Text
It can be very useful to be able to convert an encrypted SecureString back to a plain text. This way, for example, you can use PowerShell’s...
What is Azure SQL Hyperscale high-performance database-as-a-service?
Azure SQL Hyperscale is a new database as a service (DBaaS) offering from Microsoft. Microsoft built Azure SQL Hyperscale on the experiences learned...
Capacity Planning is the Roadmap to Controlled Growth
A constant across virtually all aspects of an organization’s IT environment is that requirements are always changing. Updates, upgrades, and the...
Ensuring Database Security and Appropriate Permissions
Data security is a topic that should be uppermost in the minds of all IT professionals. Protecting an organization’s intellectual resources...
Embedding Binaries (Pictures, DLLs) in PowerShell Scripts
If your script requires external binary resources such as picture files or DLLs, you can of course ship them together with your script. You could,...
Minimizing the Stress of Migrating MySQL to the Cloud
One of the tasks that a database team needs to be prepared to perform is a MySQL migration. In the deep, dark past of the early 21st Century, this...