Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.
UPDATE November 17th, 2018 – Microsoft has pulled several patches for older versions of SQL Server. If you need TLS 1.2 support and can't move to a formally supported version, your recourse is to contact Microsoft support.
The complexity of navigating the latest data privacy regulations represents an opportunity for your business, as a Managed Service Provider (MSP), to add value for your clients by advising them on best practices and implementing optimal solutions in the data systems you manage to ensure compliance.
Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.
SentryOne Data Scientist Fred Frost shares some of the conceptual details of the development of SentryOne Storage Forecasting. Get a first-hand look at the work that went into making these models useful and trustworthy.
Kevin Kline shares highlights from the PASS Summit 2018 keynote with Raghu Ramakrishnan.
Kevin Kline shares highlights from Rohan Kumar's PASS Summit 2018 keynote, "SQL Server and Azure Data Services: Harness the future with the ultimate hybrid platform for data and AI."
The newly released SentryOne 18.5 includes the first feature set to utilize advanced analytics and machine learning technology—introducing SentryOne Storage Forecasting. SentryOne Director of Analytics Steve Wright shares how you can access and customize storage capacity forecasts in SentryOne.
Learn about this HUGE opportunity to influence the Microsoft Data Platform products and services you use daily while attending the PASS Summit!
SentryOne provides data performance monitoring for Amazon RDS that goes beyond Amazon CloudWatch's capabilities. SentryOne partners, find out how our Amazon RDS monitoring can help you better support your clients' complex hybrid SQL Server environments and cloud migrations.
Product Manager Aaron Bertrand talks about the two improvements in the latest version of SentryOne Plan Explorer, 18.5.1.
Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.
Check out the new Tableau Report Pack for SentryOne Monitoring, a free set of reports that you can use in Tableau Desktop or deploy to Tableau Server to visualize, present, and distribute information from SentryOne to your business users.
Tim Radney talks about some of the things you can do to prepare for the end of extended support for SQL Server 2008 and SQL Server 2008 R2.
Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.