Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type


Sessions Found: 48
If you've ever wondered what that other service is in your configuration manager then this is the class for you.  Full text indexing allows you to write queries to scan large text fields without having to do a complete table scan every time.

We'll talk about installing, setting up, maintaining, and using full text indexes to their fullest!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Performance - 1

Level: Intermedia

Session Code: ROOM 5

Date: February 02

Time: 2:45 PM - 3:45 PM

Room: Database Performance - 1

Most people don’t know it but the current “Best Practice” Methods are actually the leading cause of perpetual logical and physical fragmentation, costly and continuous “Bad” page splits, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, the whole reason for why we have to do so much index maintenance.

This isn’t your typical presentation on Index Maintenance.

In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice” methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Performance - 2

Level: Advanced

Session Code: ROOM 7

Date: February 02

Time: 9:45 AM - 10:45 AM

Room: Database Performance - 2

Most people don’t know it but the current “Best Practice” Methods are actually the leading cause of perpetual logical and physical fragmentation, costly and continuous “Bad” page splits, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, the whole reason for why we have to do so much index maintenance.

This isn’t your typical presentation on Index Maintenance.

In this second of two back-to-back sessions, we’ll learn of several incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it,  virtually eliminate “Bad” page splits, reduce wasted memory, make your log file and log file backups a whole lot more happy, and increase the overall performance of even perfect code.

We’ll also learn that no simple method is a panacea, what to do about the horror of "expAnsive" updates, and how to make even GUID-keyed indexes work well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Performance - 2

Level: Advanced

Session Code: ROOM 7

Date: February 02

Time: 11:00 AM - 12:00 PM

Room: Database Performance - 2

Newer releases of SQL Server have introduced many new functions developers may not know or use. This includes functions for type conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, in addition to some best practices for using these functions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code: ROOM 8

Date: February 02

Time: 4:00 PM - 5:00 PM

Room: Development

This session is for the absolute beginner to learn the basics of Transactions and will answer questions such as, What is a Transaction? What are the ACID properties of a Transaction? How does the Transaction Log work to provide consistency to a database? What is a checkpoint? Are dirty pages bad or good? What is a lock? The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Design

Level: Beginner

Session Code: ROOM 2

Date: February 02

Time: 1:30 PM - 2:30 PM

Room: Database Design

Do you know what makes a great data model?  What does it mean to be Third Normal Form or a Star Schema?  When would you use one over the other and why?  How can you identify bad designs?  In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Design

Level: Beginner

Session Code: ROOM 8

Date: February 02

Time: 8:30 AM - 9:30 AM

Room: Database Design

Have you been hearing about Azure Managed Instances and want to know what all the fuss is about? Come see how Managed Instances is changing how we think about cloud databases. Managed Instances can be considered a hybrid of Azure SQL Database and on-premises SQL Server with all the great benefits of Platform as a Service. You'll see first-hand how easy it is to migrate databases from on-premises to a Managed Instance. We'll explore the differences between Azure SQL Database, Managed Instances, and SQL Server on an Azure VM to help you determine which is the best fit for your organization's requirements. If you've been considering Azure for your organization, this session is for you!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code: ROOM 6

Date: February 02

Time: 11:00 AM - 12:00 PM

Room: Cloud

Many data analysts typically begin to work with data as a single flat table. While this works for small datasets, as the size of the data grows these naive methods do not scale. Processing records takes longer, queries become more complex, and introducing new datasets is inconsistent at best. In order to solve these problems, we must take into account the underlying architecture of our data and how it should be modeled. During this talk we will discuss key concepts, patterns, and techniques for designing a data model that is simple to query, scales with your data, and is extendable to new datasets.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Design

Level: Intermedia

Session Code: ROOM 8

Date: February 02

Time: 9:45 AM - 10:45 AM

Room: Database Design

Coding is always a fun but challenging job. Developers do not only have to execute the right output based on the business requirement but also need to maintain right coding standards by using the optimum use of variable sizes and keeping in view the other best practices. The session will cover the key best practices which developers can follow and get benefited.
Many of us already may have been using these steps already but for those who are new to the development process or want to brush up, the session is for you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code: ROOM 8

Date: February 02

Time: 2:45 PM - 3:45 PM

Room: Development

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:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code: ROOM 1

Date: February 02

Time: 9:45 AM - 10:45 AM

Room: Cloud

Azure Data Studio (formerly SQL Operations Studio) is the modern, cross-platform database management tool for SQL Server, both on-premise and in the cloud.  A simple, clean approach to a UI creates an experience different from other SQL management tools today.  Fully integrated intellisense with customizable code-snippets, connection management, and dashboards, Azure Data Studio, provides the T-SQL editor experience most of us expect today.  Unlike other tools, Azure Data Studio is 100% open-source, easily extensible, and has full integration to modern source control solutions like GIT.
In this session, we introduce Azure Data Studio and interacting with SQL Server environments.  We will focus on productivity comparable to SSMS, shortcuts and time savers, as well as how to leverage source control.  Lastly, we will cover extending Azure Data Studio by setting up a development environment, and walking through the process of build and debugging a custom dashboard component, using Electro
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Architecture & Tools

Level: Beginner

Session Code: ROOM 3

Date: February 02

Time: 9:45 AM - 10:45 AM

Room: Architecture & Tools

Many database professionals are familiar with concepts throughout the process of Implementing a Data Warehouse, but how many of us have started from scratch and ultimately created an OLAP Cube? While preparing for Microsoft Certification Exams (Implementing a Data Warehouse), I set about to do exactly that. This presentation will share my experiences along the way focusing on initial Data Warehouse design and final OLAP cube creation in SQL Server Analysis Services.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics & Visualization

Level: Beginner

Session Code: ROOM 7

Date: February 02

Time: 4:00 PM - 5:00 PM

Room: Analytics & Visualization

Azure Cosmos DB is the newest Microsoft Azure product. Developers can build scalable, responsive applications at a global level by using it. Microsoft really believes in this product and wants Cosmos DB to be the database of the future.

In this session, I will cover the following topics in this session 
Why do we need another database system?
How to setup Cosmos DB
How much does it cost?
Multi-Model Apis
Cosmos DB vs SQL Server
How to Import Data
How to use Cosmos DB Emulator
Cosmos DB Limitations
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code: ROOM 5

Date: February 02

Time: 1:30 PM - 2:30 PM

Room: Cloud

Since data compression is now a standard level feature (2016 SP1+) learn how to squeeze a little extra performance out of your databases for free!  We’ll cover the types of compression available, the costs and benefits and how to determine good candidates for compression. Once we know what we want to compress we’ll cover three ways to apply it, including the easiest way to compress your whole database to meet best practices with just one line of code!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Performance - 2

Level: Intermedia

Session Code: ROOM 1

Date: February 02

Time: 8:30 AM - 9:30 AM

Room: Database Performance - 2

Do you have ETL processes pulling data from multiple data sources into a data warehouse so you can run reporting from a single source?  If so, this session is for you!  SQL Server 2019 enhanced the PolyBase feature that was introduced in SQL Server 2016.  Come learn how to use the new PolyBase features enabling you to use T-SQL queries that generate reports on data stored in all of your data sources without the need of a physical data warehouse!  Using SQL Server, Oracle, MongoDB, Hadoop, Spark and more….  we will introduce you to the Enhanced PolyBase features, share with you some code examples to get you started, show you the architecture options, and examine the reporting capabilities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Architecture & Tools

Level: Beginner

Session Code: ROOM 1

Date: February 02

Time: 2:45 PM - 3:45 PM

Room: Architecture & Tools

There are so many topics for a DBA to focus on that it can be overwhelming for a new or accidental DBA.  Without knowing what's most important, you can find yourself spending lots of time trying to figure out what's important.  This session focuses on the five topics that matter most to a DBA.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Monitoring & Maintenance

Level: Beginner

Session Code: ROOM 4

Date: February 02

Time: 2:45 PM - 3:45 PM

Room: Database Monitoring & Maintenance

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

Level: Beginner

Session Code: ROOM 5

Date: February 02

Time: 9:45 AM - 10:45 AM

Room: Development

Every expert has their own set of tools they use to find and fix the problem areas of queries, but SQL Server provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues, right in the box. In this session we will examine a variety of tools to analyze and solve query performance problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Architecture & Tools

Level: Beginner

Session Code: ROOM 5

Date: February 02

Time: 8:30 AM - 9:30 AM

Room: Architecture & Tools

As companies work to gain insight from ever-increasing amounts of data, data platform practitioners need tools which can scale along with the data.  Early big data solutions in the Hadoop ecosystem assumed that data sizes overwhelmed available memory, emphasizing heavy disk usage to coordinate work between nodes.  As the cost of memory decreases and the amount of memory available per server increases, we see a shift in the makeup of big data systems, emphasizing heavy memory usage instead of disk.  Apache Spark, which focuses on memory-intensive operations, has taken advantage of this hardware shift to become the dominant solution for problems requiring distributed data.  In this talk, we will take an introductory look at Apache Spark.  We will review where it fits in the Hadoop ecosystem, cover how to get started and some of the basic functional programming concepts needed to understand Spark, and see examples of how we can use Spark to solve issues like calculating PageRank.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code: ROOM 1

Date: February 02

Time: 4:00 PM - 5:00 PM

Room: Cloud

Starting in SQL 2016, two rivals entered the ring in a professional fight for format supremacy. XML seems too fat to compete with the newcomer JSON but a fight has begun.  JSON doesn't seem experienced enough to have real punching power but does it have the speed to win?  Who is the pound for pound format champion?  Come watch this action-packed bout between two titans of SQL.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code: ROOM 4

Date: February 02

Time: 11:00 AM - 12:00 PM

Room: Development

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