Introduction All too often, people treat a good index as a silver bullet in terms of SQL Server performance. It is well-known that we will encounter...

Introduction All too often, people treat a good index as a silver bullet in terms of SQL Server performance. It is well-known that we will encounter...
One of the promises of technology was that it would make our lives less complicated and afford the average person more free time to pursue the...
All but the most novice SQL Server DBA understands that creating database backups is an important part of their job. A viable backup can be the...
Introduction People often characterize indexes as silver bullets for the performance issues in SQL Server. Is it true? Well, yes and no. In this...
The European Union’s General Data Protection Regulation (GDPR) was put into effect on May 25, 2018. In the rapidly evolving world of...
DBAs have many responsibilities as the keepers of enterprise data resources. Keeping systems available for their users is one of the big ones....
Performance Monitoring Tools In this second post we are diving into what tools you can use to capture the important performance metrics you need to...
Moving a computing environment from on-premises data centers to public cloud providers has become a fairly standard activity for many database...
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database...
SQL Server security has always been important. Protecting the enterprise data resources stored in SQL Server databases is arguably the prime...
Maintaining a high-performing SQL Server environment can be a daunting task for a database team. Many factors can impact the performance and...
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 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...
There are different approaches to migrating to the cloud, but most organizations start out in a hybrid fashion, with some resources on-premises and...
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...
Recent years have seen many organizations migrate part or all of their SQL Server environments to public cloud providers. Moving databases to the...
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...
Compliance or noncompliance, that is the question. Is it an economically sound strategy to spend the necessary resources to remain compliant with...
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...
On behalf of the entire Aqua Data Studio team, we’re excited to announce the release of Aqua Data Studio version 21.0 with Enhancements in the...
The information stored in corporate databases needs to be protected in multiple ways. Database backups are necessary to recover from a physical or...
Many DBAs don't have time to learn PowerShell. Thankfully, there is an excellent PowerShell library already created specifically for handling...
Backups are an indispensable component of all computing environments. Creating data backups regularly is considered best practice for everyone from...
Many reasons may make it important for an organization that collects and stores digital information to be concerned with regulatory compliance. Data...