Threading The CPU

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 this post we will discuss what threads are in compute terms, how they relate to SQL Server, and a ramification or two...

Performance Tuning vs. Query Tuning

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 places and many people who use the terms interchangeably, but they are not the same.  See also: Whitepaper - Beginning...

Why Load Testing Database Systems is Crucial

Why Load Testing Database Systems is Crucial

Load testing database systems helps prevent performance issues or outages that affect mission-critical database applications. Modern, data-driven organizations rely on their information technology (IT) environment to make productive use of enterprise information...

The One Trace Flag to Use on All SQL Server Instances

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 “SmbShare” noun which represents local folders that you share on a network. Today we’re looking at the “SbmMapping”...

IDERA Included in DBTA Top 100

IDERA Included in DBTA Top 100

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 “SmbShare” noun which represents local folders that you share on a network. Today we’re looking at the “SbmMapping”...

How to Manage SQL Server Jobs in Complex Hybrid Environments

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 “SmbShare” noun which represents local folders that you share on a network. Today we’re looking at the “SbmMapping”...

Tips for More Effective SQL Server Audits

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 “SmbShare” noun which represents local folders that you share on a network. Today we’re looking at the “SbmMapping”...

1 11 12 13 14 15 124