SQL Server compliance audits play a key role in keeping your SQL Server instances - and the rest of your organization - secure. Many...
How to Protect Your Business with Internal SQL Server Compliance Audits
read more
SQL Server
Let the Doctor Fix Your Ailing SQL Server Performance
Microsoft SQL Server is one of the most popular database management systems (DBMS) in the world. As a result of its popularity, many...
Top 5 Reasons for Slow SQL Server Queries and How to Fix Them
Slow SQL Server Queries are a common issue among database administrators (DBAs). You would be hard-pressed to find a SQL Server DBA who was not...
Announcing Precise 10.3.1 General Availability
We are pleased to announce the release of Precise 10.3.1, the leading database and application performance monitoring platform. What's New...
Threading The CPU
From a slang term for the clothes you wear, through what makes up those clothes, to how a computer process work, they are all called threads. In...
Performance Tuning vs. Query Tuning
We are going to get right to it and not bury the lead here, query tuning is not the same thing as performance tuning. Now there are certainly many...
The One Configuration Change to Make on All SQL Server Instances
With every fresh SQL Server installation, there are several default configuration changes you probably consider. For instance, you should probably...
The One Trace Flag to Use on All SQL Server Instances
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
How to Manage SQL Server Jobs in Complex Hybrid Environments
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Tips for More Effective SQL Server Audits
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
SQL Diagnostic Manager 11.1 General Availability
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
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
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
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....