Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 31
If you took a look at Always Encrypted in SQL Server 2016, you may have had some reservations about it. It was a great concept, but because the database engine could no longer access the data, a lot more of the data processing was pushed to the clients. For many companies, that was far from ideal.

Enter SQL Server 2019. With Always Encrypted with Secure Enclaves, the benefits of Always Encrypted are retained, but the SQL Server engine gains the ability to carry out operations on the data - without the data ever leaving the server, and without decryption. How is this possible? Does it live up to its promises? Come to this session to find out and to see how to use it in your applications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 3:45 PM - 5:00 PM

Room: ARP 210

Everyone's had their data pipeline break. The difficulty is often pinpointing which of the many failure points caused the issue. Did the source system not provide data? Was it the ETL? Did the reporting layer fail? Maybe the data really is just weird this month?

This talk is an intermediate level solution to that pain point. We'll walk through a simple data ecosystem and how to build in testing at each failure point. Then we'll focus on setting up automated alerts.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 14

Time: 8:45 AM - 10:00 AM

Room: ARP 212

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 12:45 PM - 2:00 PM

Room: ARP 222

R isn't well known for enterprise Web Applications.  However, recent advancements in the R ecosystem aim to change that.  In this presentation, I will introduce what you need to know for building a production-ready web-app in R.

Here are a few topics we'll address:
* Building and Managing Database Connections
* Error Handling & Input Validation
* Load Testing
* Performance Tuning and Optimization
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 14

Time: 2:15 PM - 3:30 PM

Room: ARP 222

During this session you will be thrust into the role of the DBA hired to fix SQL Server to prevent it from ever getting SQL Injected, or at least minimize the damage that can be done when it does.  From bottom to top this session will cover how services should be configured, how SQL Server should be configured, benefits and risks of SQL Server security configurations, and best practices for app development.  Come learn how to defend your servers from hackers, or how to become a SQL Injection hacker yourself!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: September 14

Time: 10:15 AM - 11:30 AM

Room: ARP 114

Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt?  What else can you do to protect your sensitive data?
 
In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings.  This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.  Also, let’s learn how to classify data which should be protected and how to audit sensitive data usage. 
 
You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance.  Also, you will gather information on how to fully protect and review your sensitive data usage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 2:15 PM - 3:30 PM

Room: ARP 114

Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern which actions we take and which actions we avoid.

Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.

This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 14

Time: 8:45 AM - 10:00 AM

Room: ARP 116

We, as data professionals, are dealing with increasingly larger amounts of data. And, increasingly, we're asked to generate insights from this data. For that, the relationships between data points matter more than simple aggregations of individual data points. In our interconnected world, interconnected businesses, interconnected applications, graph databases lend themselves to answering relationship questions far more easily than...relational databases.

In this session we'll look at graph databases for
	how to model graph databases
	how to easily express relationships between interconnected data
	how to efficiently retrieve interrelated data 

We'll look at the MATCH predicate in T-SQL and the MATCH statement in Cypher, the query language for Neo4j.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 3:45 PM - 5:00 PM

Room: ARP 114

When designing your HA/DR solution, you need to consider all the possible options SQL Server has to offer to implement what is right for you.  You will see how to use Failover Cluster Instances, Standalone Instances, Clusters, Availability Groups and Distributed Availability Groups.

We will walk through how to set up and configure an HA/DR solution from beginning to end, review possible alerts, and how to monitor.  We will take a look at the new SQL2017 Read-scale Availability Groups and why to use them.  We will architect one of many possible VM solutions to host your HA/DR implementation.

Finally, we will see Automatic Failover and see how to perform a Manual Failover.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: September 14

Time: 8:45 AM - 10:00 AM

Room: ARP 114

Completing a full assessment on a SQL Server is essential to learning about not only the current state of the server, but also any area that may be impacting performance or security.  If you have more than one DBA, it is also important to have all the DBA team members review the same areas when completing an assessment.  During this session we will discuss when assessments are useful, what should be included in the assessment as well as how to interpret the results.  We will use a SQL script that will capture all the data needed.  This script will more than 88 data points, including fragmentation of indexes, performance counter values, server and database security information, queries that consume the most CPU time including execution plans as well as many other data points. This session will also cover how to document your findings and recommendations.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 14

Time: 8:45 AM - 10:00 AM

