Welcome 28 December, 2013 Monthly SQLPASS Nepal Sessions
SQL Server Transaction Log Internals
Abstract: The transaction log plays the most critical role in any SQL Server database. In this session, you’ll learn the importance of the transaction log and go inside the roles it plays inside the database engine. You’ll see how logging and recovery work, explore the checkpoint process and write-ahead logging, and walk through the steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database.
Presenter: Anil Krishnan
Anil Krishnan is a regular presenter at Himalayan SQL Server User Group. Currently he works as a Database Support Engineer at MyDBA Nepal Pvt. Ltd. He works for Performance Tuning and Optimization. He worked at Verisk Information Technologies Pvt. Ltd. For 2yrs from Nov 2010 - Oct 2012 as Software Engineer. He passed his bachelor’s degree in Information Management from St. Xavier's College. He is a former Microsoft Student Partner.
LinkedIn: http://np.linkedin.com/in/krishnananil
Tempdb: Performance and Manageability
Abstract: Misconceptions and inconsistent advice on tempdb abounds – even highly skilled DBAs cannot always agree on how to best configure it. Part of the problem is that there is no single solution that can be applied to every situation. How many files should tempdb have? Should it be on RAID 1? RAID 10? How about Solid State Drives (SSDs)? This session will give you the tools to determine the optimal configuration for tempdb. We'll also cover how to detect, prevent, and monitor for common tempdb performance problems
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 BI 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
SQL Server 2012 Recursion in MDX
Abstract: Recursion is an iterative process in which the evaluation of a value requires the execution of the same calculation using a different parameter. Once this process starts, it keeps repeating itself until a stopping condition occurs. The stopping condition occurs when the value being evaluated does not trigger another recursive call to the same calculation.
In this session you'll learn how to create recursive calculations in MDX, both the simple and the complex ones. You will also learn how they work and when it can be beneficial to use them. The session will end with an overview of the advantages and disadvantages of using recursive MDX calculations
Presenter: Tomislav Piasevoli
Tomislav Piasevoli is a Business Intelligence (BI) Specialist with a decade of experience working with SQL Server Analysis Services (SSAS). He successfully implemented many still-in-use BI solutions, achieved the highest certification for SQL Server Analysis Services (SSAS Maestro) and shared his expertise in form of a book named MDX with SQL Server 2008 R2 Analysis Services: Cookbook published in 2011 by Packt Publishing Ltd. Tomislav currently specializes in dimensional modeling, cube design and MDX consulting worldwide and can be contacted at [email protected]
In addition to his regular work, Tomislav also finds the time to present at local conferences and to occasionally write an article or two for local magazines or on his blog. His contribution to the community has been recognized by Microsoft honouring him with the Most Valuable Professional (MVP) award every year since 2009.
Sponsors (Swag and Books):
The event was sponsored by Pluralsight, Redgate, Packt Publishing, Wrox Book and Oreilly Books supported us with door prizes for the event.
Location:
Date: 28th December, 2013
Time: 1:30 P.M
Venue: Braindigit Solution, Gyaneshwor - 33 Kathmandu, Nepal (opposite to petrol pump at Gyaneshwor)
http://sqlpassnepal.org/Meetings/Welcome-28-December,-2013-Monthly-SQLPASS-Nepal-Se.aspx
[email protected]
Event start: 12/28/2013 1:30:00 PM