SQLSaturday #417 - Sri Lanka 2015
NoSQL on Azure: An Introduction to DocumentDB
Event Date: 06-06-2015 - Session time: 09:30:00 - Track: Data Analytics
Speaker: Nilabja Ball
Title: NoSQL on Azure: An Introduction to DocumentDB
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.
Performance in 60 Seconds - SQL Tricks Everybody MUST Know
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
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.
Inside Transactional Replication
Event Date: 06-06-2015 - Session time: 10:45:00 - Track: Database Engine
Speaker: Prabhakaran Bhaskaran
Title: Inside Transactional Replication
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!
Big Data Analytics: The Microsoft Way
Event Date: 06-06-2015 - Session time: 10:45:00 - Track: Data Analytics
Speaker: Dinesh Priyankara
Title: Big Data Analytics: The Microsoft Way
SQL Server 2014 In-Memory Overview
Event Date: 06-06-2015 - Session time: 12:00:00 - Track: Database Engine
Speaker: Nilabja Ball
Title: SQL Server 2014 In-Memory Overview
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.
Event Date: 06-06-2015 - Session time: 12:00:00 - Track: Data Analytics
Speaker: Vijayakumar Thurupathan
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!
Telling Stories with Data
Event Date: 06-06-2015 - Session time: 14:00:00 - Track: Data Analytics
Speaker: Gogula Aryalingam
Title: Telling Stories with Data
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.
Indexes – The Unsung Hero
Event Date: 06-06-2015 - Session time: 14:00:00 - Track: Database Engine
Speaker: Pinal Dave
Title: Indexes – The Unsung Hero
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.
My Data in the Cloud: Microsoft Azure SQL Database
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
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
Enterprise MS BI for everyone, The Journey So Far
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
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.
The Great SQL Panel Discussion
Event Date: 06-06-2015 - Session time: 16:30:00 - Track: General
Speaker: Pinal Dave
Title: The Great SQL Panel Discussion
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...