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 former editorial director and director of Web for 1105 Media's Converge 360 group, and she now serves as vice president of AI for company, specializing in developing media, events and training for companies around AI and generative AI technology. She's the author of "ChatGPT Prompt 101 Guide for Business Users" and other popular AI resources with a real-world business perspective. She regularly speaks, writes and develops content around AI, generative AI and other business tech. Find her on X/Twitter @beckynagel.

comments powered by Disqus


  • GitHub Copilot for Azure Gets Preview Glitches

    This reporter, recently accepted to preview GitHub Copilot for Azure, has thus far found the tool to be, well, glitchy.

  • New .NET 9 Templates for Blazor Hybrid, .NET MAUI

    Microsoft's fifth preview of .NET 9 nods at AI development while also introducing new templates for some of the more popular project types, including Blazor Hybrid and .NET MAUI.

  • What's Next for ASP.NET Core and Blazor

    Since its inception as an intriguing experiment in leveraging WebAssembly to enable dynamic web development with C#, Blazor has evolved into a mature, fully featured framework. Integral to the ASP.NET Core ecosystem, Blazor offers developers a unique combination of server-side rendering and rich client-side interactivity.

  • Nearest Centroid Classification for Numeric Data Using C#

    Here's a complete end-to-end demo of what Dr. James McCaffrey of Microsoft Research says is arguably the simplest possible classification technique.

  • .NET MAUI in VS Code Goes GA

    Visual Studio Code's .NET MAUI workload, which evolves the former Xamarin.Forms mobile-centric framework by adding support for creating desktop applications, has reached general availability.

Subscribe on YouTube