Room: ARP 224

There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature with Data Vault. Discover this highly audit-able modeling technique used in international banking, manufacturing, insurance and many more industries.  Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy.  Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 14

Time: 8:45 AM - 10:00 AM

Room: ARP 222

This is the advanced part 2 of Innovative Data Modeling.  Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. We will explore how you can use continuous integration and delivery to further maximize value.   Let's look at platform specific techniques and also explore design options for Azure SQL Data Warehouse.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 14

Time: 10:15 AM - 11:30 AM

Room: ARP 222

The xVelocity engine used by SQL Server Analysis Services Tabular, Power BI, and Power Pivot, is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq. We will show common and useful techniques to increase the compression ratio and obtain better performances from your Tabular data model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: September 14

Time: 12:45 PM - 2:00 PM

Room: ARP 224

Power BI is an amazing tool for end-user analytics and reporting, but if you don't architect for it correctly it may not work right as an enterprise reporting solution. Come to this session to get actual implementation details from a real deployment that was completed for a mid-sized company (1,500+ employees) and is being used daily by more than half of the employees after only a few months of being live in production. Using demos and actual documentation you will see what you need to think of for a project like this. We will be covering architecture, implementation, governance, change control, and support to get a Power BI enterprise deployment working successfully from someone that has done it! Azure Analysis Services, Power BI Pro, and Power BI Premium will be discussed and how each is being used in this solution as well.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 14

Time: 2:15 PM - 3:30 PM

Room: ARP 224

Powershell has become the defacto standard for scripting Microsoft products.  However, putting data in text files doesn’t scale.  Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections.  We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting.  This is a no holds barred session taught by an enterprise SQL Server scripting expert.  You can’t afford to miss this session if you do any level of scripting in your shop.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 14

Time: 3:45 PM - 5:00 PM

Room: ARP 222

Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata. 

To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 14

Time: 2:15 PM - 3:30 PM

Room: ARP 212

Power BI is an amazing tool for end-user analytics and reporting, but if you don't architect for it correctly it may not work right as an enterprise reporting solution. Come to this session to get actual implementation details from a real deployment that was completed for a mid-sized company (1,500+ employees) and is being used daily by more than half of the employees after only a few months of being live in production. Using demos and actual documentation you will see what you need to think of for a project like this. We will be covering architecture, implementation, governance, change control, and support to get a Power BI enterprise deployment working successfully from someone that has done it! Azure Analysis Services, Power BI Pro, and Power BI Premium will be discussed and how each is being used in this solution as well.
Prerequisites: Understanding of reporting/modeling in an enterprise setting is helpful, but not required for this session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: September 14

Time: 3:45 PM - 5:00 PM

Room: ARP 224

Power BI provides many options for acquiring and creating datasets. Do you know the difference between an Imported Model, a Live Connection, and DirectQuery? Have you tried Composite Models? Are you aware of the newest features related to Power BI Dataflows and XMLA endpoints? This session will review your options for where to store data and explain the factors that should be used in determining what option is right for you. Obvious requirements such as data size, license costs and management, and desired data latency will be discussed. We'll also talk about other factors such as the desire for self-service BI and avoiding data model sprawl. Join us for this webcast to learn how to determine the most appropriate type of Power BI dataset for your use case.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: September 14

Time: 3:45 PM - 5:00 PM

Room: ARP 116

Every wonder if you could predict the outcome of the Superbowl? Or know the score of any game? The NFL is perfect for predictive analytics: it has a fixed time frame, a set playing field, and rigorous rules.  These are characteristics we can only envy in the business world. With the aid of ML Services in SQL Server 2017, we have the strength of statistical languages like R and Python right within the database engine. In this session, John will demonstrate the steps for successfully preparing the data, then run a regression model to predict the scores for the current week’s scheduled NFL game.  Want to know if your team is likely to win against the spread?  Wanna bet?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: September 14

Time: 12:45 PM - 2:00 PM

Room: ARP 210

A truly strong security model starts with no permissions and adds what is necessary to allow the user or application to do their assigned task - no more, no less. This is called the Principle of Least Privilege. It's a simple concept, but it can be quite difficult to implement in practice, especially if the prevailing practice has been much more permissive.

In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 2:15 PM - 3:30 PM

Room: ARP 210

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