sqlsathistory

Nr: 296

SQLSaturday #296 - Melbourne 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Craig Bryden	Track 2	Introducing Microsoft Power Query
00:00:00	Darren Gosbell	Track 1	Drop your DAX
00:00:00	Grant Paisley	Track 3	Kick-ass Ad-hoc Cube Browser build in SSRS 2014
00:00:00	Greg Low	Track 5	Why compression matters so much for SQL Server and BI
00:00:00	Shehab El-Najjar	Track 5	T-SQL Performance Guidelines for better DB stress powers
00:00:00	Julie Koesmarno	Track 2	Building Your Myth Busting Lab With Power BI
00:00:00	Konstantin Khomyakov	Track 4	Data Quality Services (Deep dive)
00:00:00	Martin Cairney	Track 4	Automating Deployments with Powershell
00:00:00	Martin Catherall	Track 5	Event notifications for the proactive DBA
00:00:00	Mohamed Kabiruddin	Track 3	Agile BI with SQL Server 2014 and TFS 2013
00:00:00	Peter Avenant	Track 2	VARIGENCE AUSTRALIA - Build an Integrated Metadata Framework
00:00:00	Peter Myers	Track 2	Introduction to SQL Server Data Mining
00:00:00	Paul te Braak	Track 1	Analytical Data Mining - Using Data Mining to Understand Data
00:00:00	Rob Farley	Track 5	The Incredible Shrinking Execution Plan
00:00:00	Rod Colledge	Track 2	Hour of Power BI
00:00:00	Rolf Tesmer	Track 1	Leveraging SQL Spatial Analytics for Making Business Decisions
00:00:00	Victor Isakov	Track 3	Understanding SQL Server 2014's In-Memory OLTP Table Technology
00:00:00	Warwick Rudd	Track 3	Performance Eye for the SQL Guy

SessionID: 11988

Introducing Microsoft Power Query

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Craig Bryden

Title: Introducing Microsoft Power Query

Abstract:

In this session, I will introduce the audience to Microsoft Power Query for Excel. Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. It has often been referred to as the end-user ETL tool, but I believe that it will also be a valuable tool for all technical staff. This demo rich presentation will expose many great features of one of the tools in Microsoft’s Power BI tool belt.

SessionID: 13240

Drop your DAX

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Darren Gosbell

Title: Drop your DAX

Abstract:

The world of DAX and tabular models opens up some unique opportunities for some really creative modelling to allow the addressing of both technical and business issues. During this session we will look at a number of different real life scenarios including things like:

I need to do a quick proof of concept with some new facts that only has business keys, yet my dimensions have surrogate keys coming from the Data Warehouse which is tracking changes over time (SCD2).
My users want to look for customers which have certain combinations of products, but not others. i.e "Show me customers who have Product 1 and Product 2, but not Product 3" - How can I support those sort of questions from my tabular model.
and a couple of other in

SessionID: 14724

Kick-ass Ad-hoc Cube Browser build in SSRS 2014

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Grant Paisley

Title: Kick-ass Ad-hoc Cube Browser build in SSRS 2014

Abstract:

Get a sneak preview of my USA PASS Analytics Conference session.

You will learn how to use generic reporting techniques in SQL Server Reporting Services (SSRS) to create a virtually unlimited set of dynamic reports for your users by simply changing report parameters. Just change dashboard report contents and share components for looking up values.

The techniques we will discuss are based on concepts in the books “Advanced Reporting Services 2012” and “Reporting Services Recipes.” By attending this session, you will learn enough to use the Angry Koala Cube Browser and Angry Koala Cube Surfer and modify to your own organization’s needs. Join this practical session, which will give you lots of ideas for your own users.

SessionID: 14829

Why compression matters so much for SQL Server and BI

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Greg Low

Title: Why compression matters so much for SQL Server and BI

Abstract:

