Event Location:
Hotel Himalaya
Sahid Shukra Marg
Kathmandu, Central Region, Nepal
Abstract:
Receiving imperfectly column-aligned data from applications is becoming a norm. However preparing this data for pre-defined relational structures using traditional methods is becoming significantly complex. Many implementations though, still handle this using traditional programming techniques - but isn't this still a database related task? And shouldn't the components of the Database Management Systems bear the responsibility of getting this done? With new features incorporated into modern database platforms, processing unstructured data is no longer a challenge, and can be performed easily. Let us take a sample data set and see how we do this the Microsoft way, of course using Microsoft SQL Server product suite including cloud offerings such as HDInsight.
Speaker(s): Dinesh Priyankara,
Abstract:
Hosting and administration of large databases presents many challenges. These databases require powerful hardware to operate, and thoroughly designed maintenance, HA and DR strategies to meet SLAs. Even though data retention policies are controlled by business requirements, this session will review the following techniques and best practices that can be applied to reduce the size of the data in a database and improve performance of the system. 1. Reducing internal index fragmentation in the system 2. Implementing ROW and PAGE Data Compression 3. Compressing LOB Data on the client and/or with CLR routines 4. Detecting and removing unused and redundant indexes 5. Following best practices in Database Design and Deployment, such as enabling Instant File Initialization, disabling Auto-Shrink and choosing correct data types based on business requirements. 6. Releasing free space from the data files
Speaker(s): Dmitri Korotkevitch,
Abstract:
Even though in-memory OLTP can significantly improve performance of OLTP systems, it comes with an extensive set of limitations that often make refactoring of existing systems cost-ineffective and prevents widespread adoption of the technology. However, in-memory OLTP can be beneficial in other common use cases besides replacing on-disk with memory-optimized tables. This session discusses several of these use-cases: * Improving performance of ETL processes and stored procedures with memory-optimized tables * Using the in-memory OLTP engine as a replacement for the distributed cache and session state server * Enhancing performance of batch import operations with memory-optimized TVPs Finally, this session shows several techniques that help address in-memory OLTP limitations, such as 8,060 byte maximum row size and missing unique and FK constraints
Speaker(s): Dmitri Korotkevitch,
Abstract:
The session is mainly for the one who is trying to extract the story behind their Facebook data by using Power Query. By using Power Query you can extract your Facebook data easily and do analysis your own story by using your own Facebook data. Talking about Power Query: Microsoft Power Query for Excel is an Excel add-in that enhances the self- service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. Power Query can connect data across a wide variety of sources, where Facebook is one of the data source. This session helps you to learn about the Power Query, Power View, and Power BI and mainly helps you to do self-service BI by using your own Facebook data with the help of Power Query, Power View and MS-Excel 2013.
Speaker(s): Anil Maharjan,
Abstract:
Data partitioning is a valuable technique that simplifies database administration tasks and helps meet availability and performance SLAs. In this session, Dmitri will cover several techniques and architectural approaches you can use to partition data in the different versions and editions of SQL Server. You will learn about partitioned tables, partitioned views and stretch databases introduced in SQL Server 2016. Finally, Dmitri will discuss the practical questions, such as how to move data between filegroups and disk arrays keeping tables online and how to address some of performance issues caused by data partitioning.
Speaker(s): Dmitri Korotkevitch,
Abstract:
advanced HA and DR architectures for SQL Server that also enable you to scale-out certain workloads. This will include design patterns and configuration best practices for Availability Groups (AG) and Failover Cluster Instances (FCI) across different sites as well AG replicas between FCIs.
Speaker(s): Shree Khanal,
Abstract:
The recent past has shown us how the business intelligence landscape is shifting away from an IT-led paradigm to a business-led paradigm. This paradigm attempts to put the power of data in the hands of users for self-service. Power BI is Microsoft's self-service business intelligence offering, and is now standing out as a leader in self-service business intelligence. Join this session to learn what Power BI is all about and its capabilities. We'll then move over to various usage scenarios and how Power BI helps save the day.
Speaker(s): Gogula Aryalingam,
Abstract:
Cardinality estimator providing row estimates, plays a pivotal role in obtaining efficient query plans. Cardinality Estimator algorithm which remained unchanged since SQL 7.0, was revamped in SQL Server 2014. The presentation will take a ride through the new cardinality estimator, showcase the need for the significant redesign and demonstrate the new cardinality estimator's efficiency at different scenarios. Presentation will also cover how one can perform regressive testing, checking for any performance degradation on new cardinality estimator and how they can be handled gracefully.
Speaker(s): Nagaraj Venkatesan,
Abstract:
Generally SQL DBAs found very good in managing SQL server standalone instances but for managing SQL server on cluster requires altogether new skills. The difference stats right from installation planning and then implementing and finally troubleshooting. This session will be focused on following topics: What is Windows cluster and how it work. How SQL server works on Windows clusters. How to install, configure, perform maintenance and troubleshoot SQL server on Windows Cluster.
Speaker(s): Satya Prakash,
Abstract:
Cloud and Cloud Computing
Speaker(s): Gurvesh Singh,
Abstract:
With Power BI one can perform business intelligence without having to invest in the big bucks that is usually involved with it. With Power BI one does not have to be a "techie" to BI. This session would first focus on theory on the various use cases of Power BI. It would then move over to demos and hands-on of how to build a Power BI solution: query and build a data model from a variety of data sources; report and collaborate on the data; and more...
Speaker(s): Gogula Aryalingam,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
LinkedIn: http://www.linkedin.com/in/gogula
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.
LinkedIn: http://www.linkedin.com/in/gogula
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.
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
Founder and CEO of Ucloud. Nepal#39;s first Cloud Service Provider
LinkedIn: http://lk.linkedin.com/in/dineshpriyankara/
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
LinkedIn: http://np.linkedin.com/in/shreekhanal
Contact: http://www.sqlhelps.com
Shree Khanal is a Database Architect, Speaker and Trainer having 15+ years of professional experience on database solution development and optimization. Mr. Khanal is a Data Platform MVP Microsoft Certified Database Professional since 2000 to till date. Starting with SQL Server 7, he has been working with all the version of SQL Server up to 2016 in production environment. In context of OLAP cube development, he started working on it from SQL Server 2000 to latest SSAS 2016. He has worked number of years providing SQL BI solutions to various enterprise clients most of them from BI sector. He founded and has been leading the Himalayan SQL Server User Group (www.sqlpassnepal.org) based in Kathmandu, Nepal since 2010.
LinkedIn: http://np.linkedin.com/in/maharjananil
Contact: https://anilmaharjanonbi.wordpress.com
Anil Maharjan is Microsoft Data Platform MVP, Has more than 9 years of development implementation experience in HealthCare Data Analytics, Telecommunication Industry. • Published article, frequent Blogger and speaker at Microsoft Ignite Singapore - 2019, Data and BI Summit 2018 -Dublin, Power Platform Australia Summit 2019, SQL Saturday , SQLServer2016 Discovery Day, SQLServerGeeks Annual Summit , SQL Server User group , Nepal Power BI User Group Meetup and other SQL Events. • Organizing member at Himalayan SQL Server User Group • User Group Leader Nepal Power BI User Group • Program Committee member for PASS Summit 2014 • Program Committee member for DATA and BI Summit 2018 and Power Platform Australia Summit 2019 .
LinkedIn: https://in.linkedin.com/in/nagaraj-venkatesan-b6958b6
Contact: http://strictlysql.blogspot.com
Nagaraj Venkatesan is a Data Platform MVP from Singapore and the leader of Singapore SQL PASS Chapter. As a SQL Server enthusiast, Nagaraj is a regular speaker in Asia Pacific region at Data Platform events like SQL Saturdays, SQL Server Geeks Summit, User group meetups etc. Nagaraj shares his technical expertise at strictlysql.blogspot.com. Nagaraj also runs a YouTube channel called "DataChannel", which contains technical interviews with top Microsoft Data Platform experts in the world.
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
LinkedIn: https://www.linkedin.com/in/satyasql
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.
The following is a list of sponsors that helped fund the event.