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.
Allen White blogs about one of the great benefits of SQL Sentry: it presents you with an overall picture of the server's performance, allowing you to see what's going on as a whole, and then allowing you to drill into the areas that may be of concern.
Kevin Kline describes a new Webinar featuring Sabin IO. If you're a DBA who must remedy poor performance on a SQL Server, or a Developer responsible for writing fast and dependable code, then you'll want to attend this session.
MS MVP Kevin Kline walks through two ways to prepare for a peaceful and uninterrupted holiday: technology and process. The former involves things we can do with our databases to make our lives easier while away from the office, while the latter are steps we can take in advanced to reduce the need for our coworkers to call us.
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
Devon Leann Wilson joins the SentryOne blogging team with this reflection for #tsql2sday and a shout out to the folks who are still making a difference in her SQL Server career.
Lori Edwards shares about "Folks Who Have Made a Difference" in this T-SQL Tuesday blog post.
Did you know 15,000 people are registered for Tableau Conference 2017 (TC17)? I didn’t realize this until I was talking to some of the folks at Tableau who use the SentryOne (S1) platform to keep their SQL Servers running at peak performance. We are in the throes of compiling a case study with Tableau about […]
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.
Jason Hall shares highlights from SQLSaturday #667 – Oslo
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."
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 Swart (@MJSwart) shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.
Melissa Coates of SentryOne shares slides, videos, and other resources from a recent webinar on building an Azure SQL Data Warehouse.
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 […]