sqlsathistory

Nr: 417

Back to Main list

SQLSaturday #417 - Sri Lanka 2015

Start Time (24h) Speaker Track Title
09:30:00 Nilabja Ball Data Analytics NoSQL on Azure: An Introduction to DocumentDB
09:30:00 Pinal Dave Database Engine Performance in 60 Seconds - SQL Tricks Everybody MUST Know
10:45:00 Prabhakaran Bhaskaran Database Engine Inside Transactional Replication
10:45:00 Dinesh Priyankara Data Analytics Big Data Analytics: The Microsoft Way
12:00:00 Nilabja Ball Database Engine SQL Server 2014 In-Memory Overview
12:00:00 Vijayakumar Thurupathan Data Analytics Setting your first foot in the world of Business Intelligence
14:00:00 Gogula Aryalingam Data Analytics Telling Stories with Data
14:00:00 Pinal Dave Database Engine Indexes – The Unsung Hero
15:15:00 Sammani Palansuriya Database Engine My Data in the Cloud: Microsoft Azure SQL Database
15:15:00 Indika Ariyasinghe Data Analytics Enterprise MS BI for everyone, The Journey So Far
16:30:00 Pinal Dave General The Great SQL Panel Discussion

SessionID: 21415

NoSQL on Azure: An Introduction to DocumentDB

Back to calendar

Event Date: 06-06-2015 - Session time: 09:30:00 - Track: Data Analytics

Speaker: Nilabja Ball

Title: NoSQL on Azure: An Introduction to DocumentDB

Abstract:

NoSQL data stores have gone mainstream. In this session, we will survey the expanding NoSQL landscape on Azure, providing a big-picture view of these technologies. Also spend a bit more time on DocumentDB, Microsoft’s document database-as-a-service, and Azure Search. This session is aimed at anybody who’s new to NoSQL or is curious about the NoSQL options that Azure provides today.

SessionID: 36173

Performance in 60 Seconds - SQL Tricks Everybody MUST Know

Back to calendar

Event Date: 06-06-2015 - Session time: 09:30:00 - Track: Database Engine

Speaker: Pinal Dave

Title: Performance in 60 Seconds - SQL Tricks Everybody MUST Know

Abstract:

Data and Database are very important aspects of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

SessionID: 10492

Inside Transactional Replication

Back to calendar

Event Date: 06-06-2015 - Session time: 10:45:00 - Track: Database Engine

Speaker: Prabhakaran Bhaskaran

Title: Inside Transactional Replication

Abstract:

You can probably do a good job in configuring and maintaining transactional replication in your environment. You can get these things done with reasonable quality without knowing how SQL Server does things under the covers. However if you want to take your skills to the next level and troubleshoot complex replication issues, it's crucial to know how transactional replication works internally.

This session will answers questions like; How does the log reader know where to start the scan? How does it add the commands to the Distribution database? How many threads are involved in a replication process? How does distribution agent look for pending transactions to distribute to its subscribers? Knowing all these will help you to manage and troubleshoot the replication very effectively. Come lets learn together!

SessionID: 36538

Big Data Analytics: The Microsoft Way

Back to calendar

Event Date: 06-06-2015 - Session time: 10:45:00 - Track: Data Analytics

Speaker: Dinesh Priyankara

Title: Big Data Analytics: The Microsoft Way

Abstract:

Have you already incorporated “Big Data” into your analytical solution, but still feel you are going nowhere with it? Or are you planning to bring “Big Data” into your analytical solution, but not sure which way to go? Do you wonder about how to get it done, and what tools and methods that you need to use? Let us talk about it; let us understand the “Big Data” requirement; how to and the best way of bringing it into analytical stack using the Microsoft way, of course.

SessionID: 21416

SQL Server 2014 In-Memory Overview

Back to calendar

Event Date: 06-06-2015 - Session time: 12:00:00 - Track: Database Engine

Speaker: Nilabja Ball

Title: SQL Server 2014 In-Memory Overview

Abstract:

Overview of the in-memory technologies which are included in SQL Server 2014. We will cover In-Memory OLTP (AKA "Hekaton"), In-Memory Data Warehousing (AKA "Apollo") as well as SSD Buffer Pool Extensions. This session will give understanding of the broad in-memory strategy as well as a basic understanding of the technologies involved.

SessionID: 36650

Setting your first foot in the world of Business Intelligence

Back to calendar

Event Date: 06-06-2015 - Session time: 12:00:00 - Track: Data Analytics

Speaker: Vijayakumar Thurupathan

Title: Setting your first foot in the world of Business Intelligence

Abstract:

Have you ever wondered why we need a data warehouse when we have the good old stringent relational database scheme. Do you want to get to know the concepts of data warehousing and business intelligence? Then this is the session you have been looking for: A tour from OLTP to OLAP with Microsoft technologies. Gear up for the excitement!

SessionID: 36000

Telling Stories with Data

Back to calendar

Event Date: 06-06-2015 - Session time: 14:00:00 - Track: Data Analytics

Speaker: Gogula Aryalingam

Title: Telling Stories with Data

Abstract:

Data is all around us; it is in bits and pieces; it is in shapeless chunks. These data can tell us stories. Organizations have loads of these data lying around, but seldom make use of it. Modern data analytics methods however, give us a plethora of methods to access this data, mash them up and tell stories using them. Stories, that can help make effective decisions.

This session looks at how you could collect data from the various sources in your organization, combine them, process them and tell stories using the wealth of tools given to us by Microsoft. Words you would hear are business intelligence, self-service data analytics and big data.

SessionID: 36174

Indexes – The Unsung Hero

Back to calendar

Event Date: 06-06-2015 - Session time: 14:00:00 - Track: Database Engine

Speaker: Pinal Dave

Title: Indexes – The Unsung Hero

Abstract:

Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

SessionID: 36522

My Data in the Cloud: Microsoft Azure SQL Database

Back to calendar

Event Date: 06-06-2015 - Session time: 15:15:00 - Track: Database Engine

Speaker: Sammani Palansuriya

Title: My Data in the Cloud: Microsoft Azure SQL Database

Abstract:

Microsoft Azure SQL Database (formerly SQL Azure) is another Microsoft Azure service that offers relational database-as-a-service with proven performance, scalability, data security and near-zero administration.

This discussion will give you an understanding about Azure SQL Database; what this service is and what it offers. It will also help you understand what sort of requirements will benefit from Azure SQL Database, and what factors you need to know in order to choose this service, along with pros and cons of choosing Azure SQL Database

SessionID: 36654

Enterprise MS BI for everyone, The Journey So Far

Back to calendar

Event Date: 06-06-2015 - Session time: 15:15:00 - Track: Data Analytics

Speaker: Indika Ariyasinghe

Title: Enterprise MS BI for everyone, The Journey So Far

Abstract:

Virtusa is a rapidly evolving company with diverse business intelligence needs spanning all level of the organization; from CxOs to Engineers (numbering around 8000 employees); from mobile devices to public area dashboards. In this session, I will share with you the challenges faced and how we have over come them so far, and plans for beyond future.

SessionID: 37115

The Great SQL Panel Discussion

Back to calendar

Event Date: 06-06-2015 - Session time: 16:30:00 - Track: General

Speaker: Pinal Dave

Title: The Great SQL Panel Discussion

Abstract:

Join Pinal and Nilabja as they take questions from the audience that is anything SQL Server, business intelligence and data on the cloud! This is a great opportunity to pick the minds of a couple of great SQL minds. We would also the other speakers ready to go as well...