SQLSaturday #639 - Sri Lanka 2017
Event Date: 08/12/2017 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: Kick Start! SQL Server 2014/2016 Performance Tips and Tricks
Abstract: Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2014/2016 has introduced many new features. In this session we will be learning quite a few of the new features of SQL Server 2014/2016.
Here is the glimpse of the features we will cover in this session. • live plans for long-running queries • transaction durability and its impact on queries • new cardinality estimate for optimal performance • In-memory OLTP optimization of superior query performance • columnstore indexes and performance tuning • Query Store • Temporal Tables.
This 75 minutes will be the most productive time for any DBA and Developer who wants to quickly jumpstart with SQL Server 2014 and its new features.
Speaker(s):
- Pinal Dave
Track and Room: Database Development Administration - Auditorium (200)
Title: 10 Amazing Things About Power BI You Don’t Know
Abstract: Have you used Power BI for a real-time dashboard? Have you looped through source files in your Power Query and applied custom functions on them? Have you changed your data model to help Power QA to respond intelligently? Have you heard of structured columns in Power Query? Have you used Calculated Tables in DAX? Have you used Power BI Embedded? Have you done many other amazing things with Power BI?
In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and with high performance.
Speaker(s):
- Reza Rad
Track and Room: Business Intelligence Data Analytics - Auditorium (200)
Title: On-premises Machine Learning: SQL Server 2016 with R
Abstract: The R server 2016 provides many functionalities for database developers. It helps us to get more insight out of data by applying descriptive, predictive, and prescriptive analysis on data which located in SQL server 2016. In this session, first I will provide some descriptions on the descriptive, predictive, and prescriptive analysis. Then I will discuss what algorithm we can use to reach these three analysis using R. Finally, I will show a couple of demos on each of these type of analysis and will present how to write them in SQL Server 2016. the process of writing R code in SQL Server 2016 will be presented and the best practice for doing that also explained.
Speaker(s):
- Leila Etaati
Track and Room: Business Intelligence Data Analytics - Auditorium (200)
Title: Big Data with Azure: Where to begin? Concepts and Best Practices
Abstract: In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure.
Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Speaker(s):
- Satya Jayanty
Track and Room: Cloud Mobile - Conference Room (55)
Title: A Journey of a Data Point through Cortana Intelligence Suite
Abstract: Cortana Analytics is a suite of fully managed Business Intelligence (BI), Big Data, and Advanced Analytics service offerings from Microsoft in the Azure Cloud. A raw data point comes from a user input or from an IoT sensor gets the real value through these services. Session discusses about the features and the abilities of Cortana Intelligence Suite.
Speaker(s):
- Haritha Thilakarathne
Track and Room: Business Intelligence Data Analytics - Lecture Room (40)
Title: Data Preparation is the Keystone; Power Query is Building Block
Abstract: Prepare to be amazed with what you can achieve using Power Query in this demo-heavy session. Power Query is the data extraction, transformation, and mash up tool. It can be accessed through Excel or from Power BI Desktop. There are numerous data transformation features that can be used to solve real-world data preparation challenges.
We will use customer case studies to go through scenarios of preparing data for modelling, and visualization. You will learn how to use features of Power Query such as generators, custom functions, and lots of built-in functions to solve those scenarios. You will also learn some data preparation techniques through Excel itself.
Speaker(s):
- Reza Rad
Track and Room: Business Intelligence Data Analytics - Conference Room (55)
Title: Columnstore Indexes with SQL Server 2016
Abstract: The columnstore index is the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size. Beginning with SQL Server 2016, columnstore indexes enable operational analytics, the ability to run performant real-time analytics on a transactional workload.
In this session, you will learn all about columnstore indexes and how to start taking advantage of this technology to achieve true real-time analytics.
Speaker(s):
- Rushabh Mehta
Track and Room: Database Development Administration - Conference Room (55)
Title: Database Corruption - Advanced Recovery Techniques
Abstract: Being able to monitor, diagnose and recover from Database Corruption is a critical skill for any SQL Server DBA. In this session we will walk through the techniques required to detect and repair various forms of Corruption Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes. Warning: Hex Editors and DBCC Page dumps will be involved!
Speaker(s):
- Patrick Flynn
Track and Room: Database Development Administration - Lecture Room (40)
Title: The Great Data Panel Discussion
Abstract: A panel discussion on SQL Server, Business Intelligence and Analytics 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! The best way to summarize what you learnt throughout the day!
Speaker(s):
- Dinesh Priyankara
Track and Room: General Other - Auditorium (200)
Title: SQL Server 2016 Query Store
Abstract: The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. It provides the ability to natively capture baseline data within SQL Server. Using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query. During this session we will take a thorough look at the Query Store, its architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you
Speaker(s):
- Dharmendra Keshari
Track and Room: Database Development Administration - Conference Room (55)
Title: Using Neural Network for Prediction with Microsoft Technologies
Abstract: Neural Network is common thus complex technique in Data Analytics. Azure Machine Learning and SQL Server Data Mining has the option of using Neural Network for different purposes.
Speaker(s):
- Dinesh Asanka
Track and Room: Business Intelligence Data Analytics - Lecture Room (40)
Title: Cloud Data Warehousing: Azure SQL Data Warehouse
Abstract: The heart of almost all Business Intelligence solutions; Relational Data Warehouse, has been servicing us for decades making the implementation is complete and success. It was always an On-Premises database, but now it is available as a Database-as-a-Service with Microsoft Azure, called Azure SQL Data Warehouse. It is a MPP cloud-based, scale-out relational database that supports workloads from few hundred gigabytes to petabytes of data and it addresses all modern requirements in data warehousing. Let’s talk about traditional On-Premises data warehouse little bit and then discuss about Azure SQL Data Warehouse and implementation of it.
Speaker(s):
- Dinesh Priyankara
Track and Room: Business Intelligence Data Analytics - Conference Room (55)
Title: Getting started with SQL Server in Azure
Abstract: Azure offers a range of data management technologies and options with the promise of no maintenance overhead. In this session, we will learn about the 2 flavors of SQL Server data platform available in Azure and deep dive into how you can start taking advantage of Azure SQL DB to complement your on-premise data management solutions and how you can build a strategy for moving to the cloud.
Speaker(s):
- Rushabh Mehta
Track and Room: Cloud Mobile - Auditorium (200)
Title: Let’s make a complex dataset simple using Azure Cosmos DB
Abstract: Azure Cosmos DB is an evolution of Azure Document DB. It’s the industry first globally distributed database service, allow you to scale storage and throughput across many geographical regions with promising low latency. Cosmos DB supports for multi model database, different types of database engines like key-value, document, graph and multi API support like SQL, Azure Table Storage, Gremlin, MongoDB. Let’s see in action with a demo, how you can transfer your complex data into a simpler format with Document API and scale it in different regions with specific storage and throughput.
Speaker(s):
- Hansamali Gamage
Track and Room: Cloud Mobile - Lecture Room (40)
Title: Build data driven IoT analytics with Azure
Abstract: Internet of Things (IoT) is one of the emerging technology which transforms many different industries. IoT often produce large amount of data which is analysed in different levels. Data Analytics and Business Intelligence take a different landscape in IoT. We use different tools and techniques with the power of Cloud to solve the challenges and provide solutions. This session will provide you the information you required to get started with the IoT data analytics with the real case driven scenario.
Speaker(s):
- Vijayakumar Thurupathan
Track and Room: Business Intelligence Data Analytics - Auditorium (200)
Title: A JSON’s Journey through SQL Server
Abstract: This session talks about the newly introduced built-in JSON support of SQL Server. Session will compare the JSON support offered with that of the XML support, comparing and contrasting them on different aspects. Also will walkthrough the new functions introduced with regards to JSON support, performance aspects and real world scenarios on how to get the best out of this feature.
Speaker(s):
- Shamil Sadique
Track and Room: Database Development Administration - Lecture Room (40)
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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
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.
Dharmendra Keshari
LinkedIn: Dharmendra Keshari
Contact: http://dharmendrakeshari.com/
Dharmendra Keshari has strong and in-depth experience in Database Management. Currently, working as Senior Database Administrator at Micron Technology in Singapore and handling one of the most critical databases which are being used by Singapore Public Hospitals, national specialty centres and polyclinics. Dharmendra is an avid, regular mentor on social media, helping several enthusiast in solving their problems related to Database management. he is co-leader and regular speaker at Singapore SQL Server Pass Chapter (User Group). He has done certification for “Microsoft SQL Server#174; 2008, Implementation” and “Maintenance amp; Administering Microsoft SQL Server 2012 Database”.
Shamil Sadique
Twitter: - shamilsaleem
LinkedIn: Shamil Sadique
Shamil has over 8 years of experience working in the field of Database Administration with variety of database technologies including Microsoft SQL Server, Oracle, MySQL and MongoDB. Currently he is working as a Senior Production DBA (Oracle/MySQL) at Pearson Lanka (Pvt) Ltd. He is a Microsoft Certified Solutions Expert (MCSE) in SQL Server 2012 and an Oracle Database 11g Administrator Certified Associate (OCA). He is also certified in ITIL® Foundation Level, while holding a Bachelor’s Degree in Management Information Systems from the University College Dublin - National University of Ireland, Dublin.
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Satya Jayanty
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions
Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
Leila Etaati
Twitter: - @leila_etaati
LinkedIn: Leila Etaati
Contact: http://blog.radacad.com
Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQLSaturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQLSaturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.
Patrick Flynn
Twitter: - sqllensman
Contact: http://sqllensman.com/blog/
Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.
Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge
Reza Rad
Twitter: - Rad_Reza
LinkedIn: Reza Rad
Contact: http://radacad.com/blog
Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Haritha Thilakarathne
Twitter: - https://twitter.com/naadiya007?lang=en
LinkedIn: Haritha Thilakarathne
Contact: https://naadispeaks.wordpress.com/
Haritha Thilakarathne is a MVP in Artificial Intelligence from Sri Lanka now based in Melbourne. He has hands on experience with Azure Machine Learning, Microsoft Bot Framework, Microsoft Cognitive Services and developing intelligent applications. Haritha is a research scholar at La Trobe University reading for his PhD on Deep Learning with the collaboration of Australian Institute of Sport.
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.
Hansamali Gamage
Twitter: - https://twitter.com/HansamaliGamage
LinkedIn: Hansamali Gamage
Contact: http://hansamaligamage.blogspot.com/
Hansamali Gamage is an experienced professional and Microsoft MVP in Visual Studio and Technologies from Sri Lanka. She possesses 5+ years of experience in. NET stack and Azure related services. She is a frequent speaker in SL .NET Forum, SL Data community and global SQLSaturday events and Data camps. She is a tech enthusiasts and an award winning writer on Microsoft Tech Net forum.
Reza Rad
Twitter: - Rad_Reza
LinkedIn: Reza Rad
Contact: http://radacad.com/blog
Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.
Sponsors
The following is a list of sponsors that helped fund the event: