sqlsathistory

Nr: 405

Back to Main list

SQLSaturday #405 - Buenos Aires 2015

Start Time (24h)	Speaker	Track	Title
10:00:00	Maximiliano Damian Accotto	Administración Deployment	SQL en ambientes virtuales
10:00:00	Adrian Fernandez	Plataforma de Desarrollo y BI	Big Data and Microsoft Azure
11:10:00	Javier Villegas	Administración Deployment	SQL Monitoring
11:10:00	Alejandro Cabanchik	Plataforma de Desarrollo y BI	Power Query
12:20:00	Maximiliano Damian Accotto	Administración Deployment	Tuning avanzado para DBa#180;s
12:20:00	Carlos L Chacon	Plataforma de Desarrollo y BI	Juez, Jurado Y Verdugo--Una Primera Observaci#243;n de Planes de Eje
14:30:00	Carlos L Chacon	Administración Deployment	"I Know What You Did Last Query" --SQL Server
14:30:00	Alejandro Cabanchik	Plataforma de Desarrollo y BI	Mobile BI with Datazen
15:40:00	Adrian Fernandez	Plataforma de Desarrollo y BI	Microsoft Azure and Internet of Things (IoT)
15:40:00	Gustavo Boismoreau	Administración Deployment	Administre, Diagnostique y Resuelva problemas sobre su SQL Server
16:50:00	Maximiliano Damian Accotto	Administración Deployment	SQL Server 2014 Cardinaly Estimator
16:50:00	Alejandro Cabanchik	Plataforma de Desarrollo y BI	DAX in Action

SessionID: 19885

SQL en ambientes virtuales

Back to calendar

Event Date: 22-05-2015 - Session time: 10:00:00 - Track: Administración Deployment

Speaker: Maximiliano Damian Accotto

Title: SQL en ambientes virtuales

Abstract:

Como instalar y configurar una instalacion de SQL Server de carga en ambientes virtualizados

SessionID: 36739

Big Data and Microsoft Azure

Back to calendar

Event Date: 22-05-2015 - Session time: 10:00:00 - Track: Plataforma de Desarrollo y BI

Speaker: Adrian Fernandez

Title: Big Data and Microsoft Azure

Abstract:

I’m going to talk about Big Data concepts, Hadoop and main components.

Next, I’ll introduce the Lambda Architecture. This is community driven architecture that helps provide a framework for how various Big Data components work together for specific scenarios. I’ll also show how to works in Microsoft Big Data Analytics platform components Azure HDInsight cl#250;ster over Windows, Linux and Machine Learning concepts.

SessionID: 15999

SQL Monitoring

Back to calendar

Event Date: 22-05-2015 - Session time: 11:10:00 - Track: Administración Deployment

Speaker: Javier Villegas

Title: SQL Monitoring

Abstract:

Custom procedures to monitor sql performance

Extended Events DBA Dashboard

SessionID: 36925

Power Query

Back to calendar

Event Date: 22-05-2015 - Session time: 11:10:00 - Track: Plataforma de Desarrollo y BI

Speaker: Alejandro Cabanchik

Title: Power Query

Abstract:

Introduction to Power Query

SessionID: 19884

Tuning avanzado para DBa#180;s

Back to calendar

Event Date: 22-05-2015 - Session time: 12:20:00 - Track: Administración Deployment

Speaker: Maximiliano Damian Accotto

Title: Tuning avanzado para DBa#180;s

Abstract:

Optimizaci#243;n de SQL Server 2008R2 / 2012 y 2014 avanzado

SessionID: 35627

Juez, Jurado Y Verdugo--Una Primera Observaci#243;n de Planes de Eje

Back to calendar

Event Date: 22-05-2015 - Session time: 12:20:00 - Track: Plataforma de Desarrollo y BI

Speaker: Carlos L Chacon

Title: Juez, Jurado Y Verdugo--Una Primera Observaci#243;n de Planes de Eje

Abstract:

Cuando SQL Server recibe una consulta, un plan de ejecuci#243;n es lo que acepta el T-SQL y produce los datos. Esta charla sirve como una introducci#243;n a como se puede leer y entender los planes. Repasaremos la t#233;cnicas que podemos hacer para mejorar el rendimiento de las consultas. Miriamos al ganador del concurso SQLCruise 2013 'Hairy Execution Plan'. http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/ This session will be in Spanglish.

SessionID: 35626

"I Know What You Did Last Query" --SQL Server

Back to calendar

Event Date: 22-05-2015 - Session time: 14:30:00 - Track: Administración Deployment

Speaker: Carlos L Chacon

Title: "I Know What You Did Last Query" --SQL Server

Abstract:

Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings. This information is available via Dynamic Management View and functions and officially they "return internal, implementation-specific state data." This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment. We also open up the floor for ideas of how you are using these views/functions. This session will be in Spanglish.

SessionID: 36926

Mobile BI with Datazen

Back to calendar

Event Date: 22-05-2015 - Session time: 14:30:00 - Track: Plataforma de Desarrollo y BI

Speaker: Alejandro Cabanchik

Title: Mobile BI with Datazen

Abstract:

Introduction to Datazen

SessionID: 36740

Microsoft Azure and Internet of Things (IoT)

Back to calendar

Event Date: 22-05-2015 - Session time: 15:40:00 - Track: Plataforma de Desarrollo y BI

Speaker: Adrian Fernandez

Title: Microsoft Azure and Internet of Things (IoT)

Abstract:

I present a prototype which performs the "Measurement and temperature display in real-time using Open Hardware and Microsoft Azure" the project describes how to use different types of sensors, microcontroller devices to connect and send burst data to the internet Azure cloud to analyze and visualize the resulting data streams in real time, using new concepts such as Big

data, Internet of Things (IoT), Stream Analytcs and Open Hardware.

SessionID: 37114

Administre, Diagnostique y Resuelva problemas sobre su SQL Server

Back to calendar

Event Date: 22-05-2015 - Session time: 15:40:00 - Track: Administración Deployment

Speaker: Gustavo Boismoreau

Title: Administre, Diagnostique y Resuelva problemas sobre su SQL Server

Abstract:

Funcionalidades en Toad y SOSSE

SessionID: 19886

SQL Server 2014 Cardinaly Estimator

Back to calendar

Event Date: 22-05-2015 - Session time: 16:50:00 - Track: Administración Deployment

Speaker: Maximiliano Damian Accotto

Title: SQL Server 2014 Cardinaly Estimator

Abstract:

Impactos en la performance por el nuevo CE, como configurar la instancia, que cuidados tener, como configurar las consultas

SessionID: 9201

DAX in Action

Back to calendar

Event Date: 22-05-2015 - Session time: 16:50:00 - Track: Plataforma de Desarrollo y BI

Speaker: Alejandro Cabanchik

Title: DAX in Action

Abstract:

See the power of Data Analysis Expression (DAX) language in PowerPivot and Analysis Services Tabular.

This site is open source. Improve this page.