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...
Troubleshooting Under-Indexing for Performance
read more
SQL Server
Why Automation is Mandatory for Database Administrators
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...
Make Sure You are Using the Right Kind of SQL Server Backup
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...
Beginning Indexes for SQL Server Performance
Introduction People often characterize indexes as silver bullets for the performance issues in SQL Server. Is it true? Well, yes and no. In this...
Don’t Let Increased GDPR Fines Hurt Your Bottom Line
The European Union’s General Data Protection Regulation (GDPR) was put into effect on May 25, 2018. In the rapidly evolving world of...
Why You Need to Care About SQL Server Fragmentation
DBAs have many responsibilities as the keepers of enterprise data resources. Keeping systems available for their users is one of the big ones....
Identifying Performance Problems Part 2
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...
Make Sure Your SQL Servers Don’t Get Lost in the Cloud
Moving a computing environment from on-premises data centers to public cloud providers has become a fairly standard activity for many database...
Identifying Performance Problems Part 1
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database...
Best Practices for Your SQL Server Security
SQL Server security has always been important. Protecting the enterprise data resources stored in SQL Server databases is arguably the prime...
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 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...
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...
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...
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...
Announcing General Availability of Aqua Data Studio 21.0
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...
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...
Geek Sync | Practical PowerShell For The Busy DBA
Many DBAs don't have time to learn PowerShell. Thankfully, there is an excellent PowerShell library already created specifically for handling...
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 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...