SQL Server 2014 Unlock data insights Olaf Anzaldo Especialista Application Platform

Valor

La innovación tecnológica acelera el valor Machine learning In-memory Operational reporting Ad hoc analysis Transactional systems Complex implementations

ETL

OLAP

Any data

Internet of Things

Dashboards

Hadoop

Enterprise data warehouse

Spreadmarts Siloed data

Innovation

SQL Server evolucionó mucho desde 2005..

Seguridad avanzada: Microsoft es la base de datos menos vulnerable.

SQL Server evolucionó mucho desde 20015 Rendimiento crítico y en la nube

Management studio ● Creación de reflejo

SQL Server2005

AlwaysOn● Almacén de columnas en memoria ● Servicio de calidad de datos ● Power View ● Nube

SQL Server 2012

Cargas de trabajo en memoria ● Rendimiento & escala ● Optimizado para nube híbrida ● Servicio HDInsight ● Inteligencia empresarial en la nube

SQL Server 2014

Cual es el diferenciador de las empresas exitosas hoy en día? Datos.

¿Qué es Big Data? Internet of things Social Sentiment Click Stream

Exabytes (10E18)

Petabytes (10E15) Terabytes (10E12)

Volumen

Mobile Advertisin g

Payroll

Gigabytes (10E9)

Inventory

Audio / Video Log Files

WEB 2.0 eCommerce

ERP / CRM Payables

Wikis / Blogs

Sensors / RFID / Devices

Contacts Deal Tracking Sales Pipeline

Collaboration

Spatial & GPS Coordinates

Digital Marketing Search Marketing

Data Market Feeds eGov Feeds

Web Logs

Weather

Recommendation s

Text/Image

Velocidad - Variedad - Variabilidad

ERP / CRM Storage/GB

1980 190,000$

1990 9,000$

WEB 2.0

Internet of things 2000 15$

2010 0.07$

Microsoft’s approach delivers data dividends An end-to-end platform for any data and everyone Transform + analyze

Dat a

Visualize + decide

Collect + manage

Microsoft data platform

Collect + manage Collect and manage diverse data types with breakthrough speed Capture any data: structured, unstructured, and streaming

Transform + analyze

Dat a Collect + manage

Visualize + decide

Scale your platform quickly to meet changing demands Secure, reliable performance Increase speed across all your data workloads

Collect any data Harness the growing and changing nature of data Structured

Unstructured

Streaming

“”

Proven, leading relational database with new cloud NoSQL database capabilities Take advantage of unstructured big data with 100 percent Apache-based Hadoop capabilities Reduce the cost of analyzing and correlating streaming data

SQL Server – Integration Services

SQL Server Data Quality Services.

Perfilamiento de datos. Consolidación de conocimiento. Ejecución de proyectos Monitoreo de calidad.

SQL Server Master Data Services

Empoderamiento

Transform + analyze Transform and analyze data for anyone to access anywhere

Transform + analyze

Connect, combine, and refine any data

Dat a Collect + manage

Visualize + decide

Create data marts and publish reports Build and test predictive models Curate and catalog any data

Connect, combine, and refine any data Make sense of disparate data and prepare it for analysis Connect any data and all volumes in real time •  •  • 

Social data SAP and Dynamics data Machine data

Integration, Data Quality and Master Data Services •  •  • 

Rich support for ETL tasks Data cleansing and matching Manage master data structures

Analysis services •  •  • 

Single semantic model 100x faster analysis with in-memory columnstore Manage user-created BI content

Reporting services

•  •  • 

Create and publish interactive reports Consolidate reporting management Enable reporting capabilities for anyone

SQL Server Analysis Services Cubos dimensional

Tabular - En Memoria

Minería de Datos

Beneficios

Modelos de Análisis Multidimensional y Tabular. Multidimensional

Tabular (En memoria)

Almacenamiento

Cubo / Disco

Memoria

Tamaño

Terabytes

Gigabytes

Escalabilidad

Agregaciones

Infraestructura

Modelamiento

Desnormalizado Esquema Estrella

Normalizado Desnormalizado Esquema Estrella

Formulación

MDX

DAX

Modelo Semántico de BI

Modelo Semántico de BI Modelo de Datos

Multi-dimensional

Tabular

Lógica de Negocios y Consultas

MDX

DAX

Acceso a Datos

ROLAP

