Nr: 283
SQLSaturday #283 - Puerto Rico 2014
SessionID: 10150
Inside the Query Optimizer
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Bradley Ball
Title: Inside the Query Optimizer
Abstract:
When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.
SessionID: 11188
SQL Server - En juego o Fuera de juego?
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Carlos L Chacon
Title: SQL Server - En juego o 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 .
SessionID: 13023
Location Location Location Preparing and Presenting Geographic Data
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: David Dye
Title: Location Location Location Preparing and Presenting Geographic Data
Abstract:
Most all databases have some kind of geographic data and geographic reporting requirements. This session focuses on how to prepare and validate your geographic data, provide latitude and longitude, implement the GEOGRAPHY SQL data type, and finally present your data using Power Map and SSRS. An overview of each step will be given as well as in depth real life examples.
SessionID: 13610
MsAccess and SQLServer in the Cloud Integration
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Edwin Blancovitch
Title: MsAccess and SQLServer in the Cloud Integration
Abstract:
Users will be able to create a small access database, connect to the cloud and see their access working in the cloud.
SessionID: 14855
Introduction to SSIS with BIML
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Guillermo Caicedo Santiago
Title: Introduction to SSIS with BIML
Abstract:
Do you ever find yourself repeating the same steps over and over while developing ETL packages? BIML is an XML markup language that automates your BI patterns and reduces the manual repetition that consumes most of your development time. In this session we will learn the basics of BIMLScript and show you the benefits of creating and automating an SSIS framework.
SessionID: 16027
Business Insight through Cloud Based Data Models
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Javier Guillen
Title: Business Insight through Cloud Based Data Models
Abstract:
It is common for power users and data scientists to start mocking up their analysis in Excel. As their reporting grows in sophistication, however, it is important to understand the options available to enable increasingly robust analytical capabilities without incurring high infrastructure costs during experimentation phases.
This session will explore promotion paths for PowerPivot models that mature to demand robust data transformations, as well as cleansing and master data procedures. You will learn the pros and cons of using cloud-based PowerPivot environments, as well as the recommended architectures for model growth.
SessionID: 16107
PowerPivot + Powerview + PowerMap = Self-service BI Revolution
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jose Chinchilla
Title: PowerPivot + Powerview + PowerMap = Self-service BI Revolution
Abstract:
SessionID: 17414
Azure Virtual Machines: A Walk in the Cloud
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Jorge Segarra
Title: Azure Virtual Machines: A Walk in the Cloud
Abstract:
Now that Windows Azure virtual machines are generally available to the public, how does this offering affect you? In this session we'll review this offering, walkthrough creating and deploying a virtual machine with SQL Server on it. We'll also discuss how you can leverage this offering to your existing infrastructure!
SessionID: 17467
Tablas Particionadas: De la A a la Z
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Jose L. Rivera
Title: Tablas Particionadas: De la A a la Z
Abstract:
SessionID: 17599
SQL Server 2014 In Memory Column Store Indexes - Haciendo un Almacén de Datos
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jose Gregorio Redondo Lopez
Title: SQL Server 2014 In Memory Column Store Indexes - Haciendo un Almacén de Datos
Abstract:
Las características "In Memory" es la tendencia más de perspectiva en el área de alto rendimiento. Los Índices de ColumnStore es uno de las tales características, y aún con sus limitaciones, pueden aceleran a veces sus consultas! ¿Cómo obtener más de esta característica? ¿En qué situaciones debemos usarlos? ¿Qué mecanismos internos ayudan a lograr eso? Usted puede obtener respuestas a estas y otras preguntas que se haya generado en algún momento en esta sesión.
SessionID: 17625
Creating Reporting Services Reports to be Run in SQL Server Management Studio
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jorge Sanchez
Title: Creating Reporting Services Reports to be Run in SQL Server Management Studio
Abstract:
SessionID: 17670
Wish you could live the glamorous consulting life?
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Juan Soto
Title: Wish you could live the glamorous consulting life?
Abstract:
Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way.
In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out. Y
SessionID: 19916
Powershell Working with Windows Azure SQL Database Server
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Maximo Trinidad
Title: Powershell Working with Windows Azure SQL Database Server
Abstract:
In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)
SessionID: 20509
From Mess to Mastery: Managing Large Environments
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Mike Hillwig
Title: From Mess to Mastery: Managing Large Environments
Abstract:
IT veteran Mike Hillwig will show you how some of the integrated tools within SQL Server can help you manage your environment without spending a ton of money. We'll look at the Central Management Server, Management Data Warehouse, Multi-Server Administration, and Policy Based Management. Mike will also show you his tips for building an Environment Inventory Database, a tool you can use to track your servers, instances, and login credentials.
By leveraging what you already have in SQL Server, you'll certainly be able to do more with less.
SessionID: 22442
Understanding Power BI by Example
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Ramon Ponte
Title: Understanding Power BI by Example
Abstract:
SessionID: 22943
ETL Architecture Checkup: Avoiding Costly Mistakes
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Rafael Salas
Title: ETL Architecture Checkup: Avoiding Costly Mistakes
Abstract:
In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.
SessionID: 23421
Como lograr tu certificación de SQL Server 2012
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Rogger Rodriguez
Title: Como lograr tu certificación de SQL Server 2012
Abstract:
En esta sesión se ofrecerá un resumen del fenómeno de las certificaciones en la industria de las bases de datos SQL Server, los cursos de entrenamiento del fabricante, beneficios y ventajas de las certificaciones y el RoadMap de certificación para SQL Server 2012.
SessionID: 27729
Windowing Functions in SQL Server 2012
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 27730
Table Vars Temp Tables - What you NEED to Know!
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Wayne Sheffield
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 9180
PowerPivot, Tabular and Multidimensional Models: Understanding Analysis Services Flavors
Event Date: 12-04-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Alan Koo
Title: PowerPivot, Tabular and Multidimensional Models: Understanding Analysis Services Flavors
Abstract:
The Unified Dimensional Modeling (UDM) concept was introduced in Analysis Services 2005 as the semantic layer to enable the OLAP cube development from multiple sources using an abstract layer. Analysis Services 2012 introduces the Business Intelligence Semantic Model (BISM) concept as an evolution to UDM, offering two new 'flavors': the Multidimensional Mode and the Tabular Mode. The BISM represents the heart of Microsoft Business Intelligence strategy for now and the upcoming years. This session will explain and clarify the basic concepts of Analysis Services 2012 and PowerPivot. We will also discuss different scenarios that will allow BI architects / developers take better decisions when building up the foundation for their companies’ Enterprise Analytics strategy.