Denny's SQL Secrets

@mrdenny


Finding Storage Performance Problems in SQL Server

The first step is to understand the nature of performance monitoring software.

Are Too Many SQL Server Indexes Hurting Your Performance?

The question leads to an even more important question: do your users care?

Relational Database Engine: Doomed in a NoSQL World?

While NoSQL has taken over many of the duties that the relational database engine used to do, relying only on NoSQL could lead to some issues.

When Should You Create New SQL Server Indexes?

Here's how to spot when new indexes are needed to improve performance.

Exploring SQL Server's Distributed Transactions

Here's what you need to know about distributed transaction and when you should use one.

Using In-Memory OLTP Tables in SQL Server 2014

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features.

Troubleshoot Slow-Running Queries In SQL Server

Denny breaks down how to identify and fix speed issues in multiple versions of SQL Server.

Dealing with Negative Session ID Denials in SQL Server

Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error.

Subscribe on YouTube