SentryOne Team Blog
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!

SentryOne Advisory Conditions for Monitoring SSAS Performance

SentryOne Advisory Conditions for Monitoring SSAS Performance

Steve Wright (@SQL_Steve) explains a hefty set of Advisory Conditions you can add to SentryOne to help you monitor, diagnose, and optimize SSAS performance.

Disco and Cortana Intelligence Suite at SQLBits 2017

Disco and Cortana Intelligence Suite at SQLBits 2017

Join us at SQLBits for a technical overview of Cortana Intelligence Suite, including the purpose and use cases for each component.

Getting Real at SQLBits

Getting Real at SQLBits

Allen White will be showing how to build near real-time ETL processes at SQL Bits using Service Broker.

Staying Alive at SQLBits 2017

Staying Alive at SQLBits 2017

Kevin Kline talks about the upcoming SQLBits conference, the sessions he's giving and, most importantly, the DISCO THEME!

SQLBits 2017 : We Have Disco

SQLBits 2017 : We Have Disco

Aaron Bertrand (@AaronBertrand) reminds everyone about the amazing lineup, learning, and fun to be had at SQLBits 2017 in Telford, UK.

Back to SQLBits

Back to SQLBits

Scott Fallen (@ScottFallen) invites you to join SentryOne at SQLBits 2017, from the 5th to 8th of April.

Building Bridges in Telford with SQLBits

Building Bridges in Telford with SQLBits

Join John and the SentryOne team at SQLBits in Telford this April. With several top speakers and a myriad of sessions, SentryOne will be attending once more.

Resolving Key Lookup Deadlocks with Plan Explorer

Resolving Key Lookup Deadlocks with Plan Explorer

Greg Gonzalez (@SQLsensei) uses Plan Explorer to walk through troubleshooting a very common type of deadlock : updates conflicting with key lookups.

Glenn Berry : Choosing a Processor for SQL Server 2016 Standard Edition

Glenn Berry : Choosing a Processor for SQL Server 2016 Standard Edition

Glenn Berry (@GlennAlanBerry) explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.

Performance Myths : Clustered vs. Non-Clustered Indexes

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

My First PowerShell : A Simple Story with Dramatic Flair

My First PowerShell : A Simple Story with Dramatic Flair

Melissa Connors (@MelikaNoKaOi) walks through and discusses lessons learned from her first PowerShell script, which restarts a range of remote computers.

What’s Up in the SentryOne Cloud

What’s Up in the SentryOne Cloud

Find out what new features have been released for the SentryOne Cloud, including a new Performance Dashboard!