What is new in PASS Summit 2014

• About PASS Summit – schedule, events

• Keynotes

• What is new

1

PASS Summit Schedule

Date:

• Late October /Early November

Sessions:

• Monday – Tuesday: Preconference sessions

• Wednesday – Friday: Summit sessions

2

After hour events

• Tuesday night: Welcome Reception

• Wednesday night: Vendor Reception

• Thursday night: Appreciation Party

3

Keynotes

• Wednesday morning keynote:

• PASS financial update and board changes

• SQL Server Release/feature announcement

• Marketing talk about future direction

• Thursday morning keynote:

• In-depth tech talk: features Dr Rimma Nehme

(Dr Dewitt)

4

Day 1 Keynote: Microsoft Data Platform

5

Day 2 Keynote: Cloud DB

6

Day 2 Keynote: Cloud DB Options

7

Cloud DB v.s. Earthed DB

8

What’s new

• Azure Document DB

• Azure Stream Analytics

• Azure Machine Learning

• Query Store

9

Azure Document DB

A fully-managed, scalable, NoSQL document

database service

• Fully-managed document database-as-a-service

with rich query and indexing capabilities over a

schema-free JSON data model.

• Offers configurable and reliable performance,

native JavaScript transactional processing, and is

built for the cloud with elastic scale.

10

Azure Stream Analytics

A fully managed service providing low latency,

highly available, scalable complex event processing

over streaming data in the cloud.

11

Azure Machine Learning

• Powerful cloud-based predictive analytics

• Fully managed: No hardware or software to buy

• Integrated: Drag, drop and connect

• Best in Class Algorithms: Proven solutions from

Xbox & Bing

• R Built In: Use over 350 R packages or bring

your own R code

• Deploy in Minutes: Operationalize with a click

12

Session highlights

SQL Server 2014 feature on Statistics Update

• Default auto update statistics after 20% change, which is not helpful

to VLDB

• Trace flag 2371 change the behaviour

13

Favourite talk: multiple purpose SP

Problem:

• Google style search on multiple columns

• LastName, FirstName, SIN, Other Identifiers

SP Code:

Select …

From Person

Where (@LastName is null or LastName = @LastName)

And (@FirstName is null or FirstName = @FirstName)

And …

If the first execution is on @LastName then the execution plan is built based on index

on LastName, the execution plan doesn’t work for other searches

14

Favourite talk: multiple purpose SP

Solution:

• Dynamic SQL

• Depends on whether the search is specific

enough

• Use SP_ExecuteSQL if no recompile is required

• Use Exec(@Stmt) if recompile would be better

15

PASS TV

1

6