SQL Saturday Nepal 2017

Guy-Glantser, 2017-12-23


I had the honor to visit Nepal and participate in SQL Saturday Nepal 2017. You can visit the event website here. I presented a session about “How to Use Parameters Like a Pro and Boost Performance”. From my experience, one of the common reasons for poor performance is the wrong use of parameters in queries. In this session, I demonstrated how to identify these cases and how to correctly use parameters in order to boost application performance.


The Nepali people are very kind. I had a great audience – around 100 people – and I enjoyed presenting this session very much. I would like to thank my wonderful audience for participating in my session. If you attended my session (and also if you didn’t), you can download all the session materials from here.


In addition to my session, there were several other excellent sessions. Gogula Aryalingam presented a session about the “Why, What and How of Power BI”. Virendra Yaduvanshi presented a session about the SQL Server transaction log. Jonathan Stewart (whom I had the pleasure to spend some quality time with) presented a session about “Performance Tuning for the BI Professional”. Anil Maharjan presented a session about data visualization with R in Power BI. And finally, Shree Khanal, who did an excellent job in organizing this event, presented a session about “SQL Server 2016 Advanced Security”.


But even before the event itself, which took place on Saturday, I had the honor to deliver two full day pre-conference sessions. The first was about big data and Hadoop fundamentals. The second was about SQL Server best practices. I had a wonderful time, and I enjoyed the interaction with the audience.


SQL Saturday Nepal 2017


Special thanks to the organizers of SQL Saturday Nepal 2017 – Shree Khanal, Dibya Tara Shakya, and all the others. Thank you for inviting me and for the wonderful hospitality. Now that the event is over, I look forward to another week in Nepal. I’m going to do some trekking with Shree, Jonathan and others.





The post SQL Saturday Nepal 2017 appeared first on Madeira Data Solutions.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads