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...
Announcing General Availability of Aqua Data Studio 21.0
read more
SQL Server
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...
Don’t Fear the Robot Database Administrators
Nightmares about automation can conjure up images of shiny robots toiling away tirelessly without ever making an error or requiring a break. At...
Why You Should Consolidate Your SQL Server Environment
Microsoft’s SQL Server is one of the most widely-used relational database solutions on the planet. Due to its popularity, there are numerous...
How to Handle Unexpected Issues During Cloud Migration
A common issue that affects many areas of the IT world is that things often do not go as smoothly as anticipated. Despite the best efforts that...
Are You Willing to Pay the Price of Non-Compliance?
Data privacy is a hot topic in the world of information technology and promises to remain so for the foreseeable future. As the shift continues to a...
The Problem of Data Breaches Shows No Signs of Slowing Down
An unfortunate and common problem that is encountered just about everywhere in the world is the theft of valuable items from their owners by...
Welcome to the SQL Server Query Store
The current situation we all face with the COVID-19 pandemic has made it difficult or impossible for many individuals to visit their favorite local...
You Need A Reliable Strategy for Protecting Data Resources
Today’s database administrator (DBA) has many responsibilities related to protecting and maintaining access to enterprise data resources....
Who is Responsible and Accountable for a Data Breach?
One of the benefits of forming a corporation is that it provides a level of protection for the individuals who are making decisions regarding the...
Announcing The General Availability of DB PowerStudio 17.1
We are excited to announce the release of DB PowerStudio 17.1 with enhancements and improvements in the following areas. New...
Do You Know How Many SQL Servers You Have?
It’s a pretty straightforward question that many database teams may have difficulty answering. For multiple reasons, it may become necessary...
What Are the Risks of Paying for Ransomware?
Ransomware is a particularly nasty type of malware that is being deployed with increased frequency over the past several months. In a ransomware...
Why DBAs Need to Look for Trouble
In some professions, individuals are expected to wait patiently until called upon to perform their functions. There are no opportunities for people...