SQLSaturday #692 - Nepal 2017
Event Date: 12/23/2017 00:00:00
Event Location:
- Hotel Yellow Pagoda
- Kantipath कान्तिपथ मार्ग, Kathmandu, Nepal
- Nepal, , Nepal
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: BI for Everyone: Why, What and How of Power BI
Abstract: Business Intelligence has been around for a long time, however a lot of BI projects have failed than have succeeded*. Despite knowing its shortcomings, only as of recent, have we had the right tools to make BI succeed. This session will focus on a very short history on how BI came into being and reasons for most failures. We will then look at the new wave of BI concepts and tools, and how it could help build better business intelligence solutions, and why Power BI is a tool of choice out of these. We will finally take a look at how the two main focus groups, business users and technical folk, can make use of Power BI, the part they have to play, and what they need to know, and how together they could build better business intelligence for everyone.
Speaker(s):
- Gogula Aryalingam
Track and Room: BI Platform Architecture, Development Administration - Conference Room
Title: How to Use Parameters Like a Pro and Boost Performance
Abstract: Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren’t aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance. In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.
Speaker(s):
- Guy Glantser
Track and Room: Application Database Development - Conference Room
Title: PowerBI : Data Visualization SQLSaturday with R
Abstract: This session is mainly use to learn more about Power BI and R visualization chart. From this session one can learn how can we make some simple and quick visualization using Power BI desktop taking real SQLSaturday data and publish in PowerBI cloud service and also publish those visualization reports to publicly in web. Also, this session mainly helps to tell the story of SQLSaturday by using Power BI and R visualization chart.
Overall, by using Power BI Visualization how one can find out which SQLSaturday is conducted in which state or country in which year and a particular Day along with total sessions conducted. Also one can find SQLSaturday trends year on year and mostly in which month most of SQLSaturday is conducted as per SQLSaturday data history. So, this session will surely help one to learn regarding Power BI and its capabilities and SQLSaturday Stories.
Speaker(s):
- Anil Maharjan
Track and Room: BI Platform Architecture, Development Administration - Conference Room
Title: Understanding SQL Server’s transaction log and how to manage it.
Abstract: let try to understand Internals of SQL Server transaction log and learn how to manage it.
Speaker(s):
- Virendra Yaduvanshi
Track and Room: Database Administration - Conference Room
Title: Performance Tuning for the BI Professional
Abstract: Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.
Speaker(s):
- Jonathan Stewart
Track and Room: BI Platform Architecture, Development Administration - Conference Room
Title: SQL Server 2016 Advanced Security
Abstract: In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB. These include Always Encrypted, Row-Level Security and Dynamic Data Masking as well as whatever else Microsoft has released since I’ve written this abstract. We’ll look at how to set these features up, how to use them, and most importantly when to use them.
Speaker(s):
- Shree Khanal
Track and Room: Database Administration - Conference Room
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Virendra Yaduvanshi
Twitter: - https://twitter.com/v_yaduvanshi
LinkedIn: Virendra Yaduvanshi
Contact: https://wikidba.net/
https://wikidba.net/
Guy Glantser
Twitter: - guy_glantser
LinkedIn: Guy Glantser
Contact: https://www.madeiradata.com/blog
Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS Local Group, as well as the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant, or a speaker. His main area of expertise is SQL Server development and optimization. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQLSaturdays, and user groups around the world. He also co-hosts the SQL Server Radio podcast.
Anil Maharjan
Twitter: - Anil_Maharjan
LinkedIn: Anil Maharjan
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, SQLSaturday , 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 .
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
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.
Shree Khanal
Twitter: - shreekhanal
LinkedIn: Shree Khanal
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.
Sponsors
The following is a list of sponsors that helped fund the event: