SQLSaturday #535 - Sri Lanka 2016
Event Date: 06/18/2016 00:00:00
Event Location:
- CIDA
- “Sausiripaya” 123 Wijerama Mawatha
- Colombo, Western, Sri Lanka
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- Vijayakumar Thurupathan
Track and Room: Cloud - Auditorium (220)
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.
Speaker(s):
- Pinal Dave
Track and Room: General Other - Lecture Hall (40)
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.
Speaker(s):
- Janaka Rangama
Track and Room: Cloud - Lecture Hall (40)
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.
Speaker(s):
- Dinesh Priyankara
Track and Room: Cloud - Auditorium (220)
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.
Speaker(s):
- Satya Prakash
Track and Room: Database Engine Database Development - Auditorium (220)
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.
Speaker(s):
- Satya Prakash
Track and Room: Database Engine Database Development - Lecture Hall (40)
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
Speaker(s):
- Nilabja Ball
Track and Room: Cloud - Conference Room (55)
Title: The Great SQL Panel Discussion
Abstract: A panel discussion on all SQL Server and related topics featuring all the speakers of SQLSaturday Sri Lanka. Ask them the questions that you want! The ultimate finale to a day of learning awesomeness!
Speaker(s):
- Dinesh Priyankara
Track and Room: General Other - Auditorium (220)
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.
Speaker(s):
- Pinal Dave
Track and Room: Database Engine Database Development - Auditorium (220)
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.
Speaker(s):
- Chamila Mihiripenna
Track and Room: Business Intelligence Data Analytics - Conference Room (55)
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
Speaker(s):
- G.R. Kulasingham
Track and Room: Database Engine Database Development - Conference Room (55)
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.
Speaker(s):
- Nilabja Ball
Track and Room: Database Engine Database Development - Auditorium (220)
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.
Speaker(s):
- Dinesh Asanka
Track and Room: Business Intelligence Data Analytics - Conference Room (55)
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Nilabja Ball
Nilabja is a Premier Field Engineer for Microsoft Global Business Support (GBS), India. He has more than 8 years of SQL Server and BI experience. He is engaged with the customer either for proactive activities including health check, assessment and support or for reactive tasks to troubleshoot and fix complex and critical issues. He has an engineering degree from Visvesvaraya technological university and keen to learn new technologies.
Dinesh Priyankara
Twitter: - http://twitter.com/dinesh_priya
LinkedIn: Dinesh Priyankara
Contact: http://dinesql.blogspot.com/
Dinesh is an experienced professional and database enthusiast with skills in database management systems and business intelligence. Possessing over 18 years of experience on data related technologies, he does training, consulting, and is a top contributor to the local SQL Server community. In recognition of his contributions and expertise he has demonstrated, he was awarded the Microsoft Most Valuable Professional (MVP) award for SQL Server for 13 consecutive years since 2006. He is a Subject Matter Expert on SQL Server exams and has contributed for SQL Server 2012, 2016, 2017 and Azure Data Engineering exam development and Job Task Analysis (JTA). Dinesh is the Founder/Principal Architect of dinesQL (Pvt) Ltd (http://dinesql.com). In his
Nilabja Ball
Nilabja is a Premier Field Engineer for Microsoft Global Business Support (GBS), India. He has more than 8 years of SQL Server and BI experience. He is engaged with the customer either for proactive activities including health check, assessment and support or for reactive tasks to troubleshoot and fix complex and critical issues. He has an engineering degree from Visvesvaraya technological university and keen to learn new technologies.
Dinesh Priyankara
Twitter: - http://twitter.com/dinesh_priya
LinkedIn: Dinesh Priyankara
Contact: http://dinesql.blogspot.com/
Dinesh is an experienced professional and database enthusiast with skills in database management systems and business intelligence. Possessing over 18 years of experience on data related technologies, he does training, consulting, and is a top contributor to the local SQL Server community. In recognition of his contributions and expertise he has demonstrated, he was awarded the Microsoft Most Valuable Professional (MVP) award for SQL Server for 13 consecutive years since 2006. He is a Subject Matter Expert on SQL Server exams and has contributed for SQL Server 2012, 2016, 2017 and Azure Data Engineering exam development and Job Task Analysis (JTA). Dinesh is the Founder/Principal Architect of dinesQL (Pvt) Ltd (http://dinesql.com). In his
Dinesh Asanka
Twitter: - @dineshasanka
LinkedIn: Dinesh Asanka
Contact: http://htttp://dbfriend.blogspot.com
Dinesh Asanka MVP for more than 8 years and has experience over 15 years with SQL Server different versions. He has spoken in Sri Lanka as well as out side conferences. Regular writer at SQL-Server-Performance.com and co-authored couple of books on SQL Server. Visiting Lecturer at Sri Lanka Institute of Information Technology (SLIIT), Sri Lanka on subjects such as Database Administration, Big Data Analytics, Data Security, Data warehousing amp; Data Mining at B.Sc and M.Sc level. Currently, reading for Mphil in the areas of data warehouse and fuzzy technology at University of Moratuwa, Sri Lanka.
Vijayakumar Thurupathan
Twitter: - thurutweets
LinkedIn: Vijayakumar Thurupathan
Contact: http://www.thuru.net
Thuru is a versatile technical person who has diversified experience in many areas of Information Technology for 6 years. Cloud computing, security, software development, business intelligence and databases are his most preferred technology areas.
He is a frequent speaker in Sri Lanka .NET forum and Sri Lanka SQL Server Universe user groups. Thuru is the founder of Colombo Cloud Meet Up where he often talks about various cloud computing topics. Also he is a Microsoft MVP for Microsoft Azure.
Satya Prakash
Twitter: - https://twitter.com/satyasql
LinkedIn: Satya Prakash
Contact: http://sqlserveranswers.com/
Satya Prakash: Currently working with TriCore Solutions (Managed Database Services) and handling more than 30 clients. Have developed monitoring with PowerShell and TSQL only (without using any third party tool). This monitoring system have almost all features provided by highly expensive and enterprise level monitoring system. Currently monitoring more than 700 instances.
Working with SQL server for more than 12 years. Had delivered dozens of classroom training. Regular speaker at community events at Microsoft Gurgaon-India.
Satya Prakash
Twitter: - https://twitter.com/satyasql
LinkedIn: Satya Prakash
Contact: http://sqlserveranswers.com/
Satya Prakash: Currently working with TriCore Solutions (Managed Database Services) and handling more than 30 clients. Have developed monitoring with PowerShell and TSQL only (without using any third party tool). This monitoring system have almost all features provided by highly expensive and enterprise level monitoring system. Currently monitoring more than 700 instances.
Working with SQL server for more than 12 years. Had delivered dozens of classroom training. Regular speaker at community events at Microsoft Gurgaon-India.
G.R. Kulasingham
Twitter: - @Preethi_1965
Started working with computers in 1985 and what then called databases in 1991, Prithi fall in love with SQL Server at first site in 1997. Starting with SQL Server 6.0, he has worked with all released versions of SQL Server. He was an MVP between 2011-2014 and moved into NOSQL area for some time, but returned to his first love now.
Pinal Dave
Twitter: - pinaldave
LinkedIn: Pinal Dave
Contact: https://blog.sqlauthority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Chamila Mihiripenna
LinkedIn: Chamila Mihiripenna
.
Pinal Dave
Twitter: - pinaldave
LinkedIn: Pinal Dave
Contact: https://blog.sqlauthority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Janaka Rangama
Twitter: - https://twitter.com/JanakaRangama
LinkedIn: Janaka Rangama
Contact: http://tekronin.net
Janaka Rangama a.k.a TEKRONIN is a Microsoft Certified Trainer, Microsoft Azure Architect amp; an Open Source Enthusiast in Sri Lanka. Once a musician turned into an IT Ninja, Janaka shares his cloud expertise daily with thousands of community peers. He is a Microsoft MVP in Cloud and Datacenter Management and a Technical Evangelist at 5Nine Software Inc.
Being certified from both Microsoft amp; Red Hat at the highest level as a cloud expert, Janaka also engages in promoting DevOps practice in Sri Lanka. Janaka is a community lead at Sri Lanka IT PRO Forum, the Sri Lankan Microsoft technical community for IT Professionals. He is a well-known technical speaker in many international conferences.
Sponsors
The following is a list of sponsors that helped fund the event: