sqlsathistory

Nr: 537

SQLSaturday #537 - Puerto Rico 2016

Start Time (24h)	Speaker	Track	Title
09:45:00	Nigel Sammy	Application Database Development	T-SQL: Tips and Tricks
09:45:00	Rafael Salas	BI Information Delivery	Preparing Data with Power BI: Scripts, Tips Tricks
09:45:00	Kenneth Urena	Enterprise Database Administration Deployment	SQL Server 2016 - Stretch Databases
09:45:00	Eduardo Castro	BI Platform Architecture, Development Administration	SQL Server 2016 un vistazo a todo lo nuevo!
11:15:00	Alejandro Cordero	Application Database Development	UFC #1433 In-Memory tables 2014 vs. 2016
11:15:00	Paresh Motiwala	Enterprise Database Administration Deployment	Copy Data Management and Virtualization
11:15:00	Jorge Sanchez	Enterprise Database Administration Deployment	Accurate and Faster DBA: Start Creating Your Own DBA Toolbox Using Scripts
11:15:00	Wilson Diaz	Analytics and Visualization	How I got my Scorecard - Measuring to Succeed (from MSFT Humacao, PR)
11:15:00	Juan Ortiz	Strategy and Architecture	Unlock Productivity and Freedom with Windows Containers
13:45:00	Jose L. Rivera	BI Platform Architecture, Development Administration	Real-time Operational Analytic with SQL Server 2016
13:45:00	Juan Martí	Application Database Development	Xamarin.Forms – The rising hero!
13:45:00	Ramon Ponte	Strategy and Architecture	SQL Server 2016 Hybrid Scenarios
13:45:00	Guillermo Caicedo Santiago	BI Information Delivery	Building a Modern Reporting Solution with SQL Server 2016
15:15:00	Adolfo Socorro	Analytics and Visualization	Power BI Data Visualization Tips and Tricks
15:15:00	Alan Koo	BI Platform Architecture, Development Administration	Everything you want to know about SQL Server 2016 Analysis Services
15:15:00	Isaias Martinez	Enterprise Database Administration Deployment	Windows 2016 + SQL: Better Together
15:15:00	Jose L. Rivera	Advanced Analysis Techniques	Advance Analytics with SQL Server R Services
16:45:00	Nigel Sammy	Application Database Development	SQL Server: Indexing Fundamentals
16:45:00	Paresh Motiwala	Enterprise Database Administration Deployment	TempDB- More permanent impact than you think
16:45:00	Eduardo Castro	Enterprise Database Administration Deployment	SQL Server Query Processor
16:45:00	Kenneth Urena	Enterprise Database Administration Deployment	Hered#233; una base de datos, y ahora que hago?

SessionID: 49301

T-SQL: Tips and Tricks

Back to calendar

Event Date: 25-06-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Nigel Sammy

Title: T-SQL: Tips and Tricks

Abstract:

Queries are running longer than expected? Your database server isn't performing as well as it should? There are many reason that this could be happening and one of them is the T-SQL being executed on the system. T-SQL offers various ways to get the information that you need but sometimes the option you choose might return the data that you want but may not be the best query structure or logic to use.

This session will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries. It will also show you some tips and tricks to avoid some bad T-SQL coding habits and help you write better queries. This session is for Developers and Database Administrators.

SessionID: 49949

Preparing Data with Power BI: Scripts, Tips Tricks

Back to calendar

Event Date: 25-06-2016 - Session time: 09:45:00 - Track: BI Information Delivery

Speaker: Rafael Salas

Title: Preparing Data with Power BI: Scripts, Tips Tricks

Abstract:

You may have already seen a lot of Power BI, but have you look deeper into its capabilities to get, merge and shape data?

Power BI comes with great functionality that allow us to explore, collect an combine data in a powerful and easy way. In this session, we will use Power BI to solve data challenges that used to require a lot of coding and more complex solutions in a quick and effective way. This session is loaded with practical examples that will help you getting a better understanding of Power Query data preparation capabilities and provides you with a good share of hands-on tips and scripts in scenarios such as: Cleansing address data, consume Odata Feeds, APIs calls , execute SSIS packages on demand and more.

