In this episode, Warner and I discuss the announcements from Microsoft Data Amp, including Azure Managed Instance, Azure Data Migration Service, and SQL Server 2017.

The show notes can be found here: https://www.pythian.com/blog/datascape-podcast-episode-8-sql-server-2017-microsoft-data-amp/

Episode 8 - SQL Server 2017 and other announcements from Microsoft Data Amp

Joe Sack is a Principal Program Manager in the Azure SQL Database and SQL Server product team at Microsoft, with a focus on the Query Processor. Joe is an author and speaker with over 20 years of experience in the industry, specializing in performance tuning, high availability and disaster recovery.

Interviewer: Rajib Bahar, Shabnam Khan

Agenda:

RB - Your team created Adaptive Query Processing or QP. It is new in SQL Server 2017 and SQL Azure. As we know, SQL Server uses query plan internally to run tsql statements. Sometimes the plan chosen by the query optimizer is not optimal for reasons such as incorrect cardinal estimate and various other issues. What are some other pain points Adaptive QP is meant to cure?

SB - Adapative QP's strength lies behind Batch mode memory grant feedback, Batch mode adaptive joins, Interleaved execution... How do they work internally? 

RB - What are steps to enabling QP and some best practices? Can you tell us what's in the pipe line for upcoming enhancement? 

SB - How do we connect with you on Social Media?

Music: www.freesfx.co.uk

rajib.bahar

Joe Sack (@JoeSackMSFT) - Adaptive Query Processing in SQL Server 2017 Engine

In episode 293, Douglas Brown interviews Augie Gonzalez, Director of Product Marketing at DataCore Software. Augie and Douglas discuss DataCore’s new MaxParallel for Microsoft SQL Server solution to speed up database transactions using parallel processing.  Augie gives us a deep dive into the why, how, use cases and even a bit about the future of MaxParallel. Like with all DataCore solutions, this thing is fast and a must listen to podcast!  

About MaxParallel for Microsoft SQL Server

High-velocity transaction on processing and real-time analytics factor heavily in the viability of numerous commercial, research and military instructions. For many, the responsiveness of the SQL Server databases behind their critical apps shapes the organization’s effectiveness and competitive advantage. That’s true in e-Commerce, inventory optimization, forecasting/modeling and fraud/fault/threat detection, to name a few.

The difference between being too late and just in time often boils down to how quickly so ware can respond to inputs, update status and forecast future behaviors. Delays in any of these facets can be crippling. Clients become irritated, stock levels are mismanaged, fraud, faults and threats go undetected. Uncovering and eliminating the root causes can be quite challenging. DataCore can help.

Visit DataCore MaxParallel on the web at: www.maxparallel.com

Learn more: 

▪Try It Now: Trial Download and Azure Test Drive - https://www.datacore.com/resources/try-maxparallel-for-sql-server  
▪Data Sheet: MaxParallel for SQL Server - https://www.datacore.com/docs/default-source/whitepapers/english/maxparallel-for-sql-server-datasheet-letter.pdf?sfvrsn=2
▪Solution Brief: Responsive & Productive Database Apps with DataCore MaxParallel for SQL Server - https://www.datacore.com/docs/default-source/whitepapers/english/maxparallel-for-sql-server-solution-brief-letter.pdf?sfvrsn=2
▪IDC Analyst Report: DataCore MaxParallel ﻿for SQL Server: Making Latency-Sensitive OLTP and Analytics More Responsive and Productive - http://info.datacore.com/idc-tech-brief-maxparallel

About Augie Gonzalez

25 years developing and marketing advanced Information Technology products. Combine strong technical aptitude, broad industry background and sound business sense to uniquely synthesize concepts and value proposition for non-technical audiences. Very experienced at creating new product categories and building brand awareness through compelling images and messages. Led several expansions into new product lines and distribution channels. Articulate presenter and author. Strategic thinker, adept at working with executive management to introduce innovative practices and build key alliances. Equally comfortable instituting operational change as corporate ambassador spanning worldwide marketing, engineering, manufacturing, sales, finance, and customer services disciplines.

Follow Augie on Twitter at: https://twitter.com/augiegonzalez

sql

ma ku