SentryOne Team Blog
Latest Builds of SQL Server 2017

Latest Builds of SQL Server 2017

Find out the build number of each SQL Server 2017 CTP as it is released, discover where to download, and how to get details on new fixes and features.

Latest Builds of Management Studio

Latest Builds of Management Studio

Find information about the builds of SQL Server Management Studio and SSDT in their new release cycle approach, and locate the latest build of SSMS for previous versions.

Latest Builds of SentryOne Software

Latest Builds of SentryOne Software

Latest builds of the SentryOne platform and Plan Explorer, as well as updated blog posts, downloads, and change lists.

Latest Builds of SQL Server 2014

Latest Builds of SQL Server 2014

SQL Server 2014 is now at Service Pack 2, with plenty of enhancements back-ported from recent SQL Server 2016 updates.

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.

Derik Hammer : Myths : Table variables are always in-memory

Derik Hammer : Myths : Table variables are always in-memory

Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.

Andy Mallon : What the heck is a DTU?

Andy Mallon : What the heck is a DTU?

Andy Mallon (@AMtwo) explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.

SQLBits: Is there an Echo in here?

SQLBits: Is there an Echo in here?

Richard Douglas (@SQLRich) describes our sessions at SQLBits, and explains why you should visit our booth for your chance to win an Amazon Echo!