Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 20
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 27

Time: 2:15 PM - 3:15 PM

Room: PIC233

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 27

Time: 1:00 PM - 2:00 PM

Room: PIC233

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 27

Time: 10:45 AM - 11:45 AM

Room: PIC234

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 27

Time: 9:30 AM - 10:30 AM

Room: PIC233

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: April 27

Time: 3:30 PM - 4:30 PM

Room: PIC233

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 27

Time: 10:45 AM - 11:45 AM

Room: PIC230

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 27

Time: 10:45 AM - 11:45 AM

Room: PIC233

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 27

Time: 3:30 PM - 4:30 PM

Room: PIC234

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

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 27

Time: 9:30 AM - 10:30 AM

Room: PIC234

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: April 27

Time: 1:00 PM - 2:00 PM

Room: PIC234

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 27

Time: 9:30 AM - 10:30 AM

Room: PIC232

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 2:15 PM - 3:15 PM

Room: PIC232

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 3:30 PM - 4:30 PM

Room: PIC232

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 10:45 AM - 11:45 AM

Room: PIC232

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 27

Time: 2:15 PM - 3:15 PM

Room: PIC234

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 27

Time: 1:00 PM - 2:00 PM

Room: PIC230

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!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 27

Time: 3:30 PM - 4:30 PM

Room: PIC230

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!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 27

Time: 2:15 PM - 3:15 PM

Room: PIC230

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 27

Time: 9:30 AM - 10:30 AM

Room: PIC230

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 27

Time: 1:00 PM - 2:00 PM

Room: PIC232

Sessions Found: 20
Back to Top cage-aids
cage-aids
cage-aids
cage-aids