Build Schedule

Advanced Filters:
  • Track

    clear all















  • Speaker


  • Level


  • Session Type



Sessions Found: 38
Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you'll need a completely different mental model. In this introduction to DAX, we won't spend too much time on the basics. Instead, we'll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: March 30

Time: 8:30 AM - 9:30 AM

Room: 144

Certifications can set you apart from other candidates.  They can also force you to learn new technologies and approaches to business problems. In this session, we will cover Microsoft Certification options centered around data and Azure and which one may be right for you. We will also offer a couple of quick tips on test taking plus how certifications have changed. We will also touch on AWS and GCP certifications.
Speaker:

Accompanying Materials:

Session Type:
1 - Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 30

Time: 10:50 AM - 11:50 AM

Room: 144

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at using PowerShell scripts and JSON parameter files to automate the installation and post-install configuration of a SQL Server.
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 30

Time: 9:40 AM - 10:40 AM

Room: 111

As Microsoft releases new Azure features, migrating your ETL processes to the cloud is becoming easier all the time, but also more confusing.  Understanding the use and connectivity of the different storage and services is more critical than ever.  I'll start with an overview of Azure data components, detail how they can be integrated, and demo the lift and shift of existing SSIS packages to Azure.  I'll also demo some dynamic ways to program Data Factory and the features of the brand new Data Factory Data Flow!  Throughout, we'll discuss best practices for different Azure centric data migration strategies and explore the benefits of adopting an ELT approach.
Speaker:

Accompanying Materials:

Session Type:
1 - Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 30

Time: 9:40 AM - 10:40 AM

Room: 114

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected.  In this class, we'll cover the basics of the big five administrator tasks:

* Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
* Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
* Index maintenance – Databases need regular upkeep so they'll continue to run well.
* Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
* Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.

Being a database administrator is a big job, but we can cover the basics in one session!
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 30

Time: 8:30 AM - 9:30 AM

Room: 113

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:

Session Type:
1 - Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 30

Time: 10:50 AM - 11:50 AM

Room: 113

In today’s fast changing, demanding IT environment, moving from reactive firefighting mode to proactive performance optimization is key to organizational and personal success. A proactive culture improves your team’s effectiveness and your organization’s ability to meet goals, while promoting career advancement and a good work/life balance for team members. During this session you will learn how SentryOne can help you improve your organization’s overall data environment health, cut down on database crises, and focus on initiatives that move the business forward. Justin Randall, Senior Consultant at SentryOne, will demonstrate how you can break through Microsoft data platform performance barriers using SentryOne's award-winning SQL Sentry software.
Speaker:

Accompanying Materials:

No material found.

Session Type:
4 - Sponsor Session (45 minutes)

Track:
Beginners Level

Level: Beginner

Session Code: SentryOne

Date: March 30

Time: 12:30 PM - 1:15 PM

Room: 112

Are too many systems hitting your SQL Servers? Do you know who they all are? Are you under attack?
When it comes to this type of problem the consensus is to get with your network and domain admins to adequately configure access options. 
What happens when you can't wait or don't even have folks in that role to get the configuration right? 

A blacklist is a list of what cannot access something you are trying to protect. (Like the TSA no-fly list. If you are on the list, you are not getting anywhere fast.)

A whitelist is just the opposite. It is a list of what is permitted to access something. If whatever is attempting access is not on the list, it isn’t getting in.
In this session, we will go through the process to create and test your own SQL based whitelists and blacklists and also take a look at how whitelisting is being used in SQL 2017 to control what CLR objects can be trusted to run in your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
1 - Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 30

Time: 1:20 PM - 2:20 PM

Room: 144

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad relational database design (whether they know what the term "normalized" means or not.) Normalization is a key to great relational designs, but there is so much more to be considered. A normalized database that suffers from poor naming, too many or too few indexes, terrible interfaces, and so on can derail your design's value to the user.  In this session I will present primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be discussed.
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 30

Time: 9:40 AM - 10:40 AM

Room: 144

