Answering this question should be a pretty straightforward exercise for MySQL support teams. In some cases, such as when databases are still in the...
posts
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
Automating Database Administration is no Longer Optional
Yes, the title of today’s blog post is somewhat provocative, but I think after reading what I have to say that you’ll agree with it. There are...
Geek Sync | 3 Secrets to Improve MySQL Performance
MySQL is a very robust database, but just like any other RDBMS there is an opportunity to improve performance. This session is for all the...
Choosing the Most Effective SQL Server Monitoring Solution
Maintaining a high-performing SQL Server environment can be a daunting task for a database team. Many factors can impact the performance and...
A Visit to the Doctor Can Resolve Your Slow Query Issues
Even the most dedicated DBA is occasionally afflicted with some type of physical ailment that requires a day or two off from work. Sometimes all...
The Bottom-Line Benefits of SQL Server Monitoring
Across nearly every industry, organizations depend upon SQL Server applications to drive critical business operations. In fact, the costs of IT...
Is Your Disaster Recovery Plan Prepared for an Ice Storm?
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Be Prepared for Regulatory Changes in the New Year
It’s a pretty safe bet that most people are glad to welcome the end of 2020. The large-scale changes forced by the COVID-19 pandemic will...
The Challenges of Security in a Hybrid Cloud Environment
The cloud has made many aspects of a computing environment easier to manage. Things like storage and compute power can simply be scaled up and down...
How to simplify routine SQL Server administration tasks
Database administrators need simple and quick ways to manage their SQL Server environment. SQL Admin Toolset provides 24 essential desktop tools for...
Geek Sync | Taking Your First Steps to the Cloud—Building a Hybrid Model
There are different approaches to migrating to the cloud, but most organizations start out in a hybrid fashion, with some resources on-premises and...
How to Control the Complexity of Enterprise SQL Server Jobs
Automation is one of the key techniques by which SQL Server DBAs attempt to tame their environment. Without the ability to automate at least some of...
How to analyze the health of SQL Server database indexes
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose,...
Tips for Improving Your MySQL Database Performance
MySQL is used by many businesses as the database backend for online stores and e-commerce sites. When deployed in this way, the performance of the...
How to ensure that SQL Server 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....
Improving Query Performance in Your Azure SQL Databases
Recent years have seen many organizations migrate part or all of their SQL Server environments to public cloud providers. Moving databases to the...
Cloud Day 2—Understanding Your Options in Platform as a Service Databases
If you have spent any time reading marketing material from cloud vendors, you will know that there is a big push to move your workloads to platform...
Geek Sync | How to Select the Appropriate Approach to Data Governance
There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the...
How to migrate SQL Server 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 speed...
Do You Know the Real Costs of Regulatory Noncompliance?
Compliance or noncompliance, that is the question. Is it an economically sound strategy to spend the necessary resources to remain compliant with...
The Challenge of Variable Seasonal Database Usage
If the past year has taught us anything, it is that we can never know what’s coming next. Just to survive, we may need to reevaluate our...
How to ensure that SQL Server 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...
Protect Your SQL Servers with Always Encrypted
The information stored in corporate databases needs to be protected in multiple ways. Database backups are necessary to recover from a physical or...
How to monitor the health of SQL Server database instances
Determine the health of instances by collecting real-time statistics. Such statistics include backup devices, databases, error logs, locks, logins,...
Cloud Day 2—What Do You Need to Know About Cloud Security?
Cloud security is complex and has several layers to it—first and most important is access to the control plane. The control plane is your...
You Need to Plan a Strategy for SQL Server Backups
Backups are an indispensable component of all computing environments. Creating data backups regularly is considered best practice for everyone from...
How can you tune the performance of SQL Server by analyzing the past to predict the future?
The history of mankind says that we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server performance tuning is...
How to Create a Plan for Regulatory Compliance
Many reasons may make it important for an organization that collects and stores digital information to be concerned with regulatory compliance. Data...
How do you start with performance tuning for Azure SQL Database?
Have you been interested to see how you can baseline performance and improve performance with an Azure SQL Database? Do you want to grasp the secret...
The Right Tools Make a DBA More Productive
The work-life of a SQL Server DBA can be unpredictable. One might be called upon to address a performance issue, setup logins, verify the backup...