When you want to get good performance from your database applications, compression is one of the most important technologies that you need to consider, yet it's one of the least understood. In this session Greg will show the evolution of compression technologies from table compression in SQL Server 2008, to columnstore and tabular data models in SQL Server 2012, through to clustered updatable columnstore indexes in SQL Server 2014.

SessionID: 15191

T-SQL Performance Guidelines for better DB stress powers

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Shehab El-Najjar

Title: T-SQL Performance Guidelines for better DB stress powers

Abstract:

To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users or adequate volume of data is exists there but actually they seem totally strange once going to live and they become performing badly ending up with standstill cases sometimes , this is due to lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs so I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be analyzed within this session)

SessionID: 16917

Building Your Myth Busting Lab With Power BI

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Julie Koesmarno

Title: Building Your Myth Busting Lab With Power BI

Abstract:

Did you know that a large portion of Information Workers’ and Data Analysts’ tasks are akin to “myth” busting? How can Power BI be used for these myth busting tasks? What if myth busting can be as easily done as few clicks or asking questions in plain English? This session will demonstrate how to create an ideal Myth Busting lab for data gathering, modelling, analysis, visualisation and collaboration all in one suite.

SessionID: 18670

Data Quality Services (Deep dive)

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Konstantin Khomyakov

Title: Data Quality Services (Deep dive)

Abstract:

Data Quality Services (DQS) is one of the main mechanisms for data normalization, removing duplicate content and filling knowledge base. It allows you to perform various operations to obtain quality data. The main feature is the creation of the knowledge base, in which there are basic configuration, data manipulation rules. DQS Cleansing is the standard SSIS control, which is used for normalization (cleansing) data.

In this session two new controls will be introduced: DQS Domain Value Import and DQS Matching Transformation. During the session SSIS package will be created. This package will automate the process of importing domain entities, including synonyms, to the existing knowledge base. Also mechanism for removing duplicates will be applied, relying on returned weights coefficients compared between each set of records.

SessionID: 19730

Automating Deployments with Powershell

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Martin Cairney

Title: Automating Deployments with Powershell

Abstract:

Some aspects of SQL Server installations are easily repeatable using things like config files and command line installs. However, so much of the preparation and post-install configuration still needs to be done manually.

This session will show how Powershell can be used to prep the servers (including how easy it can be to deploy a cluster) and how Powershell can then be used to deploy and configure SQL Server according to your company standards.

SessionID: 19758

Event notifications for the proactive DBA

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Martin Catherall

Title: Event notifications for the proactive DBA

Abstract:

Event notifications in SQL SERVER have been around for a little while but seem to be one of the most under used features. Combine this feature with database mail and you have a first class alerting system. Come along to this session and find out how to use these features to become a truly proactive DBA. Learn how to get notified about such events as deadlocks and blocking before your users even know they have taken place. Get details of most errors delivered straight to your inbox. You’ll leave this session with a full toolkit that you can start to implement straight away.

SessionID: 20007

Agile BI with SQL Server 2014 and TFS 2013

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Mohamed Kabiruddin

Title: Agile BI with SQL Server 2014 and TFS 2013

Abstract:

SessionID: 21935

VARIGENCE AUSTRALIA - Build an Integrated Metadata Framework

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Peter Avenant

Title: VARIGENCE AUSTRALIA - Build an Integrated Metadata Framework

Abstract:

Using a live-typing approach, Peter will briefly show the overall structure of a Biml file and the core syntax patterns. Then he will demonstrate how the power of BimlScript is amplified by the availability of rich metadata sources to drive the automatic creation of your solution.

Peter 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.

Please refer to the technical walkthrough for more information. http://bimlscript.com/Walkthrough/Details/2074

SessionID: 21990

Introduction to SQL Server Data Mining

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Peter Myers

Title: Introduction to SQL Server Data Mining

Abstract:

Data mining as a technology is used to analyze data by revealing patterns. These patterns can then be used to derive knowledge about data, and in turn this knowledge can be used to enhance application designs and the user experience. In this session, you will be introduced to the data mining capabilities in SQL Server 2012 Analysis Services, and demonstrations on how to specifically design, develop, explore, evaluate and query data mining models. This session is guaranteed to thrill you with potential, and excite you with the ease in which it can be accomplished.