If there was one question you could ask your CIO, what would it be? In this session, you'll have the opportunity to hear a panel of three CIOs and CTOs discuss the State of IT in Virginia while covering topics such as technology strategy, leveraging cloud technologies, Big Data and more. This interactive session is geared at all levels of experience, so we hope you'll come with questions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
4 - Sponsor Session (45 minutes)

Track:
Beginners Level

Level: Beginner

Session Code: Solvaria

Date: March 30

Time: 12:30 PM - 1:15 PM

Room: Auditorium

The ""Cloud" is here.  With it, there are many options for storing and processing data.  What does it mean?  Why should you be interested in this conversation?  How can a cloud solution compare to an "on-prem" solution?  We will discuss these questions and more. The focus of this session will be on the options available in Azure from Azure SQL DB to Azure SQL Data Lake, but we will also touch on AWS and Google Cloud options to put the options in context.
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 30

Time: 8:30 AM - 9:30 AM

Room: 114

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Speaker:

Accompanying Materials:

Session Type:
1 - Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 30

Time: 1:20 PM - 2:20 PM

Room: Auditorium

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:
2 - Extended Session (90 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 30

Time: 1:20 PM - 2:50 PM

Room: 114

Seeking mentors, finding tools, measuring personal performance via database performance. Embracing bad code as the stepping stone to better systems. Updating statistics on system tables in MSDB and Master Keeping sharp by writing code. Cloud - more than test, DR or production.  Where does SQL fit in with ORACLE, DB2 and Graph databases
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: March 30

Time: 8:30 AM - 9:30 AM

Room: 143

R, R Studio, Microsoft R Services, Microsoft R Server, Machine Learning Server. What is R and how do you make sense of all these R options?

Join me for a quick R timeline and description followed by some use cases and live demonstrations.

Take with you a better understanding of why analysts, developers, DBAs, PMs, CIOs, and others want to know what is up with R.
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: March 30

Time: 2:30 PM - 3:30 PM

Room: 143

Overview of PowerShell Basics and how to manage SQL server using PowerShell scripts. In this session you will learn the basics on building scripts using PowerShell and then learn the basics of using PowerShell for SQL server administration.
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
Beginners Level

Level: Beginner

Session Code:

Date: March 30

Time: 9:40 AM - 10:40 AM

Room: 112

Looking to implement Power BI, but aren’t sure where to start?  Let us show you what you need to know!
Speaker:

Accompanying Materials:

No material found.

Session Type:
4 - Sponsor Session (45 minutes)

Track:
Beginners Level

Level: Beginner

Session Code:

Date: March 30

Time: 12:30 PM - 1:15 PM

Room: 114

Your databases are growing and consuming ever-increasing amounts of storage. This rapid unceasing growth creates difficult challenges managing query response times, backups, recovery time, data transfer and essential maintenance. What's a DBA to do? SQL Server data compression is a proven option for saving storage space and improving performance.
In this presentation you will learn how data compression works, how to determine when data compression is the right option, and other planning and implementation considerations.
Speaker:

Session Type:
1 - Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 30

Time: 10:50 AM - 11:50 AM

Room: 112

In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017.  Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities.  Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.
Speaker:

Accompanying Materials:

Session Type:
1 - Regular Session (60 minutes)

Track:
Enterprise Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 30

Time: 8:30 AM - 9:30 AM

Room: Auditorium

Every good enterprising DBA has the prime directive of monitoring the SQL Servers under his/her jurisdiction. The last thing a DBA wants to hear is that there is a problem with a database under his/her purview from an end-user. 

SQL Server has progressed over time to give better and better information to the DBA. Much of this information can be used in a home grown solution to monitor SQL Server. With the constant increase in surface area from Extended Events, the power to build a home grown solution becomes more and more feasible while being limited only by the imagination of the enterprising DBA (or developer or data professional). 

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
1 - Regular Session (60 minutes)

Track:
Internals & Performance

Level: Intermedia

Session Code:

Date: March 30

Time: 10:50 AM - 11:50 AM

Room: Auditorium

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