Getting Started with Azure DW
Azure SQL Data Warehouse is the truly elastic cloud data warehousing service which went to RTM June 2016. Come along to hear some early adoption experience and how to get started.
- Introducing the ADW technology
- Explaining distributions, performance etc
- Explaining polybase
- Performance tips & tricks (designing for minimal data movement, managing distribution skew, CTAS etc)
- ETL Patterns (Surrogate keys, Orchestration)
We are transitioning from eventbrite to meetup.com. Please pop across and check out the meetup site http://www.meetup.com/SQLIreland/events/233057408/
Note: This session is on a MONDAY rather than the regular Tuesday!
Principal BI Consultant with Adatis. Simon has been working with the Microsoft BI Stack for a decade, starting off building traditional warehouses with SSIS and SSAS but bringing in alternative technologies where needed. Simon is a strong advocate of the use of modern development practices in the SQL World (we actually are developers, whether we like it or not). Most recently, he has turned his head to the clouds, advocating new methods of getting insight to the right people. Whether it's getting to grips with Data Lakes, to shifting your current SSIS packages into the cloud, hopefully he can help.
When & Where
SQL Server Ireland User Group
The SQL Server Ireland User Group was founded in 2006 to foster & grow the Irish SQL Server community while providing networking opportunities & sharing experiences using SQL Server.
This group is a local chapter of PASS - The Professional Assosciation for SQL Server (www.sqlpass.org)
Meetings are held most months, usually in the evening of the first Tuesday of the month. We do collaborate with others to support larger conference events from time to time; including the highly successful SQL Saturdays.