database Archives

Do not leave your most valuable backups to chance

Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day....

Selected strengths of SQL Diagnostic Manager

by Peter

In many organizations today, Microsoft SQL Server supports applications that are critical to organizations where downtime and poor performance has...

Snowflake Magic! with Aqua Data Studio

by Anil M

Howdy, y'all! Happy Thursday! Today we will be exploring the exciting world of Cloud Data warehouses and my personal favorite,...

Aqua Data Studio does the Magic Again! Salesforce Connectivity!

by Anil M

Howdy, y'all! I am here again with another cool Aqua Data Studio blog. I would like to credit this blog post to my colleague for setting...

Aqua Data Studio – Working with Complex Data Environments Can Be A Challenge.

by Lisa

Companies are expanding their systems beyond relational databases to incorporate big data and cloud deployments, creating hybrid configurations....

DB PowerStudio 17.0.3 General Availability

by Former Member

We’re excited to announce the general availability of DB PowerStudio 17.0.3. Existing users may upgrade to this version through the Idera...

Methods for Handling Big Data for Healthcare

by Peter

Healthcare organizations need methods to overcome challenges to achieve the data-driven financial and clinical objectives. Such approaches include...

How to Manage Complex Database Environments

by Peter

Every year, data becomes increasingly critical to the organization. And data becomes even more complicated to manage and keep secure. The growth in...

Properties of Big Data for Healthcare

by Peter

Healthcare organizations must consider the essential properties of the analytics for big data that when commencing significant projects for...

Handling the Complexities of Analytics for Big Data for Healthcare

by Peter

Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...

Monitor the performance of SQL Server in the hybrid cloud

by Peter

As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud...

How to troubleshoot locking problems in SQL Server with Dynamic Management Views

by Peter

Database professionals are often called upon to investigate performance problems related to locking, but most investigations into locking rarely go...

What to do when the SQL Server service does not start

by Peter

The executable process that is the SQL Server Database Engine is called the Database Engine service. The Database Engine service is an executable...

Data Proximity for Data Warehousing Performance

by Bert Scalzo

Data Warehousing DBAs usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBAs...

Top metrics to monitor in your MySQL databases

by Peter

As tables increase in size and more users come online, it becomes increasingly necessary to fine-tune your MySQL database server from time to time....

Sharing Files and SQL statements using Aqua Data Studio

by Devin Gallagher

There are many ways to share files or SQL statements using Aqua Data Studio. These range from shortcuts to your own file directories or...

What are visual SQL tuning diagrams?

by Peter

SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important...

Surprises in 2018 and Predictions for 2019

by Stan Geiger

Recently I was asked to contribute my thoughts on what things in database technology were a surprise in 2018 along with what trends and topics would...

How to Find and Fix SQL Server Deadlocks

by Peter

Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...