SQLPASS Nepal September Monthly Meetup
Data modelling for data analysis and cubes
Abstract: Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports.
In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimise it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.
Presenter: Alex Whittles
Alex is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy with multinational clients in a variety of sectors from banking to aerospace and telecoms. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack. Alex has an MSc in Business Intelligence, runs the Midlands SQL Server User Group and the Birmingham SQL Relay conferences, and is a regular speaker at many SQL Server events around Europe.
High Availability and Disaster Recovery with Hyper-V
Abstract: In this session Naresh Man Maharjan will walk through all the key features in High Availability and Disaster Recovery with Hyper-V. This will include details about Physical and Virtual Scalability, Hyper-V High Availability, High Availability with Guest Clustering, Guest Clustering across Physical Hosts and Virtual Machines, Hyper-V Replica| Extended Replication, Redundancy Technologies Comparison and DC| DR Solution with Hyper-V.
Presenter: Naresh Man Maharjan
Naresh Man Maharjan is the senior System Administrator at Himalayan Bank Limited for the last 5 years. He is considered a top IT professional at Nepal. He obtained this status by continuously blogging on http://www.msserverpro.com, conducting IT trainings/seminars, and improving his knowledge and information in the field of information technology. Currently, he holds more than 30 IT certifications, including MCP (since 2004), MCSA: Security/ Messaging on Windows Server 2003, MCSE: Security/ Messaging on Windows Server 2003, MCTS: Microsoft Exchange Server 2007/ 2010, Microsoft ISA Server 2006, Windows 7, Windows Small Business Server 2011, Windows Server 2008, MCITP: Enterprise Messaging Administrator 2007/ 2010,MCITP: Windows Server 2008: Server Administrator /Enterprise Administrator, Microsoft Certified Solution Associate: Windows Server 2008 / 2012, Microsoft Specialist: Server Virtualization with Windows Server Hyper-V and System Center Specialist, MCTS: Administering and Deploying System Center 2012 Configuration Manager, Microsoft Certified Solutions Expert: Messaging, Microsoft Certified Solutions Expert: Private Cloud, CCNA, CISS, Cisco ASA Specialist and CEH 6.0. He has previously worked on Rastriya Banijya Bank Limited as a Network Support Officer for 4 years and 2 months, and Mercantile Communications PVT. LTD. as a Network Administrator for 17 months. Naresh holds a Bachelor of Science in Network Technology (BSCNT) from Sikkim Manipal University.
Using SQL Servers AlwaysOn Availability Groups
Abstract: We will look at the features which are provided with Microsoft SQL Server 2012 and 2014 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.
Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database. We will also look a unique use case using SQL Server 2012's Always On feature to scale out the reads to synchronous read only copies.
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.
LinkedIn: http://np.linkedin.com/in/shreekhanal
Sponsors (Swag and Books): The event was sponsored by Mercantile, DevExpress, Telerik, SQLSmash, MsSQLtips, Devexpress, Telerik, Devart, Nevron, Learnnowonline, Pluralsight, Udemy, Packt Books, Wrox Book and Oreilly Books supported us with door prizes for the event.
Location:
Program Details:
Mercantile Office Systems Pvt. Ltd, Durbar Marg, Kathmandu, Nepal
Date: 27th September, 2014
Time: 1:00 P.M
Event start: 9/27/2014 1:00:48 PM