SessionID: 50099

SQL Server 2016 - Stretch Databases

Back to calendar

Event Date: 25-06-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kenneth Urena

Title: SQL Server 2016 - Stretch Databases

Abstract:

En esta session vamos a ver como configurar la nueva funcionalidad de SQL Server 2016 Stretch Databases, y los beneficios que podemos obtener de ella en nuestra estrategia de alta disponibilidad.

SessionID: 50116

SQL Server 2016 un vistazo a todo lo nuevo!

Back to calendar

Event Date: 25-06-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Eduardo Castro

Title: SQL Server 2016 un vistazo a todo lo nuevo!

Abstract:

Con la disponibilidad de SQL Server 2016 se han podido ver las nuevas capacidades que tendr#225; la pr#243;xima versi#243;n de SQL Server, en esta sesi#243;n veremos los cambios que est#225;n proceso de desarrollo y c#243;mo pueden ser utilizados para crear mejores escenarios de aplicaciones y arquitecturas de soluciones de negocios.

SessionID: 49597

UFC #1433 In-Memory tables 2014 vs. 2016

Back to calendar

Event Date: 25-06-2016 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Alejandro Cordero

Title: UFC #1433 In-Memory tables 2014 vs. 2016

Abstract:

In this session we will check the advantages of performance that In-Memory tables provides and how they evolved in SQL Server 2016. If you are planning to implement IN-Memory tables, check a performance comparison between 2014 and 2016, or just get to know how this technology works, this is the session you don#180;t want to miss. Let's Get Ready To Rumble!!

SessionID: 49966

Copy Data Management and Virtualization

Back to calendar

Event Date: 25-06-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Paresh Motiwala

Title: Copy Data Management and Virtualization

Abstract:

As DBAs, Developers, Infrastructure professionals, CIOs and IT Directors we are straddled with multiple issues pertaining to Copy Data sprawl.

Just imagine, it is 4:30 PM on Friday evening, you need a 10 TB database restored, thirty minutes after restore is complete, you are asked to do it again. What can you do? In any conventional method for providing copy data, you would run into any or all of the issues of providing space, bandwidth consumption, time to complete, the lead time to complete, security, masking and the key question "Which server does this go to"?

We will also discuss the pros and cons of methods that are currently used for copy data including replication, mirroring, transaction log shipping, block level replication etc. We will learn about "Copy Data Virtualization" a relatively new concept; and how it can help us overcome all these issues. We will examine what technologies/products are available that help us mitigate such a massive problem of Copy Data.

SessionID: 50155

Accurate and Faster DBA: Start Creating Your Own DBA Toolbox Using Scripts

Back to calendar

Event Date: 25-06-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jorge Sanchez

Title: Accurate and Faster DBA: Start Creating Your Own DBA Toolbox Using Scripts

Abstract:

(Presented in Spanish) Are you planning a long database maintenance window? Are you experiencing performance issues? Do you need to evaluate or do changes in multiple SQL instances? In all these scenarios you want tools that may help you do your work accurately, but also faster. Solution? Start creating your own DBA Toolbox scripts. This session will explain and demonstrate day-to-day script samples.

SessionID: 50526

How I got my Scorecard - Measuring to Succeed (from MSFT Humacao, PR)

Back to calendar

Event Date: 25-06-2016 - Session time: 11:15:00 - Track: Analytics and Visualization

Speaker: Wilson Diaz

Title: How I got my Scorecard - Measuring to Succeed (from MSFT Humacao, PR)

Abstract:

SessionID: 52604

Unlock Productivity and Freedom with Windows Containers

Back to calendar

Event Date: 25-06-2016 - Session time: 11:15:00 - Track: Strategy and Architecture

Speaker: Juan Ortiz

Title: Unlock Productivity and Freedom with Windows Containers

Abstract:

Have you ever struggled with deployment speed? Or maybe application security issues? Look no further, Windows Containers are here. We will Describe what containers are, their purpose, and how they evolved. We will also have a technical overview of containers, their requirements, and their architecture and integration. We will describe the benefit of containers to developers. Finally, we will wrap up with some demos and use cases.

SessionID: 52265

Real-time Operational Analytic with SQL Server 2016

Back to calendar

Event Date: 25-06-2016 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jose L. Rivera

Title: Real-time Operational Analytic with SQL Server 2016

Abstract:

En esta sesi#243;n estaremos viendo la funcionalidad de SQL Server 2016 llamada Operational Analytics que nos permite analizar las operaciones y transacciones de una base de datos sin la necesidad de ETLs o la construcci#243;n de Bodegas de Datos (Data Warehouses).

SessionID: 52547

Xamarin.Forms – The rising hero!

Back to calendar

Event Date: 25-06-2016 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Juan Martí

Title: Xamarin.Forms – The rising hero!

Abstract:

Have you ever been walking on the dark alley of mobile development? Where many different gangs of technology wonder around the area. You been a simple .Net-er walk in fear of been assaulted by the shadow of the Swift ninjas, or falling on the Java Latte family. Fear no more! Because now with the Xamarin.Forms you will have the great power of creating amazing mobile apps using the .Net skills that you already know. Becoming the mobile hero, we need to live without fear!

SessionID: 52548

SQL Server 2016 Hybrid Scenarios

Back to calendar

Event Date: 25-06-2016 - Session time: 13:45:00 - Track: Strategy and Architecture

Speaker: Ramon Ponte

Title: SQL Server 2016 Hybrid Scenarios

Abstract:

Microsoft has invested heavily in building cloud capabilities into SQL Server. SQL Server 2016 is architected to work smoothly with the cloud in a hybrid environment that helps organizations realize the benefits of hyperscale cloud. And SQL Server and Microsoft Azure work better together because the Microsoft hybrid cloud technology provides a consistent set of tools and processes between on-premises and cloud-based environments. This means that SQL Server 2016 is designed to work in a hybrid cloud environment in which data and services reside in various locations.

As a result, it is now much easier to move databases to the cloud. Learn about the hybrid scenarios supported in SQL Server 2016, which include Stretch Database, Always Encrypted, faster hybrid backups and high availability, and disaster recovery scenarios to back up and restore on-premises databases to Microsoft Azure and place SQL Server AlwaysOn secondaries in Azure.

SessionID: 52590

Building a Modern Reporting Solution with SQL Server 2016

Back to calendar

Event Date: 25-06-2016 - Session time: 13:45:00 - Track: BI Information Delivery

Speaker: Guillermo Caicedo Santiago

Title: Building a Modern Reporting Solution with SQL Server 2016

Abstract:

With the evolution of the Data Platform and as more tools become available, it is necessary to understand which will help us provide a stable, scalable and rich reporting experience to our end users. The new version of SQL Server and PowerBI brings us up to date with modern business intelligence trends. Join us for a technical overview of the new reporting and business intelligence capabilities in SQL Server 2016.

SessionID: 50130

Power BI Data Visualization Tips and Tricks

Back to calendar

Event Date: 25-06-2016 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Adolfo Socorro

Title: Power BI Data Visualization Tips and Tricks

Abstract:

SessionID: 52251

Everything you want to know about SQL Server 2016 Analysis Services

Back to calendar

Event Date: 25-06-2016 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Alan Koo

Title: Everything you want to know about SQL Server 2016 Analysis Services

Abstract:

SQL Server 2016 Analysis Services (SSAS) includes many new enhancements providing improved performance, easier solution authoring, automated database management, enhanced relationships with bi-directional cross filtering, parallel partition processing, and much more. In this session we will look at how Analysis services tabular models simplify solving complex business problems using over 50 new DAX functions and how new relationship types can help solve many to many issues. At the same time improved performance allows faster loading and analyzing of data. Come and join this session lo learn more about of these on other updates in the latest version of the heart of the Microsoft Business Intelligence platform.

SessionID: 52252

Windows 2016 + SQL: Better Together

Back to calendar

Event Date: 25-06-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Isaias Martinez

Title: Windows 2016 + SQL: Better Together

Abstract:

Explore the new features of Windows Server 2016 which make the operating system chosen for the execution of SQL Server 2016. Topics such as performance, high availability, integration with Azure, among other topics will touch.

SessionID: 52264

Advance Analytics with SQL Server R Services

Back to calendar

Event Date: 25-06-2016 - Session time: 15:15:00 - Track: Advanced Analysis Techniques

Speaker: Jose L. Rivera

Title: Advance Analytics with SQL Server R Services

Abstract:

SQL Server R Services provides a platform for developing intelligent applications that uncover new insights. In this session we will show how to get started with SQL Server R Services to operationalize R solutions or to create powerful data exploration and predictive modeling solutions.

SessionID: 49304

SQL Server: Indexing Fundamentals

Back to calendar

Event Date: 25-06-2016 - Session time: 16:45:00 - Track: Application Database Development

Speaker: Nigel Sammy

Title: SQL Server: Indexing Fundamentals

Abstract:

We all have indexes in our databases or at least should have indexes in them, but the question is, do we have the right types of indexes? Do we have too many or not enough? Are my indexes beneficial to my database? This session will leave you with the ability to answer these questions and more. We’ll review the different types of indexes in SQL Server and also discuss the structure of some of the main ones. I will show you how to verify if your indexes are being used, if they are being duplicated and finally how to maintain your indexes.

SessionID: 49968

TempDB- More permanent impact than you think

Back to calendar

Event Date: 25-06-2016 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Paresh Motiwala

Title: TempDB- More permanent impact than you think

Abstract:

As a DBA you hear different theories and "gospel truths" about TempDB from many people. Frankly there is no single version of the truth except that if you don't use and manage it well, it will make your life a real h*ll.

What works for you in one situation may not work for you in another situation. What works for a situation today, might not guarantee its success for a similar situation tomorrow.

We will talk about Temporary User Objects, Work Tables, Interim Results Version Store for Data Standards for its configuration Contention Data Files Per CPU - Myth or Reality? Dynamic Growth or Pre Sized? Trace Flags to Manage Tempdb? Should we store the entire Tempdb on SSDs? Should we shrink TempDB or not?

Hopefully at the end of the session your knowledge on Tempdb won't be Temp.

SessionID: 50089

SQL Server Query Processor

Back to calendar

Event Date: 25-06-2016 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Eduardo Castro

Title: SQL Server Query Processor

Abstract:

El Query Processor de SQL Server es la parte primordial del motor de base de datos, est#225; involucrado en tareas tales como Query Execution y Query Optimization, en esta sesi#243;n veremos los detalles internos del procesador de consultas de SQL Server y c#243;mo ha cambiado a trav#233;s del tiempo, tambi#233;n nos enfocamos en c#243;mo entender su funcionamiento para mejorar el rendimiento de SQL Server.

SessionID: 50098

Hered#233; una base de datos, y ahora que hago?

Back to calendar

Event Date: 25-06-2016 - Session time: 16:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kenneth Urena

Title: Hered#233; una base de datos, y ahora que hago?

Abstract:

Si estas o reciente mente has estado en esta situaci#243;n en la que has heredado la base de datos o simplemente cambiaste de trabajo, y llegaste cuando la base de datos ya estaba creada, y se te hace familiar la frase de "Y ahora que hago?", en esta sencion te dare ciertos guias que te puede ayudar a comenzar a levantar el desempe#241;o de tu base de dfatos actual y verificar el estado de tus erstrategia de recuperaci#243;n de desastres.

This site is open source. Improve this page.