Category : SQL Server - SentryOne Team Blog

Category: SQL Server

New Webinar on SQL Server and Vmware Performance

Microsoft MVP Kevin Kline and Charles Kim, founder of Viscosity North America talk about SQL Server running on Vmware in Ten Surprising Performance Killers on Microsoft SQL Server on this October 12th webinar.

Cool Features of SQL Server 2014: Improved Cardinality Estimates

COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality

Latest Builds of SQL Server 2016

Latest Builds of SQL Server 2016

See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

Ohio Meetups, September 5 to 7

Ohio Meetups, September 5 to 7

Join Kevin Kline as he traverses the Buckeye state September 5 – 7 and meets with SQL User Groups in Cleveland, Columbus and Cincinnati. Topics for Cleveland and Columbus: "Ten Query Tuning Techniques Every SQL Programmer Should Know." The Cincinnati topic is "SQL Server Internals and Architecture."

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.

Latest Builds of SQL Server 2012

Latest Builds of SQL Server 2012

SQL Server 2012 is now at Service Pack 3. Read this post to see what you should know before deploying.

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 SQL Server 2017

Latest Builds of SQL Server 2017

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

Michael J. Swart : Finding Database Connection Leaks

Michael J. Swart : Finding Database Connection Leaks

Michael Swart (@MJSwart) shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.

Slides & Video – Tales from Building a SQL Server DW in Azure

Slides & Video – Tales from Building a SQL Server DW in Azure

Melissa Coates of SentryOne shares slides, videos, and other resources from a recent webinar on building an Azure SQL Data Warehouse.

Slides and Scripts – SQL Server Internals and Architecture at Music City Code

Slides and Scripts – SQL Server Internals and Architecture at Music City Code

I had the pleasure of presenting my popular session, SQL Server Internals and Architecture, at the Music City Code conference.

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.

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.

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.

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.