Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 43
Understanding Index internal operation is very important.
It is a fundamental knowledge of performance tuning and troubleshooting.
However, Index internal seems very hard to understand because many materials explain it a very complicated way.

This presentation covers from basic concept of index to all of internal index structure.
I will explain the index structure very simple concept.
Therefore, all developer who attends this session could understand how index work with a Clustered index and a Non-clustered index together.
Furthermore, this presentation will share very important tip how to troubleshooting index issue.
This presentation would very help not only who does not know index but also, who know very well index internal.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 22

Time: 9:15 AM - 10:15 AM

Room: 309

Predictive modeling contains six stages of analysis according to the Cross Industry Standard Process Model for Data Mining (CRISP-DM). I will break this down into three primary tasks for predictive modelers including preparing data, building models, and explaining results. 

Data preparation often requires skills in SQL, python, or other languages to be able to pull data out of data stores and convert the normalized data into flattened data that the algorithms can use to build models

Modeling requires a qualitative (if not quantitative) understanding of the algorithms, including mathematics or statistics, in order to build effectively. 

Finally, modelers should know how to explain the results of their findings to other analysts and to decision-makers and stakeholders.

The session will walk through the building of a predictive model for a retail application: predicting the days to next purchase propensity model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science, Analytics and Visualization

Level: Intermedia

Session Code:

Date: September 22

Time: 10:30 AM - 11:30 AM

Room: 317

Lift and shift is an utopia many IT professionals have about moving on-prem resources to the cloud. The truth is we must understand how the cloud works so we adjust, design accordingly and deliver to expectations. As SQL DBAs we have options. We can choose between IaaS or PaaS, between SQL in a VM or SQL DB, NoSQL options, Azure Data Warehouse some more. In this session we will dive into these options and understand some key points on the platform through some demos.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 22

Time: 9:15 AM - 10:15 AM

Room: 306

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science, Analytics and Visualization

Level: Intermedia

Session Code:

Date: September 22

Time: 4:00 PM - 5:00 PM

Room: 316

Windowing functions are when you add a "window" to which rows a function will look at using the OVER clause. We'll start by learning how to add the OVER clause to the commonplace COUNT, SUM, AVG, MIN, and MAX aggregate functions, since the OVER clause is optional. From there, we'll learn some ranking functions, which do require the OVER clause. You'll see examples that use the ROW_NUMBER function to identify and delete duplicate rows. Finally, we'll close with the RANK and DENSE_RANK functions that help you report on the grouping of your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 22

Time: 4:00 PM - 5:00 PM

Room: 308

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 22

Time: 4:00 PM - 5:00 PM

Room: 317

Historical review of how SQL Server has evolved over the years;
Significant additions and new features in some of the new versions;
There are fundamentally two career paths in the world of SQL Server: DBA and Developer
What is the future for each of these career paths and why is this an important question to ask?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 22

Time: 10:30 AM - 11:30 AM

Room: 311

Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 22

Time: 9:15 AM - 10:15 AM

Room: 111

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 22

Time: 12:15 PM - 1:15 PM

Room: 111

Why not create a report that only sends information if there is data?  Oh, don't have the Enterprise Edition?  I'll show you how with SQL Server Standard Edition.  This demo will walk you through the steps to create these data driven subscriptions.  We'll be using Reporting Services, Integration Services and SQL Agent Jobs to setup and schedule data driven subscriptions. SQL Server 2008 and up.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 22

Time: 2:45 PM - 3:45 PM

Room: 112

Every DBA should know about database corruption because it can be a resume generating event. A corrupt database can ruin your day, affect system stability, lead to unnecessary downtime, and possibly data loss. 

In this presentation we will explore database corruption, learn how to diagnose, and see what we can do to fix it. We will discuss the causes, dispel some myths, and learn what questions to ask. After this, we dive into discovering the root cause and putting a plan in place to stop it in the future. Demos will illustrate diagnosing, troubleshooting, and fixing database corruption. Prepare to break a database and go through the steps to return it back to a usable state. 

Beginners will benefit along with others who may one day find themselves with a corrupt database. By the end of the session, you will have the tools and understanding necessary to take corrective action and prevent your databases from corruption!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 22

Time: 2:45 PM - 3:45 PM

Room: 309

Cloud adoption for enterprise databases is in full swing.  Whether it is production databases supporting mission critical applications or for High availability or Disaster recovery, the Cloud is on nearly every enterprise roadmap. Organizations are presented with options when it comes to cloud platform vendors like Azure, AWS, Google, etc., but have business dependencies on high performance, tight security and near zero downtimes during and after migration. If you are planning on migrating your on-premises production database to the cloud, keeping test or development environments refreshed and in sync this session is for you.
Learn about:
-   Key trends driving cloud adoption
-   Top considerations for a DBA before moving databases to cloud
-   Architecture that supports on-prem/cloud/hybrid databases for HA or DR using Quest Software's SharePlex replication
Speaker:

Accompanying Materials:

Session Type:
Lunch Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 22

Time: 12:15 PM - 1:15 PM

Room: 317

Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.

Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.

In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: September 22

Time: 1:30 PM - 2:30 PM

Room: 311

Every team’s goal is to deliver business value faster, the question is how do you do that? If you’re a small shop with 1 or 2 developers then writing script in test and then running them production may be okay, but for a larger team that leads to problems. Using continuous integration (CI) and deployment techniques you can make small incremental changes which then set off a chain of automation steps that validates the new code. After automated validation, the code changes are ready for any additional User Acceptance Testing (UAT) and staging environments. During this session, you will learn how to manage database schema changes in a dynamic environment and deliver code to production by utilizing continuous integration and certain development techniques in minutes with minimal risk.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 22

Time: 2:45 PM - 3:45 PM

Room: 308

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: September 22

Time: 1:30 PM - 2:30 PM

Room: 306

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 22

Time: 4:00 PM - 5:00 PM

Room: 309

What is Data Driven? You might have heard someone at your organization say you need to be more data driven, but what does it mean? How does your organization need to change to be able to support being data driven?

As you might imagine it is a little bit more complicated that just saying the words or putting together a few charts. This session will talk about the fundamental things that you need to think about to move to being more data driven. It is a combination of people, process, policy and technology. This session will give you a lot to think about how to apply the principles of being data applies to your company.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: September 22

Time: 9:15 AM - 10:15 AM

Room: 316

Our tutorial is for anyone new to data science or is interested in taking the first steps. We start by highlighting how data science and artificial intelligence can help achieve business goals. We go into reviewing the data science process and steps involved. This is followed by a live hands-on workshop where we build a simple linear regression model to make predictions and then we evaluate the results.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science, Analytics and Visualization

Level: Beginner

Session Code:

Date: September 22

Time: 1:30 PM - 2:30 PM

Room: 316

In this session we will review the differences between deploying Microsoft SQL Server 2016 in Microsoft Azure and on-premises from a Security, Reliability and Scalability perspective. We'll review the common mistakes which people make when deploying SQL Server Virtual Machines to Azure which can lead to security problems including data breaches.  We'll review the common performance problems which people encounter, and how to resolve them. Finally, we'll review the common scalability misunderstandings of Azure and SQL Server Virtual Machines. Join us for this fun session and learn how to improve the security, reliability and scalability of your Azure deployments of SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 22

Time: 9:15 AM - 10:15 AM

Room: 317

Have you ever thought to yourself  “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!”  If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: September 22

Time: 9:15 AM - 10:15 AM

Room: 311

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