Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 36
Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations?  This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 29

Time: 10:00 AM - 11:00 AM

Room: 1777

How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties.  Seems like that is all I have done for last many years.  But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios.  In some scenarios a well-defined clustered index may out perform a covering non-clustered index.  Results are very interesting and may surprise you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 29

Time: 11:15 AM - 12:15 PM

Room: 1778

Presented by Redgate 

DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX.  We’ll discuss the techniques used to include the data
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 29

Time: 11:15 AM - 12:15 PM

Room: 2151

It's not a question of whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA's and we should all strive to learn it. In this session, we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new-found knowledge will help propel your career into the new landscape.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 29

Time: 11:15 AM - 12:15 PM

Room: 1777

As more data services come online in Microsoft Azure, DBAs are being tasked with bringing these services into their organizations.  Azure Databricks is one such service that has the appeal of combining scalable compute resources with collaborative development and analytic tools in Notebooks and workspaces.  To the traditional DBA, however, many of the concepts and language support may be foreign. What the heck is Scala anyway?  This session is designed to introduce the DBA to the Azure Databricks workspace and show how to easily integrate it with upstream and downstream services like Azure Data Factory, Machine Learning and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 29

Time: 1:45 PM - 2:45 PM

Room: 2151

Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session.  This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: 2151

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I can't tell you how many times I've heard these phrases.  This session will help you understand why choosing the correct data type for your data is so important.  It affects data quality, storage and performance.  It can even produce incorrect query results.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 29

Time: 1:45 PM - 2:45 PM

Room: 2146

Cloud is rapidly changing the way modern day applications are being designed. Data is at the center of multiple challenges while architecting solutions in cloud.

With technology changing rapidly, there are new possibilities for processing data efficiently. Come join me in this session to learn more about the tools and technologies that will help you to design data intensive systems. We will take a structured approach towards architecting data-centric solutions, covering technologies like message queues, data partitioning, search index, data cache, event sourcing and NoSQL solutions.
 
If you are a Data professional, Software Engineer or Architect, come join me in this session to understand the high-level design principles that will help you build scalable, resilient and maintainable systems in cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 29

Time: 3:00 PM - 4:00 PM

Room: 1774

This topic will be about creating dynamic SSIS packages using BIML. Dynamic SSIS packages will help eliminate the hassle of having to manually change items in a Data Flow task when an underlying table change occurs. This talk will start from the ground up, showing a basic SSIS package, what it would take to create it dynamically in C#, and then the same package using BIML. While we will show some examples of BIML and C#, no experience in either of these is required, as the talk will be more concepts to get ideals flowing.

If you have data to move, BIML could be your new friend!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 29

Time: 1:45 PM - 2:45 PM

Room: 1773

Attendees will learn how to design a Dynamic Hierarchical Row Level Security system using for Power BI using Active Directory, Powershell and SSAS Tabular.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: 1773

Data breaches abound! Do you want to keep off of the data breach list? 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. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.  

You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance.  In addition, you will gather information on how to fully protect and review your sensitive data usage.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: 1774

With the most recent release of SQL Server 2017 and the upcoming release of SQL Server 2019, there are several enhancements that were introduced for the T-SQL language. This includes new string functions, bulk access options and approximate query processing among others that address several challenges that SQL developers have to confront.  

In this demo heavy session, we will go over several of the new features, provide a demonstration of how you can use them, and share any considerations that you may need to consider before doing so. This session is intended for anyone interested in what’s new in the T-SQL language and will focus primarily just on enhancements to traditional T-SQL for the database engine.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 29

Time: 10:00 AM - 11:00 AM

Room: 2146

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 29

Time: 11:15 AM - 12:15 PM

Room: 2146

Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: 2142-Auditorium

As a manager or team leader giving effective feedback is vital to the success of projects. Managers often ascend the hierarchy due to their technical skill set but rarely learn ways to successfully communicate with their team. In this session, we will discuss soft skills and best practices to give feedback. We’ll learn the essentials for an interaction and how to prepare for tough conversations. Using sample coaching conversations, we’ll run through examples to help you prepare for your next tough dialog. Whether it is a simple coaching sit down, or performance improvement related, and even disciplinary actions, learn how to handle confrontation tactfully.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 29

Time: 10:00 AM - 11:00 AM

Room: 2151

So your boss asked for a copy of your DR plan.  Once you've wiped that deer-in-the-headlights look off your face, you realize "We've got database backups," isn't exactly a plan.  You need to come up with a plan to recover your business when disaster strikes. This session will help you build this plan by defining what a disaster could be, documenting the business impact, and identifying your limitations.  We will show how to use this information to establish metrics (such as RTO and RPO), document current recovery configurations, and design an effective recovery strategy that meets the needs and budget of your business. Attending this session will give you the knowledge and tools to create an effective disaster recovery plan that will make your boss happy and ensure the continuity of your business.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 29

Time: 10:00 AM - 11:00 AM

Room: 1778

Are you uncertain about the health and capacity of your SQL Server? Are you taking over a new server and need to get a better understanding of the health of the server? Are you uncertain if your servers are following industry best practices?

In this session we will start by discussing the importance of performing a Health Check. We will then show how to run the popular Blitz script by Brent Ozar. After that we will review the other key areas to check like the VM configuration, Windows Configuration, SQL Configuration, Security configuration, and Database configuration. Finally, we’ll show how to save the results for capacity and trending analysis

At the end of the session you will be able to: (1) Perform a Health Check on a server; (2) List the key areas for improvement; (3) Save the results for capacity and trending analysis.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 29

Time: 3:00 PM - 4:00 PM

Room: 1777

Performance is what your users care about, and indexes can both improve and decrease
performance. As a SQL Developer, do you understand the difference between a clustered and
non-clustered index or what a covering index is? What is different between OLTP and data
warehouse databases when it comes to indexing?
This session is a deep dive into
? Clustered indexes
? Non-clustered indexes
? B-Tree traversal
? Primary Keys
? Covering indexes

This session will feature live query demos illustrating index utilization and performance using
statistics and query plans. Understand indexing like a rocket scientist by attending this session!

Some knowledge of T-SQL and Management Studio is recommended.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 29

Time: 8:30 AM - 9:30 AM

Room: 2146

In the world of Power BI, data modeling is what separates the Rockstars from the Rookies. Join me to learn how dimensional modeling - a concept developed 20+ years ago - continues to be the best approach for delivering self-service BI to the masses.

Not only will good data modeling result in better Power BI solutions that support a wider range of reporting requirements, but they will also be easier for the business users to understand and work with. 

In this session, you'll learn how to create flexible data models that can be expanded upon over time, unlock the power of the date table, and a variety of DAX patterns supporting common but complex business logic.
 
If your Power BI solutions typically contain a single table, if you're frequently banging your head against the wall trying to figure out how to write a DAX calculation, or if you've never heard the term "dimensional model" this session is for you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 29

Time: 3:00 PM - 4:00 PM

Room: 1773

You just walked into that fancy new gig, and you're getting your first cup of coffee.  Your boss walks up and asks, "Who has access to that prod server?", do you know how to get the answers in the next hour?  More importantly, do you know what these permissions mean, what an attacker could do with these permissions?  In this session we'll start from scratch assuming that you have no experience with an audit with this question in mind.  We'll work back from here to develop a strategy of how to harden your server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 29

Time: 3:00 PM - 4:00 PM

Room: 1778

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