sqlsathistory

Nr: 561

Back to Main list

SQLSaturday #561 - Durban 2016

Start Time (24h) Speaker Track Title
09:00:00 Desmond Norton Room 3 Windows on Data
09:00:00 Niels Berglund Room 1 What R You Analyzing
09:00:00 Michael Johnson Room 2 Simple tips for better data warehouse design
10:15:00 Steve Simon Room 1 SQL Server 2016: A dive into Data Quality Services
10:15:00 Gail Shaw Room 2 Go, go, QueryStore!
10:15:00 Sean Cremer Room 3 Introduction to Database Design
11:30:00 Niels Berglund Room 3 Beyond Relational with SQL 2016
11:30:00 André Pelser Room 2 SQL Always On - Overcoming some administration nightmares
11:30:00 Gary Hope Room 1 Building a Lambda Architecture using Azure Warehouse and Stream A
13:30:00 Steve Simon Room 1 SQL Server 2016: Master Data Services and Rapid Application Development
13:30:00 Gail Shaw Room 3 On Transactions and Atomic Operations
13:30:00 Marius Erasmus Room 2 SSIS Tips, Tricks and Design Patterns
14:45:00 Clinton van Blommestein Room 3 So, when you say database what do you mean?
14:45:00 Chris Olivier Room 1 Basics of Azure Machine Learning
14:45:00 Rory Bolle Room 2 Top Tips for C# developers deploying Database code

SessionID: 52890

Windows on Data

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Room 3

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: 53688

What R You Analyzing

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Room 1

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.

SessionID: 54291

Simple tips for better data warehouse design

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Room 2

Speaker: Michael Johnson

Title: Simple tips for better data warehouse design

Abstract:

Building a data warehouse can be complicated. There are two competing philosophies and a myriad of other best practice documents out there on building high performance data warehouses and you probably don’t have time to read any of them.

In this session we will discuss a key approaches that you can use to design simple, easy to use data warehouses.

SessionID: 53193

SQL Server 2016: A dive into Data Quality Services

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Room 1

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: 53798

Go, go, QueryStore!

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Room 2

Speaker: Gail Shaw

Title: Go, go, QueryStore!

Abstract:

One of the hardest things to do in SQL is to identify the cause of a sudden degradation in performance. The DMVs don’t persist information over a restart of the instance and, unless there was already some query benchmarking (and there almost never is), answering the question of how the queries behaved last week needs a time machine. Up until now, that is. The addition of the QueryStore to SQL Server 2016 makes identifying and resolving performance regressions a breeze.

In this session we’ll take a look at what the QueryStore is and how it works, before diving into a scenario where overall performance suddenly degraded, and we’ll see why QueryStore is the best new feature in SQL Server 2016, bar none.

SessionID: 54074

Introduction to Database Design

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Room 3

Speaker: Sean Cremer

Title: Introduction to Database Design

Abstract:

Far too few database developers in this day and age get the opportunity to learn how to design relation databases. In most cases, they will on occasion be asked to add a few objects to an existing system while following the standards of the organisation.

These relatively infrequent changes do not hone the skills needed for effective design.

This session will go through the fundamentals of database design. Topics such as normalization, Understanding Data Relationships as well as the Language of Data Modeling and Design will be discussed. The Database Design Sequence Phases of Conceptual, Logical and Physical will be introduced as well.

SessionID: 53689

Beyond Relational with SQL 2016

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: Room 3

Speaker: Niels Berglund

Title: Beyond Relational with SQL 2016

Abstract:

There is a saying "no man is an island", and that holds true for SQL Server as well.

In your organization you have data stored all over the place, and your data may not always be relational. In this talk we will see how you can handle both relational as well a non relational data in SQL Server 2016. Among the things we will talk about are JSON support, Hadoop and Polybase.

SessionID: 54174

SQL Always On - Overcoming some administration nightmares

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: Room 2

Speaker: André Pelser

Title: SQL Always On - Overcoming some administration nightmares

Abstract:

Getting an overview of SQL availability solutions, taking a look at some pros and cons with focus on SQL AlwaysOn High Availability and some administration constrains and how to overcome them.

SessionID: 54270

Building a Lambda Architecture using Azure Warehouse and Stream A

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: Room 1

Speaker: Gary Hope

Title: Building a Lambda Architecture using Azure Warehouse and Stream A

Abstract:

It’s been a while since Nathan Marz wrote the first Lambda Architecture post and a lot has happened since.

The principals described in this approach have been applied and refined, especially within the Hadoop ecosystem. However in this talk we will look at using some of the Microsoft Azure based technologies, specifically Azure Stream Analytics and Azure Data Warehouse to implement this approach to data management and realize some of this benefits of this architecture.

SessionID: 53194

SQL Server 2016: Master Data Services and Rapid Application Development

Back to calendar

Event Date: 17-09-2016 - Session time: 13:30:00 - Track: Room 1

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: 53799

On Transactions and Atomic Operations

Back to calendar

Event Date: 17-09-2016 - Session time: 13:30:00 - Track: Room 3

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: 54031

SSIS Tips, Tricks and Design Patterns

Back to calendar

Event Date: 17-09-2016 - Session time: 13:30:00 - Track: Room 2

Speaker: Marius Erasmus

Title: SSIS Tips, Tricks and Design Patterns

Abstract:

Anybody can quickly build a SSIS package to collect some data…. But it takes a lot of experience and patience to fully understand how to build a full scale solution.

SSIS has loads of little settings and “hidden” features that can be tweaked, modified and changed to turn an standard package into a proper solution.

This presentation is just a highlight of some of the Tips, Tricks and Design Patterns that can be used to make your SSIS experience a joyful one.

SessionID: 50227

So, when you say database what do you mean?

Back to calendar

Event Date: 17-09-2016 - Session time: 14:45:00 - Track: Room 3

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: 53185

Basics of Azure Machine Learning

Back to calendar

Event Date: 17-09-2016 - Session time: 14:45:00 - Track: Room 1

Speaker: Chris Olivier

Title: Basics of Azure Machine Learning

Abstract:

The Azure Machine Learning workspace is an easy to use, visual way of doing machine learning, however, it is also very powerful and a great tool to use to start with Machine Learning. Initially it can be a bit overwhelming to figure out how exactly to go about using it to get some results. We will give a basic introduction to machine learning, the Azure Machine Learning workspace, a demo on how to get your first model running in a few minutes as well as some of the functionality offered in this great and quickly evolving tool.

SessionID: 53788

Top Tips for C# developers deploying Database code

Back to calendar

Event Date: 17-09-2016 - Session time: 14:45:00 - Track: Room 2

Speaker: Rory Bolle

Title: Top Tips for C# developers deploying Database code

Abstract:

Everyone has experienced a live costly issue on a production database. This is made worse is when the live costly issue can be blamed on a non-Database Developer overlooking something “Obvious”.

Normally this type of problem is followed by someone blaming a process or shouting about peer reviews or arguing about training… What if there was a better way? Is it possible to create a short list of guidelines for non-Database developers to follow that remove almost all of the pain points?

Let’s find out!