SentryOne Team Blog

SentryOne EMEA: In the Media Spotlight

SentryOne was introduced to Irish media yesterday as one of 8 high growth companies creating new jobs in Ireland. The Department of Jobs, Enterprise and Innovation through IDA Ireland organized the event which included an address by Heather Humphreys, Minister for Business Enterprise and Innovation for Ireland. Welcoming the SentryOne announcement, Martin Shanahan CEO, IDA

Paul White : Row Goals Part 3 : Anti Joins

Paul White : Row Goals Part 3 : Anti Joins

Continuing his in-depth series on row goals, Paul White explains both why and how they can impact queries involving anti joins.

Speaking at Tech Outbound & My Ship Shape Challenge

Speaking at Tech Outbound & My Ship Shape Challenge

Jason Hall describes his professional and personal goals in advance of the next Tech Outbound event: a cruise in Alaska.

Speaking in March: Oregon, Colorado, and Georgia

Speaking in March: Oregon, Colorado, and Georgia

Join me at one of my March SQL Server presentations to live audiences in Oregon, Colorado, and Georgia. All events are free, but registration is required.

A Roundup from SQL Konferenz

A Roundup from SQL Konferenz

SentryOne Product Manager John Q. Martin recounts his experience at his very first SQL Konferenz event in Germany. Find out details around John's session and other highlights over the two days, along with why you should try to attend SQL Konferenz in the future.

Tech Outbound – Training on the High Seas.

Tech Outbound – Training on the High Seas.

Are you interested in learning about Data Platform technologies in a unique setting? John Martin recounts his experience on the Tech Outbound Caribbean cruise teaching, learning, and meeting great people who have a thirst for Data Platform knowledge and why you should take the chance to attend.

Glenn Berry : SQL Server and the Spectre/Meltdown Vulnerabilities

Glenn Berry : SQL Server and the Spectre/Meltdown Vulnerabilities

Glenn Berry explains how the Spectre/Meltdown issues (and their patches!) may affect SQL Server performance, and provides a handy list of mitigation steps to keep your servers protected.

Bad Habits Revival

Bad Habits Revival

Aaron Bertrand (@AaronBertrand) breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.

Photo credit: badgreeb_records

Paul White : Row Goals Part 2 : Semi Joins

Paul White : Row Goals Part 2 : Semi Joins

Continuing his series on row goals, Paul White explains how they can impact certain types of semi joins, and how you can spot these effects in showplan and trace flag output.

BI Sentry Adds Enhanced SSAS Tabular Support

BI Sentry Adds Enhanced SSAS Tabular Support

Steve Wright blogs about Enhanced Tabular support for SQL Server Analysis Services (SSAS) – a feature of the latest release of BI Sentry – offering BI professionals unparalleled insight into Multidimensional SSAS.

Call for Speakers at MusicCityTech Conference, 31-May to 02-June

Call for Speakers at MusicCityTech Conference, 31-May to 02-June

I'm organizing the data-centric track at this summer's MusicCityTech conference. We're looking for sessions covering traditional DBA topics, plus Analytics, Visualization, Design, database engineering, NoSQL topics, Big Data topics, Database coding best practices, AI, ML, and more.

Erin Stellato : Automatic Plan Correction in SQL Server

Erin Stellato : Automatic Plan Correction in SQL Server

Erin Stellato gives an overview of Automatic Plan Correction in SQL Server 2017 and Azure SQL Database, and assures us that Microsoft is not trying to code us out of jobs.

Seeing Memory Pressure Affect SQL Server Performance in SentryOne

Seeing Memory Pressure Affect SQL Server Performance in SentryOne

Allen shows how both internal and external memory pressure is reflected in the SentryOne dashboard, and how it affects server performance.

SentryOne Partner Spotlight: UpSearch

SentryOne Partner Spotlight: UpSearch

The SentryOne Global Partner Network is pleased to highlight UpSearch, our Partner Spotlight for this month. UpSearch is a company of data platform and analytics experts who exclusively support Microsoft’s technologies. As a Managed Microsoft Gold Partner (top 1%), UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB

T-SQL Tuesday #99: Missing Indexes and Index Key Order

T-SQL Tuesday #99: Missing Indexes and Index Key Order

Don't take SQL Server Missing Index recommendations at face value. They have numerous limitations. In this blog post, Andy Yun explores one of these: Index Key Order.