Nr: 641
SQLSaturday #641 - Puerto Rico 2017
SessionID: 66504
Gestión de Backups y recuperación en bases de datos SQL Server
Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: German Ordonez
Title: Gestión de Backups y recuperación en bases de datos SQL Server
Abstract:
Alguna vez ha tenido que recuperar una base de datos SQL Server, para restaurar una tabla?
Le han solicitado archivos de backups encriptados para cumplir con estándares de seguridad?
Los respaldos de SQL Server utilizan al máximo los recursos de hardware disponible?
Durante esta sesión veremos cómo recuperar un objeto de la base de datos sin tener que recuperar la BD completa, vea cómo podemos recuperar registros modificados directamente de los archivos de log y conozca los nuevos algoritmos para realizar backups de SQL Server hasta con un 90% de compresión.
SessionID: 66569
Better Together: Power BI, Office 365 and Azure
Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Data Science
Speaker: Ramon Ponte
Title: Better Together: Power BI, Office 365 and Azure
Abstract:
SessionID: 66595
Creating a Server Antivirus/Antimalware Definitions Update Scanning Status Report
Event Date: 17-06-2017 - Session time: 09:45:00 - Track: Other
Speaker: Jorge Sanchez
Title: Creating a Server Antivirus/Antimalware Definitions Update Scanning Status Report
Abstract:
(In Spanish) Are you wonder how to know if your servers are up to date in their antivirus/antimalware? In this session I’ll explain and demonstrate how to create a custom solution for a server antivirus/antimalware definitions update scanning status report. The technologies used on the solution are: SQL Server (Database Reporting Services), Microsoft Endpoint Protection 2012, PowerShell Scripts (.ps1), Command files (.cmd), Windows Scheduled Tasks, and Active Directory Group Policy.
SessionID: 64902
Monitoreo y diagnostico de bases de datos SQL Server
Event Date: 17-06-2017 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment
Speaker: German Ordonez
Title: Monitoreo y diagnostico de bases de datos SQL Server
Abstract:
Conozca como las soluciones de Quest permiten monitorear un ambiente de bases de datos SQL Server, identificar problemas de espacio, identificar bloqueos en tiempo real, hacer diagnóstico histórico del comportamiento de la base de datos, generar alertas o notificaciones sobre los problemas en la base de datos, vea como rápidamente se puede hacer afinamiento a consultas SQL problemáticas, durante la sesión presentaremos los tips para identificar problemas en la base de datos y encontrar rápidamente las soluciones.
SessionID: 65511
SQL Server Machine Learning Services in a nutshell
Event Date: 17-06-2017 - Session time: 11:15:00 - Track: Advanced Analytics
Speaker: Jose L. Rivera
Title: SQL Server Machine Learning Services in a nutshell
Abstract:
With the evolution of SQL Server R Services into Machine Learning Services in SQL Server 2017 expanding scalable R in-database analytics by adding scalable Python machine learning providing enterprise-scale data science within SQL Server’s database engine. In this session, we will demonstrate how to create, deploy and consume machine learning models within SQL Server 2017.
SessionID: 66847
"The Statistical Sommelier", A Practical Intro to R!
Event Date: 17-06-2017 - Session time: 11:15:00 - Track: Data Science
Speaker: Nestor Figueroa
Title: "The Statistical Sommelier", A Practical Intro to R!
Abstract:
In this session, attendees will learn basic data exploration using R, and will be able to run an entire prediction case using Linear Regression, to predict quality of wine based on a real life case, but also stressing the importance for Data Scientists in the interpretation of the results.
SessionID: 62724
Disaster Recovery, de dificil a muy facil.
Event Date: 17-06-2017 - Session time: 13:45:00 - Track: Strategy and Architecture
Speaker: Isaias Martinez
Title: Disaster Recovery, de dificil a muy facil.
Abstract:
Contar con un “Disaster Recovery”, es una de las preocupaciones de muchos CIO, debido a la cantidad de diferentes sistemas, la complejidad de los mismos, el costo en dinero y operaciones de mantener un sitio alterno de recuperación, y no se hable de las pruebas, entre otras cosas más, hace que este sea un objetivo difícil de alcanzar.
En esta sesión cubriremos las bases de “Site Recovery”, un muy poderoso servicio de Microsoft Azure, que nos permitirá implementar un “Disater Recovery”, para la mayoría de nuestras plataformas sean Windows o Linux, Hyper-V o VMWare.
SessionID: 66497
Using Azure Machine Learning Power In Xamarin
Event Date: 17-06-2017 - Session time: 13:45:00 - Track: Software Development
Speaker: Juan Martí
Title: Using Azure Machine Learning Power In Xamarin
Abstract:
Microsoft, Google and even Apple are pushing the power of machine learning as the future of technology. This is the greatest moment of starting to make your application intelligent, predictive and using the power of machine learning. In this talk you will be able to use the power of Azure and combine it with Xamarin.
SessionID: 66570
Azure SQL Data Warehouse Loading Strategies
Event Date: 17-06-2017 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Guillermo Caicedo Santiago
Title: Azure SQL Data Warehouse Loading Strategies
Abstract:
Any data warehousing project has to include a data loading strategy during the development and operational phases. As the industry is moving to more modern and scalable alternatives in the cloud, it is important to understand what are our options and best practices to design the best strategy for our scenario. In this session we will go through some Polybase basics and various Azure SQL Data Warehouse loading best practices.
SessionID: 65512
SQL Server on Linux
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Jose L. Rivera
Title: SQL Server on Linux
Abstract:
The era of Windows only SQL Server is over. In this session, we will explore the capabilities that brings SQL Server 2017 on a Linux environment and its integration with the rest of the ecosystem.
SessionID: 66601
Introduction to Data Visualization with R: ggplot2 more
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: Data Science
Speaker: Orlando Mezquita
Title: Introduction to Data Visualization with R: ggplot2 more
Abstract:
ggplot2 is the most popular R package for data visualization. This incredibly versatile and powerful package allows you to create complex visualizations with simple code. In this session, we will cover the basics of ggplot2 and show you how to extend its capabilities with other packages. We will also provide some tips to consider when creating graphs.
SessionID: 66745
Microsoft SQL Server Certification and Career Roadmap
Event Date: 17-06-2017 - Session time: 15:15:00 - Track: Other
Speaker: Kahlil Mendez
Title: Microsoft SQL Server Certification and Career Roadmap
Abstract:
Microsoft is streamlining its expert-level technical certifications. The new Microsoft Certified Solutions Associate (MCSA) and Microsoft Certified Solutions Expert (MCSE) Data Management and Analytics Certification paths is aligning to industry-recognized areas of competence while providing flexibility to showcase your specific skills on Microsoft products and services.