sqlsathistory

Nr: 840

Back to Main list

SQLSaturday #840 - Edmonton 2019

Start Time (24h)	Speaker	Track	Title
09:30:00	Chris Wood	Professional Development	Educating yourself will make a SQL career more fulfilling
09:30:00	Jay Falck	Enterprise Database Administration Deployment	Introduction to Linux for SQL Server
09:30:00	Mike Diehl	BI Platform Architecture, Development Administration	Conan the Librarian: "Put your data sources into Azure Data Catalog, or ELSE!"
09:30:00	Rick Lowe	Application Database Development	Weird Stuff I Saw While ... Working With Heaps
10:45:00	Randolph West	Enterprise Database Administration Deployment	Managing and monitoring SQL Server on Linux from the command line
10:45:00	Chris C	Strategy and Architecture	Create a Time Travelling Database
10:45:00	Sepand Gojgini	BI Platform Architecture, Development Administration	Columnstore Index Primer
10:45:00	Christopher Docherty	BI Platform Architecture, Development Administration	Data Security - Everyone likes a parfait!
13:00:00	Dmitry Anoshin	BI Platform Architecture, Development Administration	Building a Modern Cloud Data Warehouse
13:00:00	Rick Lowe	Enterprise Database Administration Deployment	Why should I care about ... the plan cache?
13:00:00	Jay Falck	Strategy and Architecture	Setting up a test lab with Hyper-V
13:00:00	Sam Hamilton	Analytics and Visualization	Generate Data with Google Analytics
14:15:00	Mike Diehl	Application Database Development	Untangling the spaghetti: Patterns and Anti-Patterns in SQL and ETL development
14:15:00	Christopher Docherty	BI Platform Architecture, Development Administration	Architecture for AGILE and DevOps
14:15:00	Randolph West	Enterprise Database Administration Deployment	Learn 4 key features of SQL Server 2019 part 1
14:15:00	Brian Gale	BI Platform Architecture, Development Administration	Service Broker - for Good and ETL
15:30:00	Sepand Gojgini	BI Platform Architecture, Development Administration	DW loves DevOps ??!!
15:30:00	Randolph West	Enterprise Database Administration Deployment	Learn 4 key features of SQL Server 2019 part 2
15:30:00	Anthony van Orizande	Application Database Development	SQL Server The Case of the Missing User Interface
15:30:00	Jonathon Machinski	Advanced Analysis Techniques	Corporate Data Rot and Machine Learning Readiness

SessionID: 87381

Educating yourself will make a SQL career more fulfilling

Back to calendar

Event Date: 27-04-2019 - Session time: 09:30:00 - Track: Professional Development

Speaker: Chris Wood

Title: Educating yourself will make a SQL career more fulfilling

Abstract:

Do you want to turn your SQL knowledge into a possible career?

This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product by providing links to people and organizations who offer training and advice He has now performed this at 3 SQL Saturday's and gotten great feedback from attendees. The slide deck will contain all the links that are shown during the presentation. This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences It will also show how to make any conference more affordable and justify the benefits

SessionID: 88817

Introduction to Linux for SQL Server

Back to calendar

Event Date: 27-04-2019 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jay Falck

Title: Introduction to Linux for SQL Server

Abstract:

SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.

SessionID: 89520

Conan the Librarian: "Put your data sources into Azure Data Catalog, or ELSE!"

Back to calendar

Event Date: 27-04-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Mike Diehl

Title: Conan the Librarian: "Put your data sources into Azure Data Catalog, or ELSE!"

Abstract:

Are all the sources of data in your organization well documented and easily discovered? Can someone new to your organization find out who is the knowledge expert on your data sources? Is it clear who they should contact to request access to a data source? Do your data sources clearly describe their meaning?

If you want to answer YES to all these questions, you should come to this session! We'll cover the basics of Azure Data Catalog - registering data sources, adding metadata and documentation, tags, and experts. And we'll discuss the scenarios that it is intended to address.

SessionID: 90427

Weird Stuff I Saw While ... Working With Heaps

Back to calendar

Event Date: 27-04-2019 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Rick Lowe

Title: Weird Stuff I Saw While ... Working With Heaps

Abstract:

We've all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for worloads that are mostly insert? Are they always recommended for ETL (Extract, Transform, Load) operations? Does it help to create non-clustered indexes on top of heaps? For this installment of Rick's "Weird Stuff" series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.

SessionID: 88444

Managing and monitoring SQL Server on Linux from the command line

Back to calendar

Event Date: 27-04-2019 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Randolph West

Title: Managing and monitoring SQL Server on Linux from the command line

Abstract:

When SQL Server arrived on Linux in 2017, Microsoft brought with it a database engine that works exactly the same as it does on Windows.

While you can manage and monitor SQL Server on Linux using existing tools designed for Windows, there are command line tools that will feel right at home to seasoned command-line and scripting veterans, including Oracle DBAs.

This session will cover mssql-conf (for configuring the server instance), mssql-cli (for connecting to the database engine), and dbfs (mounting a virtual file system) to query database management views (DMVs) using bash.

SessionID: 90086

Create a Time Travelling Database

Back to calendar

Event Date: 27-04-2019 - Session time: 10:45:00 - Track: Strategy and Architecture

Speaker: Chris C

Title: Create a Time Travelling Database

Abstract:

You've created a table or two to store historical data but how about an entire database? This talk will give you the tools the tools to create a temporal database using current and past relational databases.

Learn how to store and query temporal data but, more importantly, how to think about data as it changes over time. Spoiler: it does not involve SQL Server's new Temporal Tables, data warehousing, etc. It can all be done in your current database.

SessionID: 90609

Columnstore Index Primer

Back to calendar

Event Date: 27-04-2019 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sepand Gojgini

Title: Columnstore Index Primer

Abstract:

Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.

SessionID: 90629

Data Security - Everyone likes a parfait!

Back to calendar

Event Date: 27-04-2019 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Christopher Docherty

Title: Data Security - Everyone likes a parfait!

Abstract:

When you have a data breach, it is not just the network guys who catch the heat. Know your security, know your layers, and use the tools you have in the Microsoft environment. Exercise your authority as a data expert and enact the architecture to keep your warehouse secure! A discussion of the SQL Security architecture, the tools and how to build layers to ensure your warehouse is secure, and keep your data safely embedded in layer five, where it belongs.

SessionID: 89843

Building a Modern Cloud Data Warehouse

Back to calendar

Event Date: 27-04-2019 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dmitry Anoshin

Title: Building a Modern Cloud Data Warehouse

Abstract:

Organizations treat data as an asset. They always look for ways to improve existing analytics solutions and extract information from terabytes and petabytes of data.

One of the recent trends is the migration from legacy DW platform to the Cloud Data Platform. During this journey, data engineers meet lots of challenges and sometimes try to reinvent the wheel.

This talk will cover the journey towards Modern Cloud Analytics Solutions with Microsoft Azure. Moreover, It will cover the ETL tool selection process for the Cloud as well as the adoption process for the end users.

Finally, I will cover Big Data use case using Hadoop and Spark as well as Data Lake concept and idea.

This talk will help you understand the potential of Azure Cloud Analytics and learn about our use case and save time for future projects.

SessionID: 90425

Why should I care about ... the plan cache?

Back to calendar

Event Date: 27-04-2019 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 90919

Setting up a test lab with Hyper-V

Back to calendar

Event Date: 27-04-2019 - Session time: 13:00:00 - Track: Strategy and Architecture

Speaker: Jay Falck

Title: Setting up a test lab with Hyper-V

Abstract:

So, you want to play with SQL server and/or Windows Server but you don't have extra hardware lying around. In this session I'll go over creating the necessary virtual networking and virtual machines to allow you to do this and protect your local network from possible harm.

SessionID: 91597

Generate Data with Google Analytics

Back to calendar

Event Date: 27-04-2019 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Sam Hamilton

Title: Generate Data with Google Analytics

Abstract:

If you are familiar with Google Analytics (GA) but aren’t sure what to do with your data, then this is the session for you! In this session, you will learn how to create custom GA reports and visualizations using Google Sheets, Data Studio, and Google Scripts.

SessionID: 89518

Untangling the spaghetti: Patterns and Anti-Patterns in SQL and ETL development

Back to calendar

