SQLPASS Nepal Oct 2016 Monthly Meetup
About the presentation
Over seven years of experienced IT professional with System and Database Administration skills across Oracle, MYSQL, MSSQL, MongoDB and Vertica. Graduate in Information Technology and Oracle Certified Professional and having the ability to take the technical lead in the projects and supporting technical implementation whilst working on multiple products and database environments. Proven ability to implement technologies and improve process that decrease costs, increase performance and positively affect the bottom line.
High Availability Solutions in the Database
Abstract: High Availability (HA) solution includes groups of computers that support server applications that can be reliably utilized with a minimum of down-time. They operate by redundant computers in groups that provide continued service when system components fail. HA solutions are often used for critical databases, file sharing on a network, business applications, and customer services which requires 24/7 up and running server environments. HA cluster implementations attempt to build redundancy into a cluster to eliminate single points of failure, including multiple network connections and data storage which is redundantly connected via storage area networks. There are several databases available in the market and most of them provides HA solution own way, though each of them would have own pros and cons. We will explore on the HA solutions offered by popular databases such as SQL Server, MYSQL, Oracle in the session.
Presenter: Suresh Gautam
Storage for the DBA
Abstract: One of the biggest issues in database performance centre’s around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server.
Presenter: Shree Prasad Khanal
Shree Khanal is a Database Architect, Speaker and Trainer having 12+ 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 BI sector. He founded and has been leading the Himalayan SQL Server User Group (www.sqlpassnepal.org) based in Kathmandu, Nepal.
Intro into Locking, Blocking and Concurrency Model in SQL Server
Abstract: In this session, Dmitri will talk about concurrency model implemented in SQL Server. He explains how SQL Server works with locks; how to troubleshoot blocking issues in the systems and, finally, will discuss how to improve concurrency in multi-user environment.
Presenter: Dmitri Korotkevitch
Dmitri Korotkevitch is a Microsoft SQL Server MVP, Microsoft Certified Master (SQL Server 2008) and author of “Pro SQL Server Internals” with almost 20 years of IT experience including over 14 years of experience working with Microsoft 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
Date: 29th Oct, 2016
Time: 1:30 P.M
Venue: Mercantile Office Systems Pvt. Ltd, Durbar Marg, Kathmandu, Nepal
Event start: 10/29/2016 1:30:03 PM