Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type



Sessions Found: 43
When is Time Period based calculations useful in Power BI? Quick answer - ALWAYS!  Business users need to know measures such as: What was Sales, what was the change compared to last-year, year-to-date? Did our Expenses go down, compared to similar period last year? etc.

In this session you will learn how to use and apply DAX functions in Power BI, to 
develop Time and Date based dimensions and measures that will help answer such 
questions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Intermedia

Session Code:

Date: September 14

Time: 11:15 AM - 12:15 PM

Room: Room 4

In the last releases,  SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: September 14

Time: 11:15 AM - 12:15 PM

Room: Room 3

Database development and administration require temporary objects for ETL, staging, data processing, and many other common tasks.

In this session, we will delve into temporary tables, table variables, and memory-optimized table variables, discussing their differences, how they work, and the optimal scenarios for using each of them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Room 3

Negotiating a downtime for a release can be difficult in this modern, 24x7 world.  When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly.  This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment.  We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking.  We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing.  If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Advanced

Session Code:

Date: September 14

Time: 2:45 PM - 3:45 PM

Room: Room 3

In this session we will compare the offerings of Azure SQL Databases, then dig in and show what separates SQL Managed Instances from the rest. We’ll take a look at challenges that previously prevented migrations to Azure, the current features available, some common architectures, and backup and restore options.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Room 4

Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together. 

This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Room 6

Would you like to create Pivot Tables in SQL with ease? 

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris.
*Not Possible
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Intermedia

Session Code:

Date: September 14

Time: 2:45 PM - 3:45 PM

Room: Room 1

Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success.  Often times we focus on showing how smart we are instead of showing what a good team member we can be.  We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills?  We will explore innovative and fun ways in which to do just that!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 14

Time: 2:45 PM - 3:45 PM

Room: Room 7

NoSQL is not just about having eventual consistency. Switching from a relational database to a NoSQL data store like Cosmos DB is a mind shift for SQL DBAs and developers used to thinking in terms of tables. Schema-free doesn’t mean you don’t have to think about the schema, but it does allow for faster changes and some interesting design patterns. 

This session will include a quick outline of Cosmos DB. Then it will move on to describe how indexing works, what the consistency levels all mean, and how your JSON should be designed based on your query patterns. And, I will toss in a high-level overview of the JavaScript triggers, stored procedures, and user defined functions for free. All of this will be presented using examples that are informed by my experience trying to convert a global application from SQL Server to Cosmos DB using the document model.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: September 14

Time: 2:45 PM - 3:45 PM

Room: Room 6

Do you practice restores on a regular basis, but others in your organization do not? Are you worried that a restore may not be complete? As a DBA you are responsible for much more than simply backup and recovery of databases. This session will go over how to backup some SQL Server objects like Alerts, DBMail, LinkedServers, SQL Agent properties, and others with PowerShell. 
 
I have not always trusted others to be able to restore a machine. This talk walks through how to CYA in the event of an emergency by backing up SQL objects other than just the databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: September 14

Time: 4:00 PM - 5:00 PM

Room: Room 5

The cloud continues to become ever more prevalent in corporations around the world, disrupting traditional IT and forcing either adoption or early retirement. All too often, companies attempt a simple "lift and shift" approach that doesn't really net anything more than the Same Old App, now just running on someone else's server (and probably more slowly than it did in its old on-prem home). But the cloud does in fact have a large number of advantages for those of us doing complex data processing. To truly take advantage of its silver lining, you must go beyond lift-and-shift and fully embrace nativity. This session focuses on core concepts, combined with a heavy dose of real-world lessons gleaned while working to build cloud-based data platforms from the ground up. You'll learn why cloud storage and local storage can't be thought of as equivalent, why queues are the basis for pretty much everything in all of computing, and why you must start thinking about applications from the perspective of elasticity and eventual consistency rather than simple transactional functionality. You’ll leave this session with a fuller understanding of what it really takes to build a successful cloud application.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: September 14

