Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 33
Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of 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:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 06

Time: 9:00 AM - 10:00 AM

Room: Room 256

Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of 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 & 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:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 06

Time: 10:15 AM - 11:15 AM

Room: Room 256

In today’s marketplace, moving to the public Cloud(AWS) is a familiar and consistent trend within the SQL Server community. After all there are so many offering choices between AWS EC2 and RDS, each with their own distinctive features. Migrations to the cloud are only going to gain greater momentum as organizations grapple with their on-premises alternatives. 
In this presentation, we will discuss various methods and explain the advantages and disadvantages of using each method along with best practises. We’ll also showcase the surprises and pitfalls to avoid as we venture into the process.
Learn more on what trends you can expect to see, what the future holds for public clouds, and see how the DBA role and their responsibilities are undergoing changes to fit into the new profile necessary in managing the cloud framework.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 06

Time: 9:00 AM - 10:00 AM

Room: Room 254

Since PowerBI is a great tool for telling us Data stories, and Azure SQL DB is the easiest place to hold DATA, Both are very good friends....
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 06

Time: 2:45 PM - 3:45 PM

Room: Room 5

A common critique of SQL is that it can be hard to write queries with reusable parts, something which is trivial in many programming languages. For example, even something simple, like running a query with different set of selections can be tricky to express. 

This presentation will show how this problem can be avoided by taking a data-first approach and using some advanced TSQL constructs. Along the way, we will also go over how to do GraphQL-like queries in TSQL.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: April 06

Time: 10:15 AM - 11:15 AM

Room: Room 260a

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: April 06

Time: 10:15 AM - 11:15 AM

Room: Room 259

Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone can use them? This can be especially important if you are making reports for government entities, educational institutions, or the general public. In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 06

Time: 3:15 PM - 4:15 PM

Room: Room 254

The practice of Data Science has arrived and as data professionals we're on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before. 

To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session, we will start by providing an introduction to Python, quickly becoming the defacto programming language for data scientists who want to create enterprise-ready solutions.

Carlos will then cover predictive analytics using T-SQL and Python, providing a practical understanding of what it takes to develop your own predictive models making the most of the expertise you already have. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into an analytics environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: April 06

Time: 3:15 PM - 4:15 PM

Room: Room 256

This will be an introduction into using Extended Events and why to drop using SQL Trace. As well as some basic scripts with tools for parsing XQuery, and some good basic XE use cases.  This session will help become more comfortable with Extended Events.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 06

Time: 9:00 AM - 10:00 AM

Room: Room 259

Self-promotion is often confused with bragging, but most of the time it is the best tool to advance your career. In this session we talk about how self-promoting is the first step to creating your brand. Many IT Professionals struggle with how to stand out in a room, be noticed in a pile of resumes or maneuver for promotions. By learning to network and communicate effectively, these hurdles are converted into advancement ladders.  Self-Promotion and Networking are skills and therefore can be taught and learned. We will discuss ways to use social media, communities and other avenues to increase your brands visibility online. Equally important is your ability to interact with co-workers, clients and management face to face.  We will discuss ways to meet and network with other individuals and give you the tools to stand out from your peers.  Building and engaging with a large network will increase your worth to both your current and future employer.  Transform into a Networking Master.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 06

Time: 2:00 PM - 3:00 PM

Room: Room 254

Tempdb has been a source of configuration confusion since the very first version of SQL Server. Each SQL Server instance only has one tempdb database used by all users in all databases. In this session, we’ll look at all the different uses of tempdb and how to configure your tempdb to support them. We’ll look at all the different kinds of temporary tables and see when you should use each type. We’ll talk about the difference between global and local temp tables, table variables and work tables. We’ll explore the various tools available that let you monitor the use (and abuse) of your tempdb database and we look at some best practice guidelines for how to keep your tempdb as healthy as possible.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 06

Time: 11:30 AM - 12:30 PM

Room: Room 256

In this session, we will explore the options we have when working with SQL Server running on Docker containers or Kubernetes. Also, will take a look at some real-world scenarios of backing up \ restoring databases in containers, high availability, version upgrades, and the most important portability. Join me to discuss further about this interesting topic that is called by some experts as “The Future of Database Infrastructure”.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 06

Time: 9:00 AM - 10:00 AM

Room: Room 260a

A modern Information Environment requires a wide and growing variety of disciplines, each with discrete skills that should compliment but often overlap others.  By understanding disciplines like Data Management, Acquisition, Modeling, Engineering, Science and BI Developer, Analyst, and Architect you will better understand how to work with others and how you might grow or transition into other roles.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 06

Time: 9:00 AM - 10:00 AM

Room: Room 260b

If you’ve looked at the cloud, you’ve realized the large number of options you have, to implement a complete cloud analytics solution. You can deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have, to run Cloud Analytic Solutions on Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 06

Time: 11:30 AM - 12:30 PM

Room: Room 254

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: April 06

Time: 3:15 PM - 4:15 PM

Room: Room 259

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 (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 06

Time: 2:00 PM - 3:00 PM

Room: Room 253

The modern BI professional is taking on the challenge of operationalizing data science. Most BI developers are very strong in TSQL but their exposer to advanced statistics and visualizations were limited by what is available in the TSQL language. The R programming language allows us to clean, visualize, and apply advanced statistical methods to data. 

In this session I will demonstrate how to use R Studio to generate and test R scripts; generate R visuals in PowerBI; call R code in machine learning workflows; and execute R code in SQL Server. Additionally, I will cover these R programming fundamentals: creating and assigning variables; performing simple calculations; understanding R data types; vectors; matrices; factors; lists; data frames; and ggplot2 graphics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 06

Time: 10:15 AM - 11:15 AM

Room: Room 253

Starting with SQL Server 2016, SSMS became a stand-alone product.  Updates are sent out a lot more frequently than in the past and it can sometimes be difficult to keep up with all of the changes and new features.  There were 7 new version releases in 2017 and 8 new version releases in 2018.  With all of the new releases, are you using SQL Server Management Studio to its fullest?  We will discuss some of the features available in the SSMS v17 and v18.

On top of the new versions, there is a lot of cool stuff available in SSMS that you may not be aware is there.  We will discuss and demonstrate some features offered in SSMS that will help make Developers and Database Administrators more productive (and everyone wants to be more productive).  Whether a DBA or a Developer, you will take away knowledge about the new SSMS versions along with some useful SSMS tips/tricks to use in SSMS that you can apply in your day to day activities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 06

Time: 10:15 AM - 11:15 AM

Room: Room 260b

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 (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 06

Time: 3:15 PM - 4:15 PM

Room: Room 260a

You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session expects that attendees are already familiar with Availability Groups.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 06

Time: 3:15 PM - 4:15 PM

Room: Room 260b

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