www.sqlpass.org    Professional Association for SQL Server

Perth SQL Server User Group


We have meetings once a month on a Thursday. As of September 2013 the group will be meeting at the Enex 100 Seminar Room at 100 St George's Terrace.

We use EventBrite for meeting registrations - check out http://pssug.eventbrite.com/ for a list of our previous events. Anyone is welcome to register, but please let us know at the meeting if you want to be added to the mailing list so you get email notifications of upcoming events.

We are always looking for local speakers, so if you want to try your hand at presenting feel free to let us know!

-- Jenny


 Next Meeting
Topic: SQL 2014 In-memory for the Developer
Date: Thursday 21st August, 5.00pm-7.00pm

Bhavik Merchant & Harish Saini


In this session we will begin with a brief introduction of the history of SQL Server and the new features in SQL 2014. The presentation will then dive into details on in-memory such as its structure and implementation. We will then configure the database to support in-memory and look at how to create and populate in-memory tables. From a code perspective we explore how to query and work with in-memory data including existing and natively compiled stored procedures. A performance comparison will be made so that the benefits are apparent. There will be coverage on limitations and caveats and we will finish off with potential practical applications of this technology.

Speaker Bio:

Bhavik Merchant

Bhavik is the National Practice Manager for Microsoft Business Intelligence at NEC Australia. He is a specialist across all areas of data warehousing, analytics and performance management with almost 10 years of experience in the field. His time is split between growing NECs business nationally and performing hands on strategic and technical consulting. As such he engages with customers to assist with anything from strategy development and data modelling to tool selection, implementation and performance tuning.

He speaks regularly at public events and has presented theatre sessions at Microsoft TechEd and topics at various Sharepoint Saturday and SQL Saturday conferences around Australia. He also presents at SharePoint and SQL Server User Groups and for the PASS BI Virtual Chapter. In addition, Bhavik has been delivering formal training for over 5 years on various aspects of Business Intelligence, particularly for the Microsoft platform (SQL Server, SharePoint, PowerPivot). Bhavik and a colleague at NEC have also recently started the Moden Excel User Group on Meetup in an attempt to share knowledge and best practice on self service BI tools and techniques.

Harish Saini

Harish is a Business Intelligence Solutions Architect who works for NEC Australia. He has over 20 years of experience in Microsoft Technologies. In the last 6 years he has shifted his focus on delivery of BI Solutions and has end-to-end experience across the Microsoft BI Stack. A significant part of his work involves developing database solutions and tuning SQL servers and queries.

Harish has been delivering formal training for over 2 years on SSAS, SSRS, SSIS and SQL Server. He holds a number of Microsoft Certifications, including MCSE - SQL 2012 BI and MSCA – SQL 2012.

Register: https://www.eventbrite.com/e/pssug-sql-2014-in-memory-for-the-developer-bhavik-merchant-harish-saini-tickets-12595436289


The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.


PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall dba provides us with catering each month.