BEGIN:vCalendar METHOD:PUBLISH BEGIN:vEvent DTSTART:20140726T133003Z DTSTAMP:20140923T093433Z LOCATION:Program DetailsNormal0falsefalsefalseEN-USX-NONESA /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-ansi-language:EN-IN; mso-fareast-language:EN-IN;} Date:      26th July, 2014 Time:     1:30 P.M Venue: Mercantile Office Systems Pvt. Ltd, Durbar Marg, Kathmandu, NepalNormal0falsefalsefalseEN-USX-NONESA /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-ansi-language:EN-IN; mso-fareast-language:EN-IN;} DESCRIPTION:v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}About the presentation\nHigh Availability Solutions in the Database\nAbstract: 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.\n\nPresenter: Suresh GautamOver 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.\n\nStorage for the DBA\nAbstract: 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.\n\nPresenter: Shree Prasad Khanal\nShree 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.\nLinkedIn: http://np.linkedin.com/in/shreekhanal\nv\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}Normal0falsefalsefalsefalseEN-USX-NONESA/* Style Definitions */table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-ansi-language:EN-IN;mso-fareast-language:EN-IN;}Intro into Locking, Blocking and Concurrency Model in SQL ServerAbstract: 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 Normal0falsefalsefalseEN-USX-NONESA/* Style Definitions */table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-ansi-language:EN-IN;mso-fareast-language:EN-IN;}Normal0falsefalsefalsefalseEN-USX-NONESA/* Style Definitions */table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-ansi-language:EN-IN;mso-fareast-language:EN-IN;}Normal0falsefalsefalsefalseEN-USX-NONESA/* Style Definitions */table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-ansi-language:EN-IN;mso-fareast-language:EN-IN;}\n\n\nProgram Details\nNormal0falsefalsefalseEN-USX-NONESA/* Style Definitions */table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-ansi-language:EN-IN;mso-fareast-language:EN-IN;}Date:      26th July, 2014\nTime:     1:30 P.M\nVenue: Mercantile Office Systems Pvt. Ltd, Durbar Marg, Kathmandu, NepalNormal0falsefalsefalseEN-USX-NONESA/* Style Definitions */table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-ansi-language:EN-IN;mso-fareast-language:EN-IN;} SUMMARY:SQLPASS Nepal July Monthly Meetup PRIORITY:3 BEGIN:vAlarm TRIGGER:P0DT0H15M ACTION:DISPLAY DESCRIPTION:Reminder END:vAlarm END:vEvent END:vCalendar