Q&A with Scott Klein: SQL Server's Built-In Intelligence Features

Scott Klein, CTO at Cloud and Devices, explains how enterprises can leverage the built-in intelligence features of SQL Server 2017 to ensure DevOps pays off.

To take advantage of all the benefits of DevOps, organizations need to create and fine-tune database queries. Luckily, SQL Server 2017 has all the built-in diagnostics you need, along with intelligence built into the engine based on these diagnostics to help automate, learn and adapt.

Scott Klein, CTO, Cloud and Devices, is going to explain exactly how to take advantage of these capabilities at an upcoming session at the Visual Studio Live! conference at Microsoft Headquarters in Redmond, running August 13-17.

We caught up with Scott to find out what built-in features excite him the most, features that enterprises aren't taking advantage of but should, and more.

What's the No. 1 intelligence feature built into SQL Server 2017 that you're most excited about?
Tough one. I love the fact that it now runs on Linux is awesome, but there are so many to choose from. However, I love the automatic tuning. Great feature. Let SQL Server identify and performance problem and automatically fix it. Awesome.

And what's your second most favorite?
To me this is a tossup between Resumable online index rebuilds and the graph capabilities.

How do the features in SQL Server 2016 and SQL Server 2017 compare?
Microsoft really focused on key areas with 2017, such as performance and intelligence, but also added new features to MDS [Master Data Services] which we haven't seen in a while. A key feature is the ability to run it on the platform (OS) of your choice to open it up to other environments.

What features do enterprises not take advantage of that they really should be? Can you give a specific example of a feature that can help an enterprise's bottom line?
I'd like to see more enterprises using the Machine Learning Services. By adding Python and supporting leading machine learning algorithms, enterprises can extract useful information and get better insight into the data inside SQL Server. I think the challenge here is the learning curve.

"I'd like to see more enterprises using the Machine Learning Services. By adding Python and supporting leading machine learning algorithms, enterprises can extract useful information and get better insight into the data inside SQL Server."

Scott Klein, CTO, Cloud and Devices

In your upcoming session at Visual Studio Live! Redmond this August, you mention in your description that these tools are "the best in the industry" -- what makes you say so?
Simply because SQL Server is becoming intelligent. Prior to 2017, SQL Server could track performance issues, but not doing anything about it other than notify you and log it. With 2017, SQL Server not only identifies the problem, but will recommend fixes and automatically fix the identified problem. SQL Server learns about your workload and ensures that your data is always optimized for the best performance.

Are these features hard to implement?
Not at all. They are built in!

How important is it for the future of SQL Server that the features are cross-platform with Linux?
Absolutely vital. I think this is long overdue as it continues the evolution of SQL Server, bringing its capabilities to previously unknown environments, letting Linux-focused enterprises take advantage of SQL Server's enterprise capabilities.

What else about SQL Server 2017's built-in intelligence tools would you like to share with our audience?
SQL Server's Adaptive Query Processing is awesome, period. It allows the SQL Server query processor to intelligently modify play choices based on real-time runtime characteristics.

About the Author

Becky Nagel is the vice president of Web & Digital Strategy for 1105's Converge360 Group, where she oversees the front-end Web team and deals with all aspects of digital strategy. She also serves as executive editor of the group's media Web sites, and you'll even find her byline on, the group's newest site for enterprise developers working with AI. She recently gave a talk at a leading technical publishers conference about how changes in Web technology may impact publishers' bottom lines. Follow her on twitter @beckynagel.

comments powered by Disqus


  • What's New in Visual Studio 2019 v16.5 Preview 2

    The second preview of Visual Studio 2019 v16.5 has arrived with improvements across the flagship IDE, including the core experience and different development areas such as C++, Python, web, mobile and so on.

  • C# Shows Strong in Tech Skills Reports

    Microsoft's C# programming language continues to show strong in tech industry skills reports, with the most recent examples coming from a skills testing company and a training company.

  • Color Shards

    Sharing Data and Splitting Components in Blazor

    ASP.NET Core Version 3.1 has at least two major changes that you'll want to take advantage of. Well, Peter thinks you will. Depending on your background, your response to one of them may be a resounding “meh.”

  • Architecture Small Graphic

    Microsoft Ships Preview SDK, Guidance for New Dual-Screen Mobile Era

    Microsoft announced a new SDK and developer guidance for dealing with the new dual-screen mobile era, ushered in by the advent of ultra-portable devices such as the Surface Duo.

  • How to Create a Machine Learning Decision Tree Classifier Using C#

    After earlier explaining how to compute disorder and split data in his exploration of machine learning decision tree classifiers, resident data scientist Dr. James McCaffrey of Microsoft Research now shows how to use the splitting and disorder code to create a working decision tree classifier.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events