SentryOne Team Blog
Slides and Samples from SQLintersection

Slides and Samples from SQLintersection

Aaron Bertrand shares his slide decks and other materials from his presentations at SQLintersection in Orlando.

Jonathan Kehayias : Troubleshooting CPU Performance on VMware

Jonathan Kehayias : Troubleshooting CPU Performance on VMware

Jonathan Kehayias of SQLskills discusses SQL Server on VMware, and how to monitor CPU performance – with or without access to vCenter.

SQLskills Wait Types Library now shows SentryOne data

SQLskills Wait Types Library now shows SentryOne data

Paul Randal (@PaulRandal) explains how the SQLskills Wait Types Library uses anonymous data from SentryOne to indicate whether a wait type is commonly experienced.

Paul White : UNION ALL Optimization

Paul White : UNION ALL Optimization

Paul White (@SQL_Kiwi) digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL.

T-SQL Tuesday #90 : Shipping Database Changes

T-SQL Tuesday #90 : Shipping Database Changes

Aaron Bertrand (@AaronBertrand) recounts the way he implemented database changes in a distributed SQL Server system a decade ago.

SQLPerformance.com – same great content, new skin!

SQLPerformance.com – same great content, new skin!

Aaron Bertrand (@AaronBertrand) provides some details about the new look for SQLPerformance.com and some of the drivers behind the change.

Paul White : SQL Server Temporary Object Caching

Paul White : SQL Server Temporary Object Caching

Paul White (@SQL_Kiwi) describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.

Monica Rathbun : I/O Troubleshooting

Monica Rathbun : I/O Troubleshooting

Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.

I'm Speaking at SQL Saturday Edmonton #SQLSat594

I'm Speaking at SQL Saturday Edmonton #SQLSat594

Melissa Connors (@MelikaNoKaOi) discusses her upcoming trip to speak at SQL Saturday Edmonton and provides links to Data Compression posts and slides.

Paul White : Cardinality Estimation for a Predicate on a COUNT Expression

Paul White : Cardinality Estimation for a Predicate on a COUNT Expression

Paul White (@SQL_Kiwi) takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.

T-SQL Tuesday #89 : Roll with the Changes

T-SQL Tuesday #89 : Roll with the Changes

Aaron Bertrand (@AaronBertrand) explains why he isn't scared of the cloud, and why most of you shouldn't be, either.

Materials From SQLBits 2017

Materials From SQLBits 2017

Aaron Bertrand (@AaronBertrand) shares his slide decks and samples from his Friday sessions at SQLBits in Telford, UK.

Creating Advisory Conditions in SentryOne – Part 2 – The Examples

Creating Advisory Conditions in SentryOne – Part 2 – The Examples

Lori Edwards (@loriedwards) guides you through several examples of creating Advisory Conditions in SentryOne.

Visualizing Data Compression: See it for Yourself

Visualizing Data Compression: See it for Yourself

Melissa Connors (@MelikaNoKaOi) explains how visualizing data compression (through DBCC PAGE) helps you better understand SQL Server compression methods.