MOLAP

xVelocity inmemory

Direct Query

Visualize + decide Visualize data and make decisions quickly using everyday tools

Transform + analyze

Discover, explore, and combine any data type or size, regardless of location

Dat a Collect + manage

Visualize + decide

Ask questions of data to visualize, analyze, and forecast Make faster decisions, share broadly, and access insights on any device

Plataforma de Datos Microsoft

ü

Plataforma de Datos y Análiticos

3 ediciones– Standard, BI, Enterprise Opciones de licencia •  Basada en el núcleo •  Server + CAL

Diferencias: •  Administración de datos empresariales •  Autoservicio e inteligencia empresarial corporativa Diferencias: •  Seguridad avanzada •  Alta Disponibilidad con AlwaysOn •  Mejor Rendimiento en memoria

Edición de SQL Server 2014

Calcula la capacidad de las distintas ediciones Límites de capacidad del motor de base de datos

*1 ver notas

Límites de capacidad de Analysis Services y Reporting Services

*2 ver notas

Alto rendimiento: en memoria integrada

Scale your platform Easily scale to meet your data’s compute, storage, and cost demands

Physical and virtual scale

Massive scale out

Easy on-ramp to the cloud

Enterprise scale across compute, networking, and storage

Combine data warehousing with enterprise-ready Hadoop

Connect SQL Server to the Microsoft Azure cloud for backup, disaster recovery, and new cloud applications

Up to

640

6 petabytes

logical processors

linear scale out

Over

1 million Azure SQL Databases

Real-time speed Drive your business in real time with in-memory technology

Faster transactions

Faster queries

Faster insights

Improve data-intensive app performance on existing hardware

Easily explore massive data volumes for insights

Accelerate time to insight to help anyone make faster data-driven decisions

Up to

30X faster transactions

Up to

100x query speed

Analytics for

1B

Office users

Drive real-time business with real-time insights Faster transactions Faster queries Faster insights All built-in to SQL Server 2014.

30

Drive real-time business with real-time Faster queries Faster insights Faster insights IN-MEMORY DW IN-MEMORY ANALYTICS transactions IN-MEMORY OLTP

Millions of rows per second with PowerPivot in-memory for Excel

Up to 30x faster transaction processing and 90% compression gains with in-memory OLTP

Over 100x query speed and significant data compression with in-memory ColumnStore

Greater performance with in-memory Analysis Services

31

The journey to complete inmemory 2008 R2

PowerPivot in-memory for Excel

2012

2014

PowerPivot in-memory for Excel

PowerPivot in-memory for Excel

Analysis Services in-memory

Analysis Services in-memory

In-memory ColumnStore

Enhanced in-memory ColumnStore In-memory OLTP In-memory in the cloud 32

Key trends impacting in-memory design Decreasing cost of memory $/GB of memory 1,000,000  

CPU performance flattening out 10,000,000 1,000,000 100,000

10,000  

10,000 1,000

1,000  

100 100   10 10   1 1  

1990   1991   1992   1993   1994   1994   1995   1996   1997   1998   1999   2000   2000   2001   2002   2004   2005   2007   2008   2009   2011  

US$/GB    

100,000  

0 1970

1975

1980

1985

1990

1995

2000

2005

2010 33

Built-in Increased speed & throughput Flexible Accelerated queries and analytics Easy to implement 34

Drive real-time business with real-time insights

Speed insights across all data, with SQL Server on premises or in Windows Azure In-memory OLTP Up to 30x faster PowerBI for Office 365 Better business decision, faster

In-memory DW Over 100x faster In-memory Analytics Millions of rows in seconds

Firewall 35

Easy in-memory implementation Key benefits Easy to move apps

New in-memory migration advisor tools Table migration

Stored procedure migration

Use existing hardware No new skills—it’s just SQL

“

SQL Server 2014 helps us scale our system without doing any significant code changes, so there’s a host of development work we don't have to do.

”

- Phil Grayson, TPP

Eas y

Migration

of existing tables and no significant changes required

7x

performance enables near real-time access

faster

36

Inventory changes

Mobile data

Real-time purchasing trends

SQL Server 2014

Current events

Imagine a new level of customer personalization by acting on a world of data in real-time

Social sentiment Market demand

38

SQL Server 2014

Imagine a new level of customer personalization by acting on a world of data in real-time