Previous Meetings
Dec 2011 - Peter Myers - Developing an Analysis Services Tabular Project BI Semantic Model
SQL Server PowerPivot, first released with SQL Server 2008 R2, empowers business users to create their own tabular data models in Excel 2010. In this presentation you will learn how the features of PowerPivot have been enhanced to support the creation of more sophisticated data models, and that these and additional features are available to the developer to create and secure larger scale solutions.
This presentation is targeted at IT professionals with an interest in data analysis and equally for non-IT professionals interested to understand and evaluate the new data modelling capabilities delivered in the upcoming release of Analysis Services. Those with a background in PowerPivot and/or developing Analysis Services Unified Dimensional Models will benefit from a comprehensive overview of the new data modelling capabilities, theory and discussion to understand when each modelling choice is appropriate.
Note: All theory and demonstrations will be based on the latest publicly available version of SQL Server 2012 (formerly Code Name “Denali”) which for Analysis Services is considered to be feature complete.
About the Presenter
Peter Myers has 13 years' solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server.
Specializing in Microsoft Business Intelligence, Peter provides mentoring, technical training and course content authoring for SQL Server and Office. Specifically he works with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot and PerformancePoint Services.
He has a broad business background supported by a bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been an MVP since 2006.
Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft technologies by presenting at user group meetings, technical events and conferences.
Venue: Microsoft Brisbane, Level 28/400 George Street
Duration: Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
On: Thursday, 15th December 2011
RSVP: to contact@wardyit.com will help with catering
Thursday 15/12/2011 05:30:00 PM
Nov 2011 - Russ Blake - SQL Server 2012 Crescent: BI Candy or BI Core?
About the Presenter
Russ Blake is the inventor/author of the Windows Performance Monitor (Perfmon), and author of the book “Optimizing Windows NT”. Prior to settling in Brisbane, Russ worked at Microsoft for 8 years, and was a Senior Researcher in Microsoft Research. He holds three US patents in software and one Chinese patent, and has written numerous technical articles. Russ consults for Readify Pty Ltd specializing in SQL Architecture and BI solutions.
Venue: Microsoft Brisbane, Level 28/400 George Street
Duration: Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
On: Thursday, 24th November 2011
RSVP: to contact@wardyit.com will help with catering
Thursday 24/11/2011 05:30:00 PMOct 2011 - Peter Ward - Keeping the DBA out of the Database
With the regulations and compliance that many organisations are scrutinised with today, it is often no longer an option for a Database Administrator to be a member of the sysadmin Server Role. If you remove a DBA from the sysadmin Server Role then how do they manage the database platform and perform common administrative functions? In this presentation you will see how the Separations of Duties Framework can be implemented to assist in setting up a restrictive Microsoft SQL Server environment. The presentation provides practical demonstrations based on real-world experience working with classified information. Armed with this information you will be able to configure an environment that limits the processes a DBA can perform, whilst ensuring that they are kept out of the database and away from sensitive information.
About the Presenter
Peter Ward is the Chief Technical Architect of WARDY IT Solutions, a company he founded in 2005. WARDY IT Solutions has been awarded the Microsoft Data Platform Partner of the Year since 2009 and was a member of the 2010 Deloitte Technology Fast 500. Peter is a highly regarded speaker at SQL Server events, a sought after SQL Server consultant, and a trainer who provides solutions for some of the largest SQL Server sites in Australia. Peter has been recognized as a Microsoft Most Valuable Professional for his technical excellence and commitment to the SQL Server community.
Venue: Microsoft Brisbane, Level 28/400 George Street
Duration: Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
On: Thursday, 27th October 2011
RSVP: to contact@wardyit.com will help with catering
Thursday 27/10/2011 05:30:00 PM
