sqlsathistory

Nr: 189

Back to Main list

SQLSaturday #189 - Costa Rica 2013

Start Time (24h) Speaker Track Title
00:00:00 Carlos L Chacon Track 4 SQL Server--En juego or Fuera de juego?
00:00:00 César Oviedo Track 3 SQL Server 2012 - Data Mining
00:00:00 César Oviedo Track 3 Data Visualization: PowerView
00:00:00 Carlos Rojas Vargas Track 4 Security in Contained Databases in SQL-Server 2012
00:00:00 David Sánchez Aguilar Track 3 SharePoint Access Services 2013 y SQL Server 2012
00:00:00 David Dye Track 1 Dealing With Errors in SSIS 2012
00:00:00 David Dye Track 1 Whats New in T-SQL With SQL Server 2012
00:00:00 Eduardo Castro Track 3 Modelos de BI Tabulares
00:00:00 Frank Quintana Track 2 OLTP, OLAP, las Lenguas y paradigmas en BIDS
00:00:00 Juan Alvarado Track 3 Excel 2013 como herramienta de BI
00:00:00 Juan Alvarado Track 3 Conociendo lo nuevo del Stack de BI de Microsoft
00:00:00 Jeff Prom Track 2 Master Data Services
00:00:00 Jeff Prom Track 2 Data Quality Services
00:00:00 Jesus Gil Velasco Track 4 BI en dipositivos moviles
00:00:00 Jesus Gil Track 4 Mil maneras de morir
00:00:00 Javier Loria Track 1 Es TEMPDB, por qué es tan importante?
00:00:00 Ricardo Estrada Track 2 *Las mejoras + importantes en Código de SQL 2012
00:00:00 Russell Fustino Track 4 Building a Windows 8 app from scratch (English)
00:00:00 Salomon Henriquez Track 4 SQL Azure para principiantes
00:00:00 Kevin Boles Track 1 Windowing Functions: THE Reason to Upgrade to 2012
00:00:00 Kevin Boles Track 1 Transaction Log Deep Dive
00:00:00 Kenneth Urena Track 2 Particionamiento y BD Parciales HA para VLDB
00:00:00 Andy Leonard Track 1 Creating a Custom SSIS 2012 Task

SessionID: 11176

SQL Server--En juego or Fuera de juego?

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Carlos L Chacon

Title: SQL Server--En juego or Fuera de juego?

Abstract:

Esta presentación se concentra en los pasos que se puede tomar para determinar el buen funcionamiento del SQL Server y donde debe enfocarse para optimizarlo. Revisamos las herramientas y scripts que están disponibles sin costo en la comunidad SQL para que no tenga la necesidad de comprarlas . Se da más énfasis en los índices.

SessionID: 11379

SQL Server 2012 - Data Mining

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: César Oviedo

Title: SQL Server 2012 - Data Mining

Abstract:

En esta sesión se abarcarán los algoritmos y herramientas que brinda el SQL Server 2012 para la Minería de Datos.

SessionID: 11380

Data Visualization: PowerView

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: César Oviedo

Title: Data Visualization: PowerView

Abstract:

La Inteligencia de Negocios es una de los áreas más importantes en las corporaciones ya que brinda soporte para la toma de decisiones, y es indispensable que los usuarios puedan sacar provecho de esta información. Power View permite la visualización rápida y fácil de sus datos, además que permite compartir y colaborar sus análisis estadísticos en un entorno familiar como lo es SharePoint y Excel.

SessionID: 12047

Security in Contained Databases in SQL-Server 2012

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Carlos Rojas Vargas

Title: Security in Contained Databases in SQL-Server 2012

Abstract:

Easy Administration of Security with Contained Databases in SQL-Server 2012

SessionID: 12851

SharePoint Access Services 2013 y SQL Server 2012

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: David Sánchez Aguilar

Title: SharePoint Access Services 2013 y SQL Server 2012

Abstract:

En esta sesión veremos lo nuevo de SharePoint Access Services 2013 integrado con SQL Server 2012.

SessionID: 12922

Dealing With Errors in SSIS 2012

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: David Dye

Title: Dealing With Errors in SSIS 2012

Abstract:

This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.

SessionID: 12923

Whats New in T-SQL With SQL Server 2012

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: David Dye

Title: Whats New in T-SQL With SQL Server 2012

Abstract:

This session covers the new features and functions introduced to T-SQL in SQL Server 2012. Our time will be spent reviewing enhancements to T-SQL specifically for SQL Server 2012 with attention to demonstrations and code samples. This is a basic session, but ttendees should have a general knowledge of T-SQL.

SessionID: 13618

Modelos de BI Tabulares

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Eduardo Castro

Title: Modelos de BI Tabulares

Abstract:

En sesión veremos las bases de datos tabulares en SQL Server 2012, se verán las herramientas para creación de cubos tabulares tales como SQL Server Data Tools, Analisis Services, PowerPivot y PowerView. Además de cuáles son los casos en los cuales es mejor utilizar el modelo Tabular

SessionID: 14313

OLTP, OLAP, las Lenguas y paradigmas en BIDS

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Frank Quintana

Title: OLTP, OLAP, las Lenguas y paradigmas en BIDS

Abstract:

Con BIDS somos capaces de responder a preguntas en dos mundos contradictorios el OLTP (Procesos de Transacciones en Líneas) y el OLAP (Procesos de Análisis en Líneas) con el fin de responder a las interrogantes en estas dos configuraciones de OLAP y OLTP, BIDS incluyese tres servicios SSIS, SSRS y SSAS y una variedad de lenguajes como SQL, T-SQL, MDX, DMX, etc.

Es prácticamente imposible explicar cada aspecto de cada una de las herramientas que forman parte de BIDS (Data base Tools) en una presentacion. Así que en esta presentación intentamos explicar la esencia de estos tres servicios y de las lenguas usadas en BIDS desde la perspectiva de los problemas que están tratando de resolver

SessionID: 15532

Excel 2013 como herramienta de BI

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Juan Alvarado

Title: Excel 2013 como herramienta de BI

Abstract:

En esta charla se analizara el uso de excel 2013 como herramienta de analisis de infromacion. Se veran demos de powerpivot , power view y las nuevas carateristicas de accesos a cubos.

SessionID: 15533

Conociendo lo nuevo del Stack de BI de Microsoft

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Juan Alvarado

Title: Conociendo lo nuevo del Stack de BI de Microsoft

Abstract:

En esta charla se analizara las diferentes opciones que Microsoft tiene para analisis de informacion y nuevas caracteristicas de SQL 2012 , Sharepoint 2013 y office 2013

SessionID: 16360

Master Data Services

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Jeff Prom

Title: Master Data Services

Abstract:

Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate.

In this session we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.

SessionID: 16361

Data Quality Services

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Jeff Prom

Title: Data Quality Services

Abstract:

As the old adage goes, 'Garbage in, garbage out.' Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.

SessionID: 16697

BI en dipositivos moviles

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Jesus Gil Velasco

Title: BI en dipositivos moviles

Abstract:

Todos quieren BI, todos decimos que sabemos entregar BI, pero ¿en medios móviles como lo estas entregando?

Ven y aprende sobre como mostrar y como se ve tu BI en dispositivos móviles

SessionID: 16759

Mil maneras de morir

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Jesus Gil

Title: Mil maneras de morir

Abstract:

¿Cómo puedes matar a tu servidor?

Malas prácticas Malas consultas Esta sesión te contará leyendas urbanas, historias reales e historias de terror No te pierdas esta oportunidad de saber ¿cómo puedes evitarlo?

SessionID: 16944

Es TEMPDB, por qué es tan importante?

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Javier Loria

Title: Es TEMPDB, por qué es tan importante?

Abstract:

TEMPDB es solo para datos temporales cierto o no? Se crea por defecto y se recrea cada vez que se reinicia SQL Server, entonces no debería ser importante, ESTO ES INCORRECTO. En esta sesión aprenderá sobre los aspectos internos de TEMPDB y por qué TEMPDB es importante. Se verán las mejores prácticas para configurar TEMPDB y cómo determina si hay centención. Si usted tiene sistemas en los cuales no se configurado TEMPDB entonces debe asistir a esta sesión.

SessionID: 22304

*Las mejoras + importantes en Código de SQL 2012

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Ricardo Estrada

Title: *Las mejoras + importantes en Código de SQL 2012

Abstract:

En esta sesión ejecutaremos algunas funciones nuevas de SQL de gran utilidad en el día a día que disminuyen líneas de código y aceleran el proceso de desarrollo.

SessionID: 23607

Building a Windows 8 app from scratch (English)

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Russell Fustino

Title: Building a Windows 8 app from scratch (English)

Abstract:

See how to build your first Windows 8 app. We will use what I learned when creating the app: .NET Gurus Can Cook, which contains recipes from famous folks in the software industry such as Scott Hanselman and Mary Jo Foley. Join ComponentOne Developer Evangelist and former Microsoft Developer Evangelist, Russ Fustino in this session and learn the new programming paradigm for creating Windows 8 style apps. You will see how to build an application that incorporates many of the key characteristics of a great Windows 8 style app, including:

SessionID: 23811

SQL Azure para principiantes

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Salomon Henriquez

Title: SQL Azure para principiantes

Abstract:

THis is a topci I would like to cver in order to show people who is beginning with SQl Azure what SQl Azure realy is, the power and benefits of this tool and most important in order to make people do not be afraid when they face SQl Azure

SessionID: 26243

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 26244

Transaction Log Deep Dive

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: Transaction Log Deep Dive

Abstract:

Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.

SessionID: 27184

Particionamiento y BD Parciales HA para VLDB

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Kenneth Urena

Title: Particionamiento y BD Parciales HA para VLDB

Abstract:

Estrategia de Respaldos + Particionamiento + Arquitectura en SQL Server Enterprise Edition para obtener escenarios de alta disponibilidad en bases de datos Muy Grandes.

SessionID: 9519

Creating a Custom SSIS 2012 Task

Back to calendar

Event Date: 13-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Andy Leonard

Title: Creating a Custom SSIS 2012 Task

Abstract:

Are you tired of copying and pasting .Net code into Script Tasks? In this presentation, Andy Leonard walks you through creating a custom SSIS task using Visual Studio. Learn how and why to build custom SSIS tasks. Discover tips and tricks for building custom tasks as Andy demonstrates common mistakes and pitfalls.

This site is open source. Improve this page.