We are pleased to announce the general availability of SQL Diagnostic Manager 11.1. Existing users may upgrade to this version through the Idera...
SQL Diagnostic Manager 11.1 General Availability
read more
SQL Server
How Attack Surface Management Enhances Database Security
Attack surface management (ASM) is a growing focus for security teams and many C-Level executives with a stake in data management and security such...
What Is Non-Uniform Memory Access (NUMA)?
Bare metal to cloud hosted virtual machines Non-Uniform Memory Access (NUMA) is a four-letter word in every sense, well beyond simply the number of...
Business Reasons to Use a Hybrid Cloud Solution
Organizations are finding that the most effective way to use public cloud resources is by employing a hybrid cloud model. Team productivity and...
Improve ETL Performance by Disabling Non-clustered Indexes
Perhaps you just read the title and thought, “Disable indexes…say what?” Stay with me here, and I'll show you how this...
Announcing Precise 10.3 General Availability
We are pleased to announce the release of Precise 10.3, the company’s application performance monitoring platform. Precise helps IT...
SQL Diagnostic Manager 11.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 11.0. Existing users may upgrade to this version through the Idera...
Columnstore Index for SQL Server
Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with...
How to Effectively Reduce SQL Server Database Index Fragmentation
SQL Server database index fragmentation is a problem faced by many database administrators (DBAs). It is an issue that can seriously impact database...
The Top Five Features of SQL Diagnostic Manager for SQL Server
SQL Server database teams around the world benefit from the features of SQL Diagnostic Manager for SQL Server. A well-established and mature...
Filtered Indexes and Performance
Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the...
Being a Proactive DBA Makes You More Productive
A career as a database administrator (DBA) should appeal to individuals interested in a job that involves a diverse range of duties and technical...
The Most Surprising SQL Antipattern We Use
Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the...
Why Should You Care About Crypto Mining on Your SQL Servers?
Many different types of malware are floating around out there. Some of the variants are purely destructive and are designed to simply delete data....
Identifying SQL Server Performance Problems Part 3
Continuing with our Performance Tuning series as you have learned baselining and knowing your normal system performance metrics is an important part...
Troubleshooting Over-Indexing for Performance
Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the...
Custom SQL Counter… but on a database level?
Good morning, I'm looking at trying to find a way to do the following. For arguements sake, lets say that I have a single table in every...
Troubleshooting Under-Indexing for Performance
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...
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...