SessionID: 22374

Analytical Data Mining - Using Data Mining to Understand Data

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Paul te Braak

Title: Analytical Data Mining - Using Data Mining to Understand Data

Abstract:

Data mining is a technique used to derive previously unknown information from large amounts of data. The process of this knowledge discovery can help uncover new patterns within data and help analysts better understand the large datasets. Additionally, once these patterns have been defined, you can use them as part of predictive modelling estimating the likelihood of some event occurring.

SQL Server Analysis Services includes a data mining engine that can be used at various levels within an organization, from analyst to developer. This session will look at data mining as tool for data investigation by the business analyst. We examine the business case, requirements and outcomes of data mining so that it can enhance our understanding of datasets. We will look at both simple and complex implementations of data mining that allow new information to be extracted from data and used in novel ways within the MS Stack.

SessionID: 23225

The Incredible Shrinking Execution Plan

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Rob Farley

Title: The Incredible Shrinking Execution Plan

Abstract:

The Query Optimizer can do amazing things with your queries to work out the best plan. If you're aware of some of techniques it uses, you can leverage this to make your plans be tighter than ever, resulting in better performance and even provide an easier platform for developers who feel less confident with T-SQL. These ideas can even help you query systems such as Microsoft Dynamics in better ways.

SessionID: 23377

Hour of Power BI

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Rod Colledge

Title: Hour of Power BI

Abstract:

In this session, Rod will focus on;

What is Power BI?
How does Power BI differ to traditional BI tools such as Analysis Services, Reporting Services PerformancePoint Services?
What do you need to run Power BI, and how do you get it?
Where does Power BI fit in an organization's broader enterprise BI strategy?

In addition to answering the above questions, Rod will build a Power BI solution from scratch, in real time. Rod will use Power Query, Power Pivot, Power View and Power Map inside Excel 2013, before deploying the solution to a Power BI site in the cloud, and interacting with it using Q A, the new natural language query techno

SessionID: 23426

Leveraging SQL Spatial Analytics for Making Business Decisions

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Rolf Tesmer

Title: Leveraging SQL Spatial Analytics for Making Business Decisions

Abstract:

Imagine the possibilities if you were able to gather real-time insight into the traffic flow, patterns and behaviors of people while within your premises. Wi-Fi Location Analytics solutions leverage WiFi infrastructure to make this possible by capturing high volume real-time spatial positioning data from mobile devices. The spatial data is extracted, transformed and analysed in SQL Server to provide location based mobility services (such as tracking, mapping and way-finding)This session discusses how these Big Data solutions work and demonstrates data consumption via SQL 2012 spatial (direction, distance, speed, proximity), SSRS 2012 custom maps, and Excel Power View.

SessionID: 27410

Understanding SQL Server 2014's In-Memory OLTP Table Technology

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Victor Isakov

Title: Understanding SQL Server 2014's In-Memory OLTP Table Technology

Abstract:

Microsoft's new In-Memory OLTP Tables ("Hekaton") promise to seriously change the performance of database solutions that you can design and implement or refactor. In this session, we will examine this new technology's architecture and internals, new T-SQL syntax, and various use cases. We'll then discuss how it affects your SQL Server environment, including performance considerations, troubleshooting, administration, and high-availability design considerations.

SessionID: 27656

Performance Eye for the SQL Guy

Back to calendar

Event Date: 05-04-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Warwick Rudd

Title: Performance Eye for the SQL Guy

Abstract:

With the release of SQL Server 2014 comes some new features which can provide performance improvements for your SQL Server environment. In this session Warwick will take you through these new features including Buffer Pool Extension, Resource Governor for I/O, InMemory OLTP, InMemory DW, Managed Lock Priority Single Partition Online Index Build that could help improve performance in your SQL Server environment .

This site is open source. Improve this page.