Moving a computing environment from on-premises data centers to public cloud providers has become a fairly standard activity for many database...
Make Sure Your SQL Servers Don’t Get Lost in the Cloud
read more
SQL Server
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...
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...
RATs Can be a Security Threat to Your SQL Servers
Before you click away, let me assure you that this post is not about rodents chewing on power cords or networking cables. RATs is an acronym for...
Why You Should Care about Database Index Fragmentation
Providing smoothly running systems that quickly respond to user queries keeps both customers and management happy. All but the most inexperienced...
Keeping an Eye on All of Your SQL Servers
The majority of organizations that use SQL Server as one of their database solutions have more than one instance in their environment. In some...
Keeping Users Happy with High-Performance Databases
Without users, databases are rather abstract constructs that, it can be argued, have no real purpose. It is certainly an interesting technical...
Prepare for the Worst, Hope for the Best
If you have spent any time in the IT world, you probably know that things do not always go according to plan. In fact, at times it seems that...
Cloud Day 2–Understanding Cloud Storage
Welcome to the Cloud Day 2—in this series you will learn about some slightly more advanced topics in the public cloud. We’re going to go...