SQLSaturday #417 - Sri Lanka 2015
Event Date: 06/06/2015 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: 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!
Speaker(s):
- Prabhakaran Bhaskaran
Track and Room: Database Engine - Seminar Room 4 (50 persons)
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.
Speaker(s):
- Pinal Dave
Track and Room: Database Engine - Auditorium (220 persons)
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.
Speaker(s):
- Dinesh Priyankara
Track and Room: Data Analytics - Auditorium (220 persons)
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.
Speaker(s):
- Pinal Dave
Track and Room: Database Engine - Auditorium (220 persons)
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.
Speaker(s):
- Gogula Aryalingam
Track and Room: Data Analytics - Seminar Room 4 (50 persons)
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.
Speaker(s):
- Nilabja Ball
Track and Room: Database Engine - Auditorium (220 persons)
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…
Speaker(s):
- Pinal Dave
Track and Room: General - Auditorium (220 persons)
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!
Speaker(s):
- Vijayakumar Thurupathan
Track and Room: Data Analytics - Seminar Room 4 (50 persons)
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.
Speaker(s):
- Indika Ariyasinghe
Track and Room: Data Analytics - Seminar Room 4 (50 persons)
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
Speaker(s):
- Sammani Palansuriya
Track and Room: Database Engine - Auditorium (220 persons)
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.
Speaker(s):
- Nilabja Ball
Track and Room: Data Analytics - Seminar Room 4 (50 persons)
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Prabhakaran Bhaskaran
Contact: http://www.pythian.com/blog/author/Bhaskaran/
Prabhakaran is SQL Server consultant at Pythian, a company based in Ottawa, Canada, specializing in Remote database services. He is former SQL Server Support Engineer at Microsoft. He always loves to learn and share his knowledge.
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.
Indika Ariyasinghe
I am working as a Associate Architect - Technology for Virtusa. My tenure at Virtusa is more than 11 years. I am holding a Software Engineering Degree from University of Peradeniya, Faculty of Engineering
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.
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.
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.
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.
Sammani Palansuriya
LinkedIn: Sammani Palansuriya
Contact: http://sammanipalansuriya.blogspot.com/
Sammani Palansuriya is a Visual C#.net MVP in Sri Lanka with more than 5 years#39; experience in various aspects of .net technologies. Currently she is stationed as a Senior Software Engineer at Exilesoft and working on projects based on asp.net and azure 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
Gogula Aryalingam
Twitter: - http://www.twitter.com/gogula
LinkedIn: Gogula Aryalingam
Contact: http://datamaul.wordpress.com
Gogula is a data analytics professional from Sri Lanka, with 14+ years on the Microsoft data platform. He has worked with many aspects of data analytics and BI solutions from architecting, designing, developing and consulting across various industries and verticals. He is Regional Mentor for PASS South Asia, Data Platform MVP, MCSE, former MCT, and MSc in IT. Gogula’s passion revolves data analytics and BI; hence enjoys writing, teaching and speaking about the things he works with. He was also involved as an SME for Microsoft certification development. He currently juggles his full time job as Lead Architect while speaking at local and foreign events, along with regular stints at the Sri Lankan Data Community which he co-founded.
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.
Sponsors
The following is a list of sponsors that helped fund the event: