Nr: 365
SQLSaturday #365 - Melbourne 2015
SessionID: 11992
Automate your Data Profiling insights using Power BI
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Varigence
Speaker: Craig Bryden
Title: Automate your Data Profiling insights using Power BI
Abstract:
In this session I will demonstrate how you can automate data profiling of any SQL Server Database using Integration Services, and use the output of the data profiling task to populate a Power Pivot data model.
This data model can then be used to analyse table structures, data quality and identify problems with your data. By using the different profiles you can determine how to clean up your incoming data prior to loading it into your database.
SessionID: 13242
The Care Feeding of Analysis Services in Production
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Varigence
Speaker: Darren Gosbell
Title: The Care Feeding of Analysis Services in Production
Abstract:
In this session we will look at what it takes to run an Analysis Services server in production. What are the basics that you need to know about how the server works. Including things like threading, memory usage and locking. How can you monitor the health of your server? What tools can you use to find out what's happening on your server? We'll have a look at what you should be monitoring to make sure your system is running properly and run through what to investigate went things don't run as smoothly as you'd like.
SessionID: 14726
How to build an Activty based modelling system with SSAS Tabular and Power Pivot
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Varigence
Speaker: Grant Paisley
Title: How to build an Activty based modelling system with SSAS Tabular and Power Pivot
Abstract:
The ability to distribute costs, including overheads, to activities in an organisation allows profitability to be calculated down to an individual activity, hence the ability to calculate the real client and product profitability.
In this session we take a look how you can create an Activity Based Modelling system using SSAS Tabular for the allocation model, and Power Pivot (over the Tabular Model) for end-user reporting. Having the final report model in Power Pivot gives the end user the ultimate control over reporting, including adding other information possibly not even held with Information Technology.
I'll show you an example health care model where we replaced an expensive, difficult to understand and maintain SAS system, with a simple elegant solution (auditable) based on the Microsoft stack. The rules are table driven with allocated costs handling built in.
Having build the model with one of the finance team power users, they now own and understand the new system.
SessionID: 15144
Power BI - Beyond the Basics
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Varigence
Speaker: Iman Eftekhari
Title: Power BI - Beyond the Basics
Abstract:
In this session we will go through the main features and capabilities of Power BI using an end-to-end scenario. 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, etc.
SessionID: 16829
Are You Safe from Prying Eyes?
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Kroll Ontrack
Speaker: Jim McLeod
Title: Are You Safe from Prying Eyes?
Abstract:
SessionID: 16921
10 Handy Tips On SQL Server Dates
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Violin Memory
Speaker: Julie Koesmarno
Title: 10 Handy Tips On SQL Server Dates
Abstract:
With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE!
SessionID: 18845
SQL and the cloud
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Dell
Speaker: Kristina Rumpff
Title: SQL and the cloud
Abstract:
A look at all the cloud technologies, how they bolt together, and what business benefits are the result
SessionID: 19737
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Kroll Ontrack
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: 19772
A Trip Through The Transaction Log All The Way to Delayed Durability.
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Kroll Ontrack
Speaker: Martin Catherall
Title: A Trip Through The Transaction Log All The Way to Delayed Durability.
Abstract:
During this session Martin and co-presenter Rob Douglas will focus on Delayed Durability. However, before we get there, we'll take a brief tour through the log and remind ourselves of some of the things that the log is used for - with some quite innovative demos. Then we'll move on to the define how Delayed Durability may be able to help you - if you can afford to pay the price.
SessionID: 21472
TOP GUN SQL SERVER: Why piloting jets and flying SQL Servers requires similar psychology!
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Microsoft
Speaker: Nicholas Loghides
Title: TOP GUN SQL SERVER: Why piloting jets and flying SQL Servers requires similar psychology!
Abstract:
THE PSYCHOLOGY OF A DBA - Why piloting tactical jets and flying SQL Servers requires similar psychology and composure to ensure mission success during emergencies!
Let's face it, being a DBA is a stressful job. Your 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.
This training focuses on improving your successful handling of critical situations. Content is based upon the collective knowledge gained by many people over many years in high performance aircraft. Nick will share examples of how to, and how not to, handle stress in extremely difficult situations. We will look at tried and true techniques that will help DBAs perform better when there is an actual emergency. You will also learn about the teamwork and crew coordination often required to handle time-critical scenarios.
SessionID: 21582
MDS
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Profisee
Speaker: Olof Szymczak
Title: MDS
Abstract:
Can talk about
Basics
- install
- models,entities,view,attributes,attribute groups
Advanced
- security
-deployment
-environments
-data migration
-data standards
let me know I can do a beginner or more advanced demo.
SessionID: 21897
Batch Mode Parallel Query Execution
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Kroll Ontrack
Speaker: Paul White
Title: Batch Mode Parallel Query Execution
Abstract:
A completely new model for parallel query execution known as "batch mode" was introduced in SQL Server 2012 and significantly enhanced in
SQL Server 2014. This session will describe the benefits of batch mode parallel execution, how it works, how to analyze the execution plans
it produces, and how to write queries and design databases to take full advantage of this new technology.
SessionID: 21942
Load a Staging Environment from Scratch in an Hour with Biml
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Varigence
Speaker: Peter Avenant
Title: Load a Staging Environment from Scratch in an Hour with Biml
Abstract:
Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Peter Avenant from Varigence Australia will use the free BIDSHelper add-in for BIDS and SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Peter will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of hundreds of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.
SessionID: 22384
Perception, Heuristics Visualisation Cues
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Profisee
Speaker: Paul te Braak
Title: Perception, Heuristics Visualisation Cues
Abstract:
It’s the end of the day you’re tired – there’s no shame in that. Still, your presentation needs to make an impact so that the audience understands and remembers your content. How do you display that data so that it is effectively absorbed?
This presentation looks at the display mechanisms for information. We delve into our visual cues and our cognitive patterns to understand how our minds interpret what we see so that, when we choose a graphic, we can choose the most effective visualization for our content and meaning of information being presented.
We look at which visualization techniques work and why less is sometimes more.
SessionID: 22798
Get Into Evaluation Context with DAX, the Language of PowerPivot
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Profisee
Speaker: Reeves Smith
Title: Get Into Evaluation Context with DAX, the Language of PowerPivot
Abstract:
Data Analysis Expressions (DAX) is the language of PowerPivot and the Analysis Services Tabular engine. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula. Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demonstrate row and filter context.
SessionID: 23229
A Few Of My Favourite Query Plan Operators
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Violin Memory
Speaker: Rob Farley
Title: A Few Of My Favourite Query Plan Operators
Abstract:
Without feeling any need to resort to any kind of Julie Andrews rendition...
Query plan operators do all the work when you run a query, and some of them are more significant than others. You may have learned about Seeks and Lookups, and about different Join operators, but when I look at a plan and see certain operators, some of them convey a lot more information than you may realise. This talk will look at operators such as "Merge Join (Concat)", "Top N Sort", "Filter", "Hash Match (Distinct Sort)", and more, exploring the significance of some of some of their properties, and helping you raise your game when it comes to performance tuning.
SessionID: 23378
Building Hybrid BI Solutions with Power BI
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Profisee
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: 23427
Using Azure Machine Learning to Predict Melbourne House Prices
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Dell
Speaker: Rolf Tesmer
Title: Using Azure Machine Learning to Predict Melbourne House Prices
Abstract:
House prices are a topic of conversation at every BBQ and dinner table across Melbourne. Have you ever wondered what drives house prices or wanted to predict an outcome in advance? This interactive session firstly introduces the What, How Why of Predictive Analytics and then provides an overview of using Azure Machine Learning (Azure ML) for making predictions in the context of Melbourne House Price data. The session explores using Azure ML regression algorithms and other statistical techniques to build an Azure ML experiment to first discover what features influence prices and then builds an Azure ML predictive Web Service solution based on those features. In the process of learning Azure ML regression, and with a bit of luck, we may even come up with a model that works!
SessionID: 24803
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Violin Memory
Speaker: Mladen Prajdić
Abstract:
SessionID: 25249
Agile Development with SQL Server
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Microsoft
Speaker: Stefan Riedel
Title: Agile Development with SQL Server
Abstract:
Agile methodologies require a test driven development approach and continuous integration. In this session we will look at how TDD and CI can be achieved for SQL Server development.
SessionID: 27085
MDX, it is not that hard!
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Profisee
Speaker: Peter ter Braake
Title: MDX, it is not that hard!
Abstract:
My first experience with MDX was: good, it looks like SQL: SELECT .. FROM .. WHERE. On my second glance it turned out to be completely different than SQL. But after a while SQL and MDX started to feel similar. In this session I bring you to the point of seeing the similarities instead of the differences. We will use your SQL experience to give you a head start with MDX. The session is also good for those with a bit of experience who want to know a bit more about the background. Of course all theory is backed by demo’s.
SessionID: 27424
SQL Server Internals for the Database Developer
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Violin Memory
Speaker: Victor Isakov
Title: SQL Server Internals for the Database Developer
Abstract:
In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover the practical internals of tables, indexes, transaction logs, query optimization and query execution. Importantly, he will translate how this knowledge can be used in database solution optimization and troubleshooting. This should prove to be a very practical session that all developers, team-leaders and managers should benefit from.
SessionID: 27446
Predictive Analytics using Azure Machine Learning
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Dell
Speaker: Vikas Rajput
Title: Predictive Analytics using Azure Machine Learning
Abstract:
Session to provide an introduction to Microsoft Azure Machine Learning and allied services, and build / deploy predictive models as machine learning web services in this process. Will touch on some practical predictive analytics problems like customer churn analysis and product recommendation.
SessionID: 27669
Help me Availability Groups, You're the only 1 who can save me
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Kroll Ontrack
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: 34653
Cloudy with a Chance of SQL
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Dell
Speaker: Heidi Wilson
Title: Cloudy with a Chance of SQL
Abstract:
Clearing to a better understanding of SQL Server and Microsoft Azure. This session will cover Azure concepts, options for moving your database to the cloud, feature support and hybrid scenarios with SQL Server 2014.
SessionID: 34709
SQL Saturday Retro
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Microsoft
Speaker: Kelly Broekstra
Title: SQL Saturday Retro
Abstract:
Come along and participate in a retrospective of the SQL Saturday event. Session will include introduction to Agile retros and a chance to participate in a discussion on how to improve SQL Saturday
SessionID: 9465
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Violin Memory
Speaker: André Kamman
Abstract: