Category : SQL Server - SentryOne Team Blog

Category: SQL Server

New Webinar on SQL Server and VMware Performance

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.

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."

Announcing SQL Server 2017 Release Candidate

Microsoft announced the first release candidate (a.k.a. RC1) for SQL Server 2017 on Monday, July 17th. Release candidates are not a final and finished product, but they are feature complete. No new features are expected after Microsoft moves into the RC phase, only adding polish (for example, brushing up the documentation and UI) and performance

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.

Adaptive Query Processing in SQL Server 2017

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really want to focus on is adaptive query processing. These new features speed processing of workloads, especially those that have historically been the

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.

They Did it Again – The Release of SQL Server 2017

Not only has the Microsoft SQL Server engineering team added more and stronger leadership, outstanding individual engineers and staff members, but it is also radically moving its entire development process into a "cloud-first" ethos. Now, I'd like to show one of the most salient results of this new development process-accelerated product releases. It was only

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.

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!

A new series on performance-related SQL Server myths

A new series on performance-related SQL Server myths

Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.