There is a major emphasis among businesses across all sectors of commerce and industry to take advantage of cloud computing. The cloud promises many...
The Challenge of Monitoring Hybrid Cloud Solutions
read more
database-tools
How do databases on cloud virtual machines compare to managed cloud databases?
You will need to make a couple of significant decisions right off the bat if you want to move your SQL Server database to the cloud. First of all,...
How Data Analytics Can Lead to Creative Solutions
Many modern businesses are essentially drowning in a sea of data. The explosive growth in the sheer volume of information which an organization must...
Simple PowerShell Chat
Here’s a fun PowerShell script that you can use to create a simple multi-channel chat room. All you need is a network share where everyone has...
IDERA Named 2019 Most Promising Solution Provider for Microsoft by CIOReview Magazine
We are proud to announce that CIOReview Magazine recognized IDERA as being a Top 50 Solution Provider for Microsoft, and a Top 10 Solution Provider...
Why and How to Implement Galera Cluster for MySQL
There are three types of replication that people in the MySQL and MariaDB Server world care about: asynchronous (the default), semi-synchronous, and...
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...
Built-In SSH support in Windows 10
In October 2018, a Windows 10 update added built-in SSH support to Windows 10. From now on, Windows 10 ships with a command-line tool called “ssh”....
Optimize your Database Performance with Load Testing and Profiling
Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. How do you...
Monitoring Can Help Prevent Unauthorized Network Guests
Your organization’s network is the entry point through which users access all of your company’s systems, data, and intellectual capital....
Unleashing the Power of the API for Automation
Database administrators and developers face increased workloads as businesses continue to expand the size and scope of data they collect and manage....
Playing with Latest PowerShell Core Version
In the previous tip we illustrated how you can download a PowerShell script which automatically downloads the latest version of PowerShell Core....
How to become a database administrator for MySQL
You are reading this because you think that becoming a database administrator may be the right career path for you. Database administrators are...
A Unified Platform for More Efficient SQL Job Management
There are many challenges that DBAs face every day. They are expected to maintain the availability of the databases they support and work toward...