sqlsathistory

Nr: 559

Back to Main list

SQLSaturday #559 - Cape Town 2016

Start Time (24h) Speaker Track Title
09:00:00 Jason Basterfield Analytics and Visualization Infographics using PowerBI and BI Office
09:00:00 Gail Shaw Application Database Development On Transactions and Atomic Operations
09:00:00 Niels Berglund BI Platform Architecture, Development Administration Real-Time Operational Analytics
09:00:00 Michael Raam BI Information Delivery From Me BI to We BI, take your BI solution beyond the clouds
10:00:00 Peter Willmot Other Using the SQL 2016 Query Store to optimise Performance and Scalability
10:00:00 Matt Horn BI Information Delivery The language informally known as M
10:00:00 Gordon Beeming Professional Development Your code is not just...your code
10:00:00 Niels Berglund Analytics and Visualization What R You Analyzing
13:00:00 Steve Simon BI Information Delivery SQL Server 2016: A dive into Data Quality Services
13:00:00 Gail Shaw Application Database Development Introduction to Indexes
13:00:00 Benjamin Nevarez Application Database Development Dive into the Query Optimizer - Undocumented Insight
13:00:00 Sandesh Nagaraj BI Information Delivery BI Office Analytic Platforms and the Value of Shared Context
14:00:00 Clinton van Blommestein Application Database Development So, when you say database what do you mean?
14:00:00 Steve Simon BI Information Delivery SQL Server 2016: Master Data Services and Rapid Application Development
14:00:00 Martin Phelps Application Database Development Query Performance Tuning on a budget (Free)
14:00:00 Jeanne Combrinck BI Platform Architecture, Development Administration Detecting ETL Duration Anomalies with Simple Linear Regression
14:00:00 Toufiq Abrahams Professional Development Data Driven: finding value in the digital maze
15:00:00 Desmond Norton Application Database Development Windows on Data
15:00:00 Benjamin Nevarez Application Database Development Query Processing in In-Memory OLTP (Hekaton)
15:00:00 Michael Johnson BI Platform Architecture, Development Administration Getting started with Azure SQL Data Warehouse
15:00:00 Ziyaad Mohamed BI Information Delivery Introduction to Business Intelligence Markup Language (BIML)

SessionID: 53239

Infographics using PowerBI and BI Office

Back to calendar

Event Date: 10-09-2016 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Jason Basterfield

Title: Infographics using PowerBI and BI Office

Abstract:

Utilization of infographics through PowerBI and BI Office

SessionID: 53295

On Transactions and Atomic Operations

Back to calendar

Event Date: 10-09-2016 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Gail Shaw

Title: On Transactions and Atomic Operations

Abstract:

If there’s one thing that we, as SQL developers, do, it's not use enough transactions.

Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code

In this session, we'll look at what transactions are and why we should use them. We'll explore the effects transactions have on locking and the transaction log. We'll investigate methods of handling errors and undoing data modifications, and we'll see why nested transactions are a lie.

SessionID: 53365

Real-Time Operational Analytics

Back to calendar

Event Date: 10-09-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Niels Berglund

Title: Real-Time Operational Analytics

Abstract:

It used to be that if you want to do analysis of data that is stored in SQL Server, you had to extract the data into a data ware-house or something similar, and run you analysis there. The downside with that is the time it takes from the time of insertion into the transaction store until the data is available in the DW. In this session we will see how we can use SQL Server 2016 to do real time analytics against your OLTP database.

SessionID: 54077

From Me BI to We BI, take your BI solution beyond the clouds

Back to calendar

Event Date: 10-09-2016 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Michael Raam

Title: From Me BI to We BI, take your BI solution beyond the clouds

Abstract:

ne of the main challenges organizations face in the BI world is to allow, via a single platform, contradicting needs of self-service BI with governance and Enterprise scale.

Come and see the game changing approach of Pyramid Analytics that allows organizations to obtain these impossible needs of business users and IT in a singular BI platform. Pyramid Analytics the platform that Microsoft selected as a strategic partner for PowerBI.

Pyramid Analytics revolutionary platform provides a single platform that delivers: • Self Service – No code necessary. • Web based central administration and security. • Role based functionality for different roles in the organization (Professional, Analyst and Consumer). • Universal configuration – build once use anywhere (PC, Tablet and Mobile). • Enterprise scale – parallel processing, clustering and load balancing. • And more ….

SessionID: 50036

Using the SQL 2016 Query Store to optimise Performance and Scalability

Back to calendar

Event Date: 10-09-2016 - Session time: 10:00:00 - Track: Other

Speaker: Peter Willmot

Title: Using the SQL 2016 Query Store to optimise Performance and Scalability

Abstract:

SQL 2016 introduces the Query Store, a mechanism that has been built into the SQL 2016 database engine in order to facilitate rapid identification and resolution of performance and scalability bottlenecks in SQL application scenarios. In the session we will examine Query Store architecture and features and gain an understanding of how the tools should be used.

SessionID: 50267

The language informally known as M

Back to calendar

Event Date: 10-09-2016 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Matt Horn

Title: The language informally known as M

Abstract:

At the heart of Power BI is the Power Query Formula Language (informally known as M), a dynamically typed, case-sensitive functional language for creating mashup queries, similar to the F# language.

Although Power BI Desktop has a number of great UI features for transformations, under the hood it's all M, and the better you understand the language, the more you can take advantage of the capabilities inherent in Power BI.

In this session I will introduce you to the basics of the M language and demonstrate some of the more advanced features.

SessionID: 52928

Your code is not just...your code

Back to calendar

Event Date: 10-09-2016 - Session time: 10:00:00 - Track: Professional Development

Speaker: Gordon Beeming

Title: Your code is not just...your code

Abstract:

When you code do you only thing about your code? What about how you release it fast, with high Quality and in a regulated environment?

We'll take a look at how SQL code traditionally (or at least most commonly) gets into production. We'll then switch our focus to using unit tests as a way to help improve quality in the fast paced world we live in and a release pipeline to simplify it all

SessionID: 53364

What R You Analyzing

Back to calendar

Event Date: 10-09-2016 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Niels Berglund

Title: What R You Analyzing

Abstract:

R has become one of the leading analysis tools for developers and data scientists alike. However, in order for R to do its magic it needs data so historically we have imported data from various sources, SQL Server being one of those sources. In SQL Server 2016, Microsoft has embedded R in the SQL engine. Yes, we do now have access to R natively in SQL Server.

In this session we will look at how R works in SQL Server, and also talk about some performance improvements you are getting by running R in SQL Server.

SessionID: 53191

SQL Server 2016: A dive into Data Quality Services

Back to calendar

Event Date: 10-09-2016 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Steve Simon

Title: SQL Server 2016: A dive into Data Quality Services

Abstract:

SQL Server 2016: Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.

SessionID: 53297

Introduction to Indexes

Back to calendar

Event Date: 10-09-2016 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Gail Shaw

Title: Introduction to Indexes

Abstract:

In this session, we'll look at design considerations for clustered and non-clustered indexes. We'll investigate what makes an index useful to SQL Server and what common mistakes make indexes useless. We'll go into the details of how various query predicates interact with indexes and what the primary driver is when designing indexes for any database application.

This session is aimed at people who are relatively new to indexing.

SessionID: 53501

Dive into the Query Optimizer - Undocumented Insight

Back to calendar

Event Date: 10-09-2016 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 54072

BI Office Analytic Platforms and the Value of Shared Context

Back to calendar

Event Date: 10-09-2016 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Sandesh Nagaraj

Title: BI Office Analytic Platforms and the Value of Shared Context

Abstract:

Modern self-service personal productivity analytic tools allow individual users to create sophisticated calculations and sets. However, for an organization to maximize the value of analytics this business logic must be released from myriad of spreadsheets and documents that it is embedded. Join us to discuss how analytic platforms allow data-driven organizations to centralize, share and contextualize this content.

SessionID: 50026

So, when you say database what do you mean?

Back to calendar

Event Date: 10-09-2016 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Clinton van Blommestein

Title: So, when you say database what do you mean?

Abstract:

These days when you say "database server" it could really mean many things.

For something like SQL server there are so many options: on-premise server, off-premise server. On-premise server with off-premise data. Then there are the various Azure offerings with fancy names like Azure SQL, Data Lake, Hadoop.

You also get graph databases and document databases.

This session will cover some of the more popular types of data stores that are available today and we will look at their use cases. While SQL server is great for many things, one has to be aware of the other options that are available out there.

SessionID: 53192

SQL Server 2016: Master Data Services and Rapid Application Development

Back to calendar

Event Date: 10-09-2016 - Session time: 14:00:00 - Track: BI Information Delivery

Speaker: Steve Simon

Title: SQL Server 2016: Master Data Services and Rapid Application Development

Abstract:

Master Data Services can be readily be employed for Rapid Application Development. We shall be looking at important development, data security and data maintenance aspects, all based upon a recent client implementation.

SessionID: 53376

Query Performance Tuning on a budget (Free)

Back to calendar

Event Date: 10-09-2016 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Martin Phelps

Title: Query Performance Tuning on a budget (Free)

Abstract:

SQL Server has built in tools available to assist you in Query Performance Tuning. We will go through the tools and how you can use them to quickly identify various performance issues. There are also various free software and scripts available provided by third parties which I use on a daily basis which I will recommend.

SessionID: 53884

Detecting ETL Duration Anomalies with Simple Linear Regression

Back to calendar

Event Date: 10-09-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeanne Combrinck

Title: Detecting ETL Duration Anomalies with Simple Linear Regression

Abstract:

When an ETL is initially deployed it is expected to run for a certain amount of time based on testing during development. It does not always come to our attention that the duration the ETL takes to complete starts growing at an abnormal rate. Using Simple Linear Regression, we can detect the duration anomalies of ETLs. Will be going into detail on what Simple Linear Regression is and how you can use it to your advantage to detect ETL duration anomalies.

SessionID: 54152

Data Driven: finding value in the digital maze

Back to calendar

Event Date: 10-09-2016 - Session time: 14:00:00 - Track: Professional Development

Speaker: Toufiq Abrahams

Title: Data Driven: finding value in the digital maze

Abstract:

No one needs to be convinced that data is valuable. But trying to understand where to look for value in your data and what to focus on is challenging. We try to give meaningful context to terminology such as big data, digital disruption, 4th industrial revolution, etc.

This is a non-technical session that will give an overview of how your data landscape is changing and what you need to be aware of to derive value from data.

SessionID: 53256

Windows on Data

Back to calendar

Event Date: 10-09-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Desmond Norton

Title: Windows on Data

Abstract:

A look at Window functions, and how their performance has improved over the SQL versions.

Also ideas/samples of potential use cases.

SessionID: 53502

Query Processing in In-Memory OLTP (Hekaton)

Back to calendar

Event Date: 10-09-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Query Processing in In-Memory OLTP (Hekaton)

Abstract:

In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.

SessionID: 53977

Getting started with Azure SQL Data Warehouse

Back to calendar

Event Date: 10-09-2016 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Michael Johnson

Title: Getting started with Azure SQL Data Warehouse

Abstract:

As data warehouses continue to see rapid expansions of data, traditional architectures struggle to keep up. Massively Parallel Processing is a technique that allows a data warehouse to be seamlessly distributed across multiple machines allowing for near linear scaling. Massively Parallel processing was first introduced to SQL through Parallel Data Warehouse (PDW) which was a large and often expensive deployment process. Azure SQL Data Warehouse brings much of the Power of Parallel Data Warehouse but with many advantages of the cloud such as lower costs and faster deployment.

In this session we will look at how the Azure SQL Data Warehouse works behind the scenes. We will also look at various options for provisioning and loading data before ending with a look at how queries executed.

SessionID: 54073

Introduction to Business Intelligence Markup Language (BIML)

Back to calendar

Event Date: 10-09-2016 - Session time: 15:00:00 - Track: BI Information Delivery

Speaker: Ziyaad Mohamed

Title: Introduction to Business Intelligence Markup Language (BIML)

Abstract:

Demonstrating how you can easily generate SSIS packages based on metadata, allowing us to effectively apply code reuse, templates and patterns in our ETL solutions using BIML