www.sqlpass.org    Professional Association for SQL Server
 Welcome

Welcome to the Canberra SQL Server User Group

An Australian based group of like minded individuals interested in all aspects of the Microsoft SQL Server database platform.

The Canberra SQL Server User Group usually holds meetings on the first Tuesday of the month from 16:30 to 18:30 at the Canberra Microsoft Offices located at;

Level 4, 6 National Circuit
Barton, ACT, 2600

You can also subscribe to our meeting RSS feed at feeds.feedburner.com/csqlsug

 

 Next Meeting
Topic: Bring your metadata to life with BimlScript in the Real World
Date: Tuesday May 6, 2014 at 16:30
Speaker: Peter Avenant
Venue: Canberra Microsoft Offices
Registration: Eventbrite

THE MEETING VENUE HAS MOVED


Microsoft Canberra have moved offices a few blocks away from where they previously were.

The Microsoft Canberra address is now;
Level 4, 6 National Circuit, Barton, ACT

Note that there is only lift access to the 4th floor, no stairs. The building lifts stop public access at 5pm so if you have not gotten on to the 4th floor by 5pm then you will not be able to get to the 4th floor. I do not have a lift pass so cannot come and get you.

Nearby parking, however, is much better than at the old venue.

Presentation Details

Beyond Integration with BimlScript
Peter will introduce the various BimlScript directive and code nugget types. He will also discuss the high-level process by which BimlScript code is expanded to automatically create large quantities of Biml code. This will be a combination of PowerPoint slides and live demonstrations.

Bringing It Together in the Real World
Peter will talk about a real-world solution that they have built for a customer, walking through a fully featured production framework and the code it generates. This will be a live coding session that will demonstrate creating and loading a staging environment from scratch.

Creating your own metadata framework
Peter will explain what you require to build your own metadata framework and demonstrate a fully automated ETL development process.



Please register for this event to help us cater for pizza and drinks.

Also, in order to celebrate the recent release of SQL Server 2014, we will be holding a mini-launch event at 16:45 prior to Peters presentation. There will be some SQL related giveaways for those who can make it for this.



You MUST arrive for the meeting before 17:00 as the building lifts require pass access after that time. I do not have a lift pass so cannot come down to get you if you are late. (this is important so I've said it twice)

Speaker Biography
Peter Avenant is a business intelligence consultant, database developer and certified Biml developer. He has been working with SQL Server for a decade, working primarily in ETL/SSIS, database development, reporting, and data quality. He has co-founded Avelytics, currently the only certified Varigence partner in Australia. Peter has spoken at international, regional, and local venues specifically on Biml.
 Announcements

SQL Server 2014 has been released.

Get a trial version here

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.
 Next Meeting Countdown
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif