Nr: 382
SQLSaturday #382 - Brisbane 2015
SessionID: 11991
Introduction to Biml BimlScript
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Craig Bryden
Title: Introduction to Biml BimlScript
Abstract:
Within every Data Warehouse project there is always ETL development that is very repetitive in nature, for example, you need to import 20 different flat file exports from the ERP system, you need to load 15 dimensions into the data warehouse and so on.
With Microsoft SSIS out-of-the-box, you are forced to create multiple individual packages which is very time consuming due to the lack of easy code reuse. In a typical BI project, the ETL implementation can easily take up 60% of the project time, so it is beneficial if the development time of similar SSIS packages can be cut down.
Business Intelligence Markup Language (Biml) is an XML dialect for defining Business Intelligence assets across the Microsoft SQL Server platform
In this session Craig will introduce you to Biml BimlScript, providing those new to Biml with a foundational understanding of what BIML is and what the benefits of using Biml are.
SessionID: 15145
Power BI - Beyond the Basics
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Iman Eftekhari
Title: Power BI - Beyond the Basics
Abstract:
In this session we will go through the new features and capabilities of Power BI. We will also discuss best practices and tips along the way that will enable you to get the best out of this exciting technology.
Topics include: Overview, real-life demo, hybrid-cloud scenarios with Data Management Gateway, DMG tips and tricks, custom map demo, QA tips, licensing overview, Power BI roles in an enterprise environment, how this could fit your organisation, lessons learned from our 1.5 year journey, dashboard designer, SSAS connector, etc.
SessionID: 16920
Interactive Actionable Data Visualisation With Power View
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Julie Koesmarno
Title: Interactive Actionable Data Visualisation With Power View
Abstract:
This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.
SessionID: 19734
The DBA with his head in the clouds
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Martin Cairney
Title: The DBA with his head in the clouds
Abstract:
With Azure data centres located in Australia, will your company be looking more at cloud options? The Azure VM approach doesn't change your day to day role much, but Azure SQL Database certainly does.
This session will look at the DBA functions for an Azure SQL Database instance and compare that with your regular on-premise approach. We'll demo some of techniques that can be used.
SessionID: 19735
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Martin Cairney
Abstract:
Policy Management, Data Collector and Extended Events, all included in both Enterprise and Standard Editions, provide a framework to keep your configurations consistent and give you some insights into the performance of your SQL Server instances. In this session, we will see how to make use of these components to formalize your configuration and track some performance attributes.
After this session you’ll be able to build out an effective management and monitoring toolkit using only “out-of-the-box” features.
SessionID: 19766
Getting Started with the Azure V12 Portal and it'sNew Features
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Martin Catherall
Title: Getting Started with the Azure V12 Portal and it'sNew Features
Abstract:
Azure SQL Database has been out for a while now, but the limited feature set has proved a barrier for adoption.
Well, the latest additions to the TSQL surface area bring the offering more into line with SQL Server 2014 and the gap will only get smaller over time.
Come along to this session and fin out more about the new features and how to go about managing Azure SQL Database with your tool of choice, weather that is SSMS, Powershell or Visual Studio.
SessionID: 21473
TOPGUN SQL SERVER: Unlocking the Fighter Pilot in Every DBA
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Nicholas Loghides
Title: TOPGUN SQL SERVER: Unlocking the Fighter Pilot in Every DBA
Abstract:
UNLOCKING THE FIGHTER PILOT IN EVERY DBA – Let’s discuss how piloting tactical jets and flying SQL Servers requires similar psychology, skills and composure, especially during emergencies! DBA performance in production environments matters greatly, even on the easiest of days. But when things go wrong, that’s when you really earn your money and discover the depth of your knowledge and your poise in emergency response. We’ll focus on improving successful handling of critical situations. Content is based upon the collective knowledge gained by many people over many years in high performance aircraft. We’ll investigate examples of how to, and how not to, handle extremely difficult situations. We will look at bullet proof techniques for improving DBA crisis management. We’ll dig into teamwork/crew coordination during critical scenarios. Get ready for takeoff as you’ll see some captivating flight video and, if you have the courage to, participate in a live exercise.
SessionID: 21939
Continuously Integrated Data Vault
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Peter Avenant
Title: Continuously Integrated Data Vault
Abstract:
We will demonstrate a flexible and reusable framework for storing and managing the metadata that you will use as an input to your BimlScripts. We will bring it together with a walking through a fully featured production framework and the code it generates.
We will add unit test and continuous integration using MSBuild and the BimlCompiler allowing for changes in the source to drive the re-factoring of your Data Vault development.
SessionID: 22012
An Introduction to Azure Machine Learning
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Peter Myers
Title: An Introduction to Azure Machine Learning
Abstract:
"A Festivus for the rest of us!". That was how Seinfeld character Frank Costanza described his alternative to the Christmas tradition. In this session, I'll describe an alternative to the traditional approach to Data Science. Armed with nothing but a browser and an internet connection, I'll show you how easy it is to use Azure Machine Learning to build cloud-powered predictive models and deploy them as web services for application integration. After setting the context of where predictive modelling fits in the overall analytics spectrum, we'll dive into the Azure offering, before building and deploying a machine learning model from scratch using Azure Machine Learning Studio.
SessionID: 22068
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Peter Ward
Abstract:
SessionID: 23171
Powershell Gems for the DBA
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Rob Risetto
Title: Powershell Gems for the DBA
Abstract:
In this session we will walk through a number of Powershell functions, code snippets and techniques that can help fast track the development of automation and management DBA scripts. The examples in the session will show case Powershell building blocks like logging, exclude/include lists, read/validate INI files, retries, report generation, data load of performance data etc.
SessionID: 23385
Building Hybrid BI Solutions with Power BI
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Rod Colledge
Title: Building Hybrid BI Solutions with Power BI
Abstract:
As organizations look to lower infrastructure costs and increase worker productivity, two industry trends have emerged: the shift to the cloud and self-service. How will these trends change the way we build BI solutions, without compromising on security, manageability and governance? Join this session and find out! We will explore the following questions: What is Power BI? What do you need to run Power BI? How does Power BI differ to traditional BI? Where does Power BI fit in a broader enterprise BI strategy? And, finally, how can on-premises data sources be used in cloud-based Power BI solutions? In addition to answering these questions, we will build a Power BI solution from scratch using both on-premises and cloud-based data sources. We will use Power Query, Power Pivot, Power View and Power Map, before deploying the solution to a Power BI site in the cloud, and interacting with it using Q A, the new natural language query technology.
SessionID: 27668
Help me Availability Groups, You're the only 1 who can save me
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Warwick Rudd
Title: Help me Availability Groups, You're the only 1 who can save me
Abstract:
Data Recovery is a major part of a DBA’s job. As a DBA how can we ensure our mission critical data is available and recoverable in a timely manner when disaster strikes. As a production support DBA how can you ensure you’re mission critical data is protected? With the release of SQL Server 2014, changes were made to the AlwaysOn Availability Group feature set. In this session Warwick will introduce you to what Availability Groups are, breaking the confusion of DB Mirroring, FCI’s and AG’s, Introduce the new AG functionality and show you how this feature set can be used to extend your mission critical disaster recovery capabilities to cloud city.
SessionID: 34654
Stayin' Alive
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Heidi Wilson
Title: Stayin' Alive
Abstract:
Well, you can tell by the way I use WAIT STATS,
I’m a DBA, and I like the DAC.
PERFMON’s on and PAL is warm, I check LOCKS and BLOCKS
for not the norm.
Whether you’re a brother or whether you’re a mother,
this session will have your SQL Servers stayin’ alive.
Ah, ha, ha, ha, stayin' alive.
All critical features and tools that you must know and use to keep your SQL Servers stayin’ alive.
SessionID: 9072
Data Warehouse Automation - Improving your productivity
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Adam Gilmore
Title: Data Warehouse Automation - Improving your productivity
Abstract:
In this session we will discuss Data Warehouse Automation, how it can improve you productivity as a developer and,
at the same time, produce a consistent and flexible Data Warehouse that's easy to change.
In the session we will build a Data Warehouse using a Data Warehouse Automation tool, so you can see the process in action.
We will also look at EzAPI an alternative to BIML, that you can use to generate SSIS packages. Using EzAPI you can save time by starting with a standard SSIS package as a template, and then modify through code.
Data Warehouse Automation lets you stay focused on what really matters... producing valuable analytics and reporting for your business users