Event Date: 27-04-2019 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Mike Diehl

Title: Untangling the spaghetti: Patterns and Anti-Patterns in SQL and ETL development

Abstract:

Everyone has heard of "spaghetti code", but not many talk about "spaghetti data". Data environments grow over time, and often databases and servers become a tangled mess; if you had some pasta sauce, you could make lunch out of it!

In this session I will show the most grievous bad practices, what sorts of problems and constrictions they cause, and how they can be re-written to achieve much looser coupling across all data in an enterprise. Any DBA or developer that uses more than two part table or view names in their queries or stored procedures should attend!

SessionID: 90626

Architecture for AGILE and DevOps

Back to calendar

Event Date: 27-04-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Christopher Docherty

Title: Architecture for AGILE and DevOps

Abstract:

Have you struggled to get BI off the ground, or had months or years of work overturned by a change in management?

In this talk we will discuss how we can set ourselves up for success with an AGILE data warehouse, and methods of utilising AGILE and DevOps in delivering business intelligence in a fast, effective, and user-centred method. Architecture of our warehouse, data flows, data security, user engagement and how it all fits together to build rapid value for the organisation and set yourself apart.

SessionID: 91185

Learn 4 key features of SQL Server 2019 part 1

Back to calendar

Event Date: 27-04-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Randolph West

Title: Learn 4 key features of SQL Server 2019 part 1

Abstract:

Intelligent query processing, UTF-8, Secure Enclaves, and Accelerated Database Recovery. What does it all mean? Join Randolph West in a two-hour walkthrough of four key features of SQL Server 2019 for database administrators and developers.

SessionID: 91208

Service Broker - for Good and ETL

Back to calendar

Event Date: 27-04-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brian Gale

Title: Service Broker - for Good and ETL

Abstract:

This session will go over what is service broker, how does service broker work and how it can help with a near-realtime ETL process.

Service broker allows for asynchronous operations to occur on a database. Using this, you can push data from your operational database to a data mart and provide users with near realtime access to live data without risking an impact on the live system with blocking or deadlocking.

SessionID: 90610

DW loves DevOps ??!!

Back to calendar

Event Date: 27-04-2019 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sepand Gojgini

Title: DW loves DevOps ??!!

Abstract:

Many organization spend months and potentially years designing and implementing their data warehouse and by time of delivery the business requirements have evolved. Moreover such system is very complex and making any changes requires large amount of regression testing which slows down making improvement to system. Many of these problems plagued traditional application development and have for the large part been addressed by adoption of agile methodology and DevOps practices. In this session we'll draw parallel between the challenges of both domain and what the solution may look like.

SessionID: 91186

Learn 4 key features of SQL Server 2019 part 2

Back to calendar

Event Date: 27-04-2019 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Randolph West

Title: Learn 4 key features of SQL Server 2019 part 2

Abstract:

2nd part of learning Intelligent query processing, UTF-8, Secure Enclaves, and Accelerated Database Recovery. What does it all mean? Join Randolph West in a two-hour walkthrough of four key features of SQL Server 2019 for database administrators and developers.

SessionID: 91759

SQL Server The Case of the Missing User Interface

Back to calendar

Event Date: 27-04-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Anthony van Orizande

Title: SQL Server The Case of the Missing User Interface

Abstract:

Relational Databases represent a powerful tool and store a treasure trove of information. In this session you will learn how to use dbFront to extend the power of your SQL Server database and its valuable data to your users quickly, economically and safely. This helps eliminate the Silos and Dark I.T. created by users frustrated with the limitations of existing systems. Included is a solid introduction to dbFront and detailed examples showing how to implement several common scenarios.

A free PRO license for dbFront will be provided to everyone who attends!

SessionID: 92148

Corporate Data Rot and Machine Learning Readiness

Back to calendar

Event Date: 27-04-2019 - Session time: 15:30:00 - Track: Advanced Analysis Techniques

Speaker: Jonathon Machinski

Title: Corporate Data Rot and Machine Learning Readiness

Abstract:

An exploration into the large legacy data infrastructures used by many of today's corporations and the challenges they present. How dependencies can lead to paralysis on future projects, and how these infrastructures can be optimized for machine learning.

This site is open source. Improve this page.