Time: 4:00 PM - 5:00 PM

Room: Room 2

Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Beginner

Session Code:

Date: September 14

Time: 1:30 PM - 2:30 PM

Room: Room 3

In this demo driven session you will learn how to: prepare your computer for installation of the dbatools module, install dbatools and pre-requisites, use dbatools commands to automate routine tasks such as migrating logins and jobs, setup log shipping, and add databases to availability groups. At the end of the session, you will be able to return to your office with dbatools as a new tool in your toolkit to help you manage your SQL Server estate in a more efficient manner.
Prerequisites: Basic PowerShell knowledge. Some SQL Server Administration experience
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: September 14

Time: 1:30 PM - 2:30 PM

Room: Room 2

Always On Availability Groups (AGs) have evolved since their introduction in SQL Server 2012. Not only is there the “classic” form of AGs, but now there are Basic Availability Groups, Distributed Availability Groups, Domain Independent Availability Groups, and Read Scale Groups. Also complicating the picture is virtualization, hyperconverged, the public cloud, Linux, as well as containers which is new to SQL Server 2019. Come to this session to learn what AGs are – and are not – today, the differences between the various AG and deployment options, and how you can harness the power of them in your environments.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Room 1

Ever wonder about becoming an ETL master using SSIS platform? Come to this session to learn some advanced techniques and design patterns that can be used in solving some day-to-day integration development challenges.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Advanced

Session Code:

Date: September 14

Time: 1:30 PM - 2:30 PM

Room: Room 7

Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (40 minutes)

Track:
Sponsor/Other

Level: Beginner

Session Code:

Date: September 14

Time: 12:35 PM - 1:15 PM

Room: Room 5

Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.

Coverage:

1 – Granting correct user access is vital.
2 – DML triggers to keep a DATA audit trail.
3 – DDL triggers to keep a SCHEMA audit trail.
4 – Preventing unwanted DATA modifications.
5 – Preventing unwanted SCHEMA changes.
6 – Preventing table TRUNCATIONS.
7 – LOGIN triggers to control who, what, and when.
8 – Change data capture (CDC) an alternative to triggers.
9 - Which of these techniques apply to an Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: September 14

Time: 4:00 PM - 5:00 PM

Room: Room 6

Whether you are deploying on premises (physical or virtual) or up in a public cloud (Amazon Web Services, Microsoft Azure, or Google Cloud Platform), your SQL Server databases and instances need to be highly available. Some options, such as Always On Failover Cluster Instances (FCIs), are not easy to deploy when you need some form of shared storage and traditional storage methods are not accessible. Other times you have storage performance requirements in addition to availability that cannot be met by traditional solutions such as a SAN. Come to this session to learn how SIOS DataKeeper Cluster Edition can enhance your SQL Server deployments to help you achieve high availability, disaster recovery, and storage performance goals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (40 minutes)

Track:
Sponsor/Other

Level: Beginner

Session Code:

Date: September 14

Time: 12:35 PM - 1:15 PM

Room: Room 6

SQL Server 2019 allows you to deploy a scalable cluster of SQL Server, HDFS and Spark in Kubernetes. It brings you new capabilities to integrate structured and non-structured data, create data virtualization on top of it and integrate AI with it. Sounds amazing, right?
Join me in this session and I show you how it is easy to deploy this cluster and start using it, capabilities it provides and how to manage it. We also review some use cases that are relevant to this solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics/BI

Level: Beginner

Session Code:

Date: September 14

Time: 4:00 PM - 5:00 PM

Room: Room 3

Getting started with GitHub can at times be overwhelming.  Especially when you've been working with other source control and project management systems your whole career.  In this session, we will overview the below tasks to ensure your success with GitHub.
* Initial setup of a Repository in GitHub.
* Build Issue templates for new features, bugs, or custom tasks.
* Securing the check-in/merge process to your root branch.
* Integrating GitHub with other productivity tools to keep on top of changes.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: September 14

Time: 2:45 PM - 3:45 PM

Room: Room 5

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