sqlsathistory

Nr: 535

Back to Main list

SQLSaturday #535 - Sri Lanka 2016

Start Time (24h) Speaker Track Title
09:30:00 Dinesh Asanka Business Intelligence Data Analytics Machine Learning with SQL Server 2016 R Services
09:30:00 Janaka Rangama Cloud [SQL in Azure IaaS
09:30:00 Pinal Dave Database Engine Database Development Secrets of SQL Server: Database Worst Practices
10:45:00 Chamila Mihiripenna Business Intelligence Data Analytics Data Visualization with SSRS Mobile Reports
10:45:00 Satya Prakash Database Engine Database Development How SQL Server works on a Windows Cluster
10:45:00 Nilabja Ball Database Engine Database Development Real-Time Operational Analytics in SQL Server 2016
12:00:00 Vijayakumar Thurupathan Cloud A Glimpse of Polyglot Persistence with Azure Data Services offerings
12:00:00 Pinal Dave General Other Blogging – How to Build and Sustain Top Ranking Blog
14:00:00 G.R. Kulasingham Database Engine Database Development Securing data with SQL Server 2016
14:00:00 Dinesh Priyankara Cloud On-premise database. Files in the cloud.
15:15:00 Nilabja Ball Cloud Azure SQL Data Warehouse – Cloud Solution for Data Warehousing
15:15:00 Satya Prakash Database Engine Database Development SQL Server 2016 New Features
16:30:00 Dinesh Priyankara General Other The Great SQL Panel Discussion

SessionID: 49056

Machine Learning with SQL Server 2016 R Services

Back to calendar

Event Date: 18-06-2016 - Session time: 09:30:00 - Track: Business Intelligence Data Analytics

Speaker: Dinesh Asanka

Title: Machine Learning with SQL Server 2016 R Services

Abstract:

Microsoft recently launched SQL Server 2016, which, in addition to many other great features, offers in-database advanced analytics with R Services, allowing users to combine the power of SQL Server and Microsoft R Server (or Open Source R), without data leaving the database.

With SQL Server R Services, users can develop analytic models in a local R IDE and it has it's own template as well for support different industry needs.

SessionID: 49987

SQL in Azure IaaS | Business Continuity Planning

Back to calendar

Event Date: 18-06-2016 - Session time: 09:30:00 - Track: Cloud

Speaker: Janaka Rangama

Title: SQL in Azure IaaS | Business Continuity Planning

Abstract:

SQL server is a first class citizen in Microsoft Azure IaaS. Regardless of the where SQL workloads are hosted, it takes a rock solid BCP solution in place to guarantee minimum business impact when an unexpected disaster happens. If your organization is planning to move SQL server workloads to Microsoft Azure, preparing a proper contingency plan to recover in case of a disaster would be a mission critical task for DBAs and IT PROs.

This demo driven session will explore the high availability and disaster recovery options for SQL IaaS in Microsoft Azure, design considerations for a highly available SQL deployment and leveraging Azure's cloud backup capabilities in SQL IaaS VMs.

SessionID: 50262

Secrets of SQL Server: Database Worst Practices

Back to calendar

Event Date: 18-06-2016 - Session time: 09:30:00 - Track: Database Engine Database Development

Speaker: Pinal Dave

Title: Secrets of SQL Server: Database Worst Practices

Abstract:

“Oh no--what have I done?” Chances are you have heard, or even uttered, these words. This demo-oriented session shows many examples in which database pros have been dumbfounded by their own mistakes. It might even bring back memories of your own early DBA days. This session exposes the small details that can be dangerous to the production environment and SQL Server as a whole and talks about worst practices and how to avoid them. The session focuses on common errors and their resolution. Developers will walk out with scripts and knowledge that they can immediately apply to their own servers.

SessionID: 49598

Data Visualization with SSRS Mobile Reports

Back to calendar

Event Date: 18-06-2016 - Session time: 10:45:00 - Track: Business Intelligence Data Analytics

Speaker: Chamila Mihiripenna

Title: Data Visualization with SSRS Mobile Reports

Abstract:

How to create Mobile friendly dashboards using SSRS Mobile Reports. Setup data sources, Look and understand data, Layout dashboard for different form factors, map data to UI gauges and define filters. Live Demo.

SessionID: 50209

How SQL Server works on a Windows Cluster

Back to calendar

Event Date: 18-06-2016 - Session time: 10:45:00 - Track: Database Engine Database Development

Speaker: Satya Prakash

Title: How SQL Server works on a Windows Cluster

Abstract:

Generally SQL DBAs are very good at managing standalone SQL Server instances but for managing SQL Server on a cluster requires altogether a new set of skills. The difference starts right from installation to planning and then to implementing and finally troubleshooting. This session will focused on the following topics:

What is Windows Cluster and how it works. How SQL Server works on Windows Clusters. How to install, configure, perform maintenance and troubleshoot SQL Server on a Windows Cluster.

SessionID: 50275

Real-Time Operational Analytics in SQL Server 2016

Back to calendar

Event Date: 18-06-2016 - Session time: 10:45:00 - Track: Database Engine Database Development

Speaker: Nilabja Ball

Title: Real-Time Operational Analytics in SQL Server 2016

Abstract:

SQL Server 2016 enables customers to run analytic queries on in-memory and disk-based OLTP tables on mission critical systems without any application changes. This session covers various configurations, use cases and best practices for achieving significant performance gains with Operational Analytics.

SessionID: 48398

A Glimpse of Polyglot Persistence with Azure Data Services offerings

Back to calendar

Event Date: 18-06-2016 - Session time: 12:00:00 - Track: Cloud

Speaker: Vijayakumar Thurupathan

Title: A Glimpse of Polyglot Persistence with Azure Data Services offerings

Abstract:

Modern cloud applications and services demand for different persistence technologies as they require high volume and diversified data types to be stored.

Relying on relational data storage is no more feasible, at the same time NoSQL databases do not provide all the great stuff relational databases provide. Some solutions overwhelm the usage of NoSQL databases while others have adaptability issues and learning challenges, so finding the right balance between the relational and NoSQL is confusing.

But the future seems very clear that polygot persistence solutions are the way to design and develop the applications.

This session will help you to understand the fundamentals of the NoSQL offerings of Azure - Table Storage and Document DB and then will give some real world case studies of how polygot persistence could be used along side Azure SQL Databases, which will guide you in making decisions in designing your application.

SessionID: 50265

Blogging – How to Build and Sustain Top Ranking Blog

Back to calendar

Event Date: 18-06-2016 - Session time: 12:00:00 - Track: General Other

Speaker: Pinal Dave

Title: Blogging – How to Build and Sustain Top Ranking Blog

Abstract:

Expressing yourself is the most common behavior of humans, and blogging has made it easy to express yourself. Just like a letter or book has a structure and formula, blogging also has structure and formula. In this introductory course on blogging, we will go over a few of the basics of blogging and show how to get started with blogging immediately. If you already have a blog, this course will be even more relevant, as it will discuss many of the common questions and issues you face in your blogging routine.

Everybody can write, and everybody can build a blog. But not everyone can make their blog a popular point of reference for their subject matter. Content is king - but a king also has ministers to help, and good content needs help from various aspects of the real world. In this course, we discuss the essential elements to bringing quality content to the masses, making it popular, and monetizing your effort.

SessionID: 50304

Securing data with SQL Server 2016

Back to calendar

Event Date: 18-06-2016 - Session time: 14:00:00 - Track: Database Engine Database Development

Speaker: G.R. Kulasingham

Title: Securing data with SQL Server 2016

Abstract:

Securing database is one of the key concerns of database professionals. This sessions explores the features available up to 2016 and how to get the best out of it

SessionID: 50555

On-premise database. Files in the cloud.

Back to calendar

Event Date: 18-06-2016 - Session time: 14:00:00 - Track: Cloud

Speaker: Dinesh Priyankara

Title: On-premise database. Files in the cloud.

Abstract:

The responsibility over managing data files, security, availability and bearing maintenance cost is not always affordable and not easy too. Microsoft gave us a solution for this starting with SQL Server 2012, though we haven't noticed it much. But now with added enhancements, it is worth to give it a shot with SQL Server 2016, since the benefits are significant. SQL Server data files in Azure offers you several hybrid solutions by providing several benefits for data virtualization, data movement, security and availability, and any easy low cost maintenance for high-availability and elastic scaling. Join this session to discuss this.

SessionID: 50270

Azure SQL Data Warehouse – Cloud Solution for Data Warehousing

Back to calendar

Event Date: 18-06-2016 - Session time: 15:15:00 - Track: Cloud

Speaker: Nilabja Ball

Title: Azure SQL Data Warehouse – Cloud Solution for Data Warehousing

Abstract:

SQL Data Warehouse is an elastic data warehouse as a service with massive parallel processing and full enterprise-class SQL experience. Azure SQL DW offers elastic performance and scale to 1+ PB, market leading price/performance, and true SQL experience across structured and unstructured data.

In this session, we take an in-depth look at implementing a SQL DW, elastic scale (grow, shrink, and pause) and hybrid data clouds with Hadoop integration

SessionID: 50299

SQL Server 2016 New Features

Back to calendar

Event Date: 18-06-2016 - Session time: 15:15:00 - Track: Database Engine Database Development

Speaker: Satya Prakash

Title: SQL Server 2016 New Features

Abstract:

With every new version SQL Server comes up with great features. SQL server 2016 is also packed with existing new features. This session we will SQL new key features and enhancements.

SessionID: 50552

The Great SQL Panel Discussion

Back to calendar

Event Date: 18-06-2016 - Session time: 16:30:00 - Track: General Other

Speaker: Dinesh Priyankara

Title: The Great SQL Panel Discussion

Abstract:

This site is open source. Improve this page.