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...

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...
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...
With every fresh SQL Server installation, there are several default configuration changes you probably consider. For instance, you should probably...
Trace flags are SQL Servers version of magic spells. They’re kinda mystical with strange numerical names, and they can often do very powerful...
Hybrid environments are a common hurdle for today’s SQL Server database administrator (DBA). They often face supporting systems spread across...
Aqua Data Studio is the industry leading multi-platform Database Integrated Development Environment (IDE) with Visual Analytics. Data and...
SQL server audits are an important function for database administrators (DBAs) and database teams. How they go about this activity can have a...
We are pleased to announce the general availability of SQL Diagnostic Manager 11.1. Existing users may upgrade to this version through the Idera...
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...
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...
Organizations are finding that the most effective way to use public cloud resources is by employing a hybrid cloud model. Team productivity and...
Perhaps you just read the title and thought, “Disable indexes…say what?” Stay with me here, and I'll show you how this...
We are pleased to announce the release of Precise 10.3, the company’s application performance monitoring platform. Precise helps IT...
We are pleased to announce the general availability of SQL Diagnostic Manager 11.0. Existing users may upgrade to this version through the Idera...
Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with...
SQL Server database index fragmentation is a problem faced by many database administrators (DBAs). It is an issue that can seriously impact database...
SQL Server database teams around the world benefit from the features of SQL Diagnostic Manager for SQL Server. A well-established and mature...
Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the...
A career as a database administrator (DBA) should appeal to individuals interested in a job that involves a diverse range of duties and technical...
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...
Many different types of malware are floating around out there. Some of the variants are purely destructive and are designed to simply delete data....
Continuing with our Performance Tuning series as you have learned baselining and knowing your normal system performance metrics is an important part...
Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the...
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...