Welcome to SQLSaturday #382
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Mar 28 2015 at the Australian Institute of Management (AIM), Cnr Boundary and Rosa Streets, Springhill, Australia. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.
Pre-Con - Registration now open!
As part of the SQLSaturday event in Brisbane for 2015, we have 2 Pre-con sessions available and live for registrations. The Pre-con events will be held in Brisbane on Friday the 27th March, 2015 at the Australian Institute of Management (AIM).
Understanding SSIS Internals and Performance Tuning with David Peter Hansen
You have worked with SQL Server Integration Services (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while other are taking up more memory and CPU than before.
The first part of this full-day session will cover the internals of SSIS.
Starting with an overview, we will move into the details of the control flow
engine and the data flow engine. At the end of the internals section, you will
have a deep understanding of the strengths and weaknesses of SSIS and what is
the best way to design your packages.
The second part will cover the architecture of the SSIS Server, which
came with SQL Server 2012. We will dive into the SSIS catalog and the host
process used to execute the packages.
The third part will cover how we can use the knowledge about the
internals of SSIS to gain better performance. This part will show practical
examples of common performance problems, and how these can be solved.
Furthermore we will look at how designing and tuning your data flows can
increase performance significantly.
About David Peter Hansen
David Peter Hansen is a Microsoft Certified Master (MCM),
Microsoft MVP, and has over a decade of experience with data development and
administration on SQL Server and Microsoft Business Intelligence platform.
Today he works as a Consulting Manager for Advectas Denmark. He specializes in
scalable architecture and performance tuning on large-scale Data Warehouse and
BI Solutions. He is a frequent speaker at conferences, and has given talks in
Europe, USA and Africa. (PASS Summit, SQLBits, PASS SQLRally Nordic, PASS
SQLRally Amsterdam as well as numerous SQLSturday events and User Groups)
Actionable Visualisation in Power BI - Essentials with Julie Koesmarno
Historically, users have been constrained to consume data in fixed
platforms, with one specific dimension for digital viewings and a couple of
printed layouts. Nowadays, with the ubiquitous mobile devices available,
Management expects to know key business indicators and day-to-day operation
performance on the go. Using well-designed data models and visualization
techniques, Power View can leverage timely and quick dashboards for analysis on
the go. Meanwhile, Pivot Tables and Pivot Charts in Excel can also provide
greater insights both in the desktop and online version. Power BI Q&A
can visualise data based on a natural language question using
advanced indexing technique of Power BI. Power Map can provide custom 3D as
well as geographical analysis.
This session will discuss how to design the appropriate data models to
enable self-service data exploration and insightful analysis in Power BI, and
how to create pixel perfect visualization for mobile devices. You will also
learn how the techniques differ from traditional platforms. We will discuss
fundamental data visualisation principles, business requirements
gathering techniques and data modeling tips/tricks. Using live demo, we will
walk through ways to channel users focus on actionable analytics on
operational, strategy and analytical dashboard use cases.
Featuring a full day workshop packed with demos, our aim is to introduce
patterns as well as tips and tricks to build
data visualisation solution using Power BI both for online and
Julie Koesmarno, SQL Server MVP, MCSE Data Platform, MCSE
Business Intelligence, is a SQL Server and BI Consultant, with a Bachelor's
degree in IT. She has over 10 years of experience working with SQL Server for
large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server
developer and system analyst/designer. Her recent projects include delivering a
SQL Server 2012 Data Warehouse and BI Solutions for a number of high profile
clients in the US and Australia.
Free street parking is available on Saturday's on Boundary St.
There is no onsite parking.
Central Station is just under one kilometer from AIM, which is about a 10 minute walk (uphill).
From Central Station, take Upper Edward St (runs into Little Edward St) and turn right onto Boundary St.
Where to Stay
The following accommodation options are all walking distance to AIM:
The Ridge on Leichhardt
Metropolitan Motor Inn
What's on in Brisbane in March?
Eat Street Markets
Kylie Minogue - Kiss Me Once Tour - Brisbane 21 March 2015
Brisbane Comedy Festival
Super Rugby - QLD Reds v Lions
Wicked - The Musical