Featured Blog
Understanding and Managing High Memory Usage in SQL Server
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...
How can you improve the performance, disaster recovery, and security of SQL Server?
SQL Doctor tunes SQL Server performance, security, and disaster recovery via expert recommendations in physical, virtual, and cloud environments -...
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...
How did an IT consulting firm save time and money on performance fine tuning for SQL Server?
When companies are looking for a SQL Expert to help with performance challenges, they turn to Oregon-based consulting firm Lake IT for experienced...
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...
How did a healthcare company in South Africa fix a slow and erratic SQL Server?
An IT company that deals with the healthcare industry in South Africa develop a variety of software products, which cover a wide range of...
What do IDERA’s customers have to say about SQL Doctor?
Are you curious about who the customers of SQL Doctor are in terms of the organization, industry, and country? What is the size and the deployment...
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 are you tuning the performance of SQL Server, Azure SQL Database, and Amazon RDS for SQL Server?
SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance...
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...
Installing Precise in an AWS or Azure environment
Precise provides support for AWS and Azure. We have provided support for AWS and Azure since Precise 9.9. (June 2018) The Precise framework...
Announcing the General Availability of SQL Secure 3.4
We are pleased to announce the general availability of SQL Secure 3.4. Customers can access the new version via the IDERA Customer Portal. New...
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....
Key Target Platforms Update
I wanted to share some interesting data following a recent presentation looking into Modern Windows development. 75% of Windows Desktops use Windows...
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...
Lessons Learned From 3 Years in the Trenches with AWS
Since the time of our founding, IDERA has been using Amazon Web Services (AWS). It was critical to us to use cloud technologies to build our...
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...
The Best Way to Use Your Monitoring Software
Many businesses rely on extensive and complex computing environments to run daily operations, service customers, and store valuable data resources....
Making Time Using Temporal Data
SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what...
How to Secure Your SQL Servers from Internal Threats
The tremendous value of enterprise data resources makes them an inviting target for malicious actors. Losing sensitive financial or personal data...
Oracle 19.7 on Linux and Oracle 19.8 on Solaris is supported in Precise 10.2
Precise 10.2 now supports the latest Oracle 19C patches for Linux and Solaris. Linux Oracle 19.7 on Linux is now supported in Precise 10.2See the...
Tips on How to Become a SQL Server Database Administrator
The increased focus that organizations are placing on their data resources has put a premium on their use of database technology. Making productive...
Oracle 19.7 on Linux and Oracle 19.8 on Solaris is supported in Precise 10.2
Precise now supports the latest Oracle 19.7 patch on Linux and the Oracle 19.8 patch on Solaris. The latest patch from Oracle for Oracle 19C on...