Writing SQL queries makes up a significant part of a database administrator’s (DBA) or developer’s job. The ability to write efficient...
How Indexes Can Help You Write Better SQL Queries
read more
Blog
Diagnosing MySQL Database Performance Issues
In modern business, database administrators (DBAs) need to identify and address MySQL database performance issues quickly. Failure to do so...
Finding and Fixing Inefficient Transactions in Relational Databases
Relational databases form the backbone of many business-critical systems and applications. These databases are expected to perform well and be...
Why Managing Database Changes is Important for Your Business
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...
Building and Analyzing Queries with Aqua Data Studio
Building and analyzing queries are tasks common to both database administrators (DBAs) and developers. The processes can take up a substantial...
Learn How to Better Manage Your SQL Servers
Do you need to manage your SQL Server environment for availability, health, performance, disaster recovery, security, and compliance? Join...
Optimization and Organization Are Key to A Successful Cloud Migration Project
Ultimately a data migration to the cloud is a technical exercise – we will use technical tools to move data to a cloud-based destination. That said,...
SQL Server Database Index Fragmentation: Why You Should Care About It
SQL Server Database Index Fragmentation is one of the leading culprits for slowing down your server’s response time. SQL Server indexes...
How to use Azure Cloud Cognitive Services?
What is Azure Cognitive Services? According to Microsoft, the Cognitive Services in the Microsoft Azure Cloud bring AI within reach of every...
Improve Database Performance with More Efficient Database Profiling
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...
Overcome Advanced Persistent Threat Attacks with Infrastructure Monitoring
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...
A Guide to MySQL Troubleshooting
Effective MySQL troubleshooting starts with effective monitoring. Users need the ability to identify problems at their source so fixes can be made...
Announcing Precise 10.3.1 General Availability
We are pleased to announce the release of Precise 10.3.1, the leading database and application performance monitoring platform. What's New...
SQL Server Security: How to Protect SQL Server Databases
For organizations leveraging SQL Server databases, SQL Server security and understanding how to protect SQL Server databases is a fundamental...
Managing Multi-platform Database Environments
Multi-platform database environments help organizations manage multiple databases - a key capability for modern, data-driven organizations. Modern...
Choosing The Right Database Tool for Database Administrators
Versatile database tools for database administrators (DBAs) can help streamline the workload and increase productivity. And in modern,...
The New Features in Aqua Data Studio Improve its Functionality
The release of version 22.0 of Aqua Data Studio continues the pattern of steadily enhancing the scope and functionality of the application. ...
Announcing the General Availability of SQL Enterprise Job Manager 2.3
We’re excited to announce the release of SQL Enterprise Job Manager 2.3 SQL Enterprise Job Manager is an industry leading monitoring,...
An Effective Way to Establish Regulatory Compliance in the Cloud
Establishing and maintaining regulatory compliance in the cloud is an increasingly common requirement for modern organizations. Complying with...
How to Start Database Performance Tuning and Query Optimization
Database performance tuning and query optimization are critical capabilities for modern, data-driven organizations. Database performance tuning - or...
Threading The CPU
From a slang term for the clothes you wear, through what makes up those clothes, to how a computer process work, they are all called threads. In...
Performance Tuning vs. Query Tuning
We are going to get right to it and not bury the lead here, query tuning is not the same thing as performance tuning. Now there are certainly many...
Why Load Testing Database Systems is Crucial
Load testing database systems helps prevent performance issues or outages that affect mission-critical database applications. Modern, data-driven...
The One Configuration Change to Make on All SQL Server Instances
With every fresh SQL Server installation, there are several default configuration changes you probably consider. For instance, you should probably...