Welcome 29 June 2021 Monthly SQLPASS Nepal Sessions
SQL Server Load Balancer with Peer-to-Peer Replication
Abstract: Many organizations require robust high availability and scalability solutions for their database implementations. Peer-to-peer replication is one of the most powerful tools in SQL Server, enabling both high availability and scalability. Join this session to learn what every DBA and system architect should know about this technology.
You will learn how to leverage peer-to-peer replication in real-life scenarios, seeing how replication can provide an optimal solution for many business requirements. We will also walk through best practices and see tips and tricks for easy implementation and maintenance of peer-to-peer replication.
Presenter: Nutan Marasini
IT Executive at SARANG InfoTech Pvt. Ltd. is a Microsoft Certified Trainer. He is MCT, MCITP (DBA), MCPD, MCTS MCP, Trainer, and Speaker. He is Microsoft Certified since 2003 in dot net, SQL Development- Administration and SQL Server Business Intelligence. He has Technical Skills on Microsoft Share Point, PHP, My-Sql and many other technologies. He has done more than 100+ Technical Presentation on Microsoft Technology and Product at different places. He is a good Trainer and Speaker. He has delivered various sessions in SQL User Group. He has trained 2000+ people in Microsoft Products and Technologies. He also delivers MCTS and MCPD training on ASP dot net at premier Training Institutes of Kathmandu Valley. He is also an expert trainer for corporate professionals on MCITP DBA (Development, Administration, BI) and SharePoint, He has done Masters in Business Studies from Tribhuvan University. He is a global certified in various technologies.
SQL Server Locking and Blocking
Abstract: Understanding locking mechanism in SQL Server is as important as knowing how to write T-SQL and how the data being accessed via indexes. This session, we will reveal the locking behaviour of SQL Server while reading and modifying the data under different circumstances. From there, we will explain all Transaction Isolation Levels in SQL Server using locks!
Presenter: John Huang
John Huang is an independent SQL Server consultant based on Vancouver, British Columbia, Canada. He obtained SQL Server MCM (Microsoft Certified Master) in early year 2009 and has been awarded as MVP in last 2 years. He spoke in many events in US and Canada including SQL Saturdays, Tech Days Canada, DevTech, Tech Fest, as well as many local SQL Server chapters. He’s also the leader Victoria SQL PASS Chapter in BC, Canada.
LinkedIn: http://ca.linkedin.com/in/johnhuangca
Maintain Your DBs (with Help from Ola Hallengren) (Duration 60 minutes)
Abstract: One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's Maintenance Solution. It is a one-stop package to Backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.
Presenter: Shree Prasad Khanal
Shree Khanal is a Database Architect, Speaker and Trainer having 10+ years of professional experience on database solution development and optimization. He is Microsoft Certified Database Professional from SQL Server 2000 to 2012. Since working with SQL Server 7, he has been working with all the version of SQL Server up to 2012 in production environment. In context of OLAP cube development, he started working on it from SQL Server 2000 to latest SSAS 2012. He has worked number of years providing SQL BI solutions to various enterprise clients most of them from BFI sector. He founded and has been leading the Himalayan SQL Server User Group (www.sqlpassnepal.org) based in Kathmandu, Nepal.
LinkedIn: http://np.linkedin.com/in/shreekhanal
Program Details:
Date: 29th June, 2013
Time: 1:00 P.M
Venue: Sanima Bank Limited Alakapuri, Naxal Kathmandu, Nepal
Or mail to [email protected]
Location:
Sanima Bank Limited Alakapuri, Naxal Kathmandu, Nepal
Event start: 6/29/2013 1:00:00 PM