Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 56
Dell EMC’s unique integrated copy data management (iCDM) offering combines performance & scalability with reduced operational risk through automation and self-services. Maximize the value of your company’s storage deployment by simplifying MS SQL database & application workflows and reducing development timelines. In this session, we will discuss how application admins and DBAs can repurpose different copies SQL Server DBs instantaneously and become more agile.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: January 12

Time: 12:20 PM - 1:20 PM

Room: S316

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 Administration

Level: Beginner

Session Code:

Date: January 12

Time: 11:00 AM - 12:00 PM

Room: S260

The Microsoft Azure offering now has several compelling features that are helpful to the business and to the data professional.  This session highlights the landscape and provides an introduction to the landscape with an emphasis on SQL Server offerings.  At the end of the session, the attendee will have some additional vocabulary they can use as they discuss Azure with others or they go looking for additional details.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 12

Time: 1:30 PM - 2:30 PM

Room: S213

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: January 12

Time: 9:45 AM - 10:45 AM

Room: S339

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:
BI Architecture & Management

Level: Intermedia

Session Code:

Date: January 12

Time: 11:00 AM - 12:00 PM

Room: S270

Moving data around in On-Prem databases is easy. 

Moving data around when involving Azure - may be not. Especially if you don't have a VM or an On-Prem server to move things around on. 

We'll look at moving data around from On-Prem to Azure, moving files to Azure, and moving data between Azure databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 12

Time: 8:30 AM - 9:30 AM

Room: S270

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

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: January 12

Time: 1:30 PM - 2:30 PM

Room: S316

There's an old adage in software development: Garbage In, Garbage Out. This adage certainly applies to data science projects: if you simply throw raw data at models, you will end up with garbage results. In this session, we will build an understanding of just what it takes to implement a data science project whose results are not garbage. We will use the Microsoft Team Data Science Process as our model for project implementation, learning what each step of the process entails. To motivate this walkthrough, we will see what we can learn from a survey of data professionals' salaries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Management

Level: Beginner

Session Code:

Date: January 12

Time: 9:45 AM - 10:45 AM

Room: S305

Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get you started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes.

In this session we’ll look at
	Container Fundamentals with Docker
	Common Container Scenarios
	Automation with Kubernetes
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Beginner

Session Code:

Date: January 12

Time: 8:30 AM - 9:30 AM

Room: S339

You have read this far, great!  I already know this session is for you. How do I know? It is exceedingly rare that today’s “9-5” job provides anywhere near what is needed to develop the career you want to have.  For the purposes of this session it does not matter if you are a newly minted, “wet behind the ears” data professional or a grizzled veteran.  What does matter is that you know that you have a career oriented mindset and a desire to grow beyond what you are today.

This session is designed to help with just that. In addition to talking about a learning plan that fits your needs, we will discuss how to execute that plan, including lab environments, as well as resources to help you execute those plans.  If you have reached this point, you simply need to be in this session, see you there.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: January 12

Time: 11:00 AM - 12:00 PM

Room: S330

Have you found yourself confused about how SQL Server licensing works or wondered if you have made the right decisions for your organization? This session helps crack the code on this subject and provides you with information on the different options and and how to use these to your benefit. We will also look at things you can do to optimize your environment to make sure you are getting the most from your licenses.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 12

Time: 11:00 AM - 12:00 PM

Room: S213

SQL Window Functions provide a great way to aggregate and analyze data very efficiently. In this session we'll go over what functions are available and look at many examples of how to use them. When you leave you'll be familiar with the concept and will be able to recognize situations where they can be extremely useful.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: January 12

Time: 8:30 AM - 9:30 AM

Room: S305

Data collection and usage is all around us, it is what we do. But is what we do with the data ethical? Are we collecting and processing biased data?  We will take a look at ethical data collection and usage, what it means to your models and forecasts, and how being aware of possible biases can impact your bottom line. You might be training on extremely biased data and not know it, skewing your forecasts in the wrong direction.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Management

Level: Beginner

Session Code:

Date: January 12

Time: 1:30 PM - 2:30 PM

Room: S330

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics and Visualization

Level: Beginner

Session Code:

Date: January 12

Time: 1:30 PM - 2:30 PM

Room: S260

DevOps is one of those buzzwords that can scare people or make them roll their eyes. What does it even mean? Although the term is commonly discussed in the context of software development, the DevOps philosophy can significantly enhance BI and Analytics solutions. Come learn about ways in which you can apply DevOps principles to your BI projects through real enterprise examples and improve speed of deployments, communication among team members, and much more!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Management

Level: Beginner

Session Code:

Date: January 12

Time: 2:50 PM - 3:50 PM

Room: S301

Power BI is a powerful self-service analysis tool and is being adopted by organizations across the globe to quickly gain meaningful business insights. 

This session will cover the basics on creating compelling dashboards and guide you through the process of managing your company’s Power BI service, Power BI desktop, and mobile apps.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics and Visualization

Level: Beginner

Session Code:

Date: January 12

Time: 2:50 PM - 3:50 PM

Room: S305

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 12

Time: 2:50 PM - 3:50 PM

Room: S334

This isn’t a talk about best practices or how to configure your system. It’s designed to get into the mindset of a motivated, equipped adversary who wants to get in to a system or application, specifically SQL Server, and uses the full extent of his or her creativity to do so. We’ll look at both traditional and non-traditional weak points, how an attacker discovers them, exploits them, and then covers up his or her tracks. We’ll also discuss what we can do to compensate for a weakness we can’t fix, which revolves mostly around detection and response and how an attacker will respond to such countermeasures.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 12

Time: 1:30 PM - 2:30 PM

Room: S301

Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware.  It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking.  Let’s see how compression, statistics, and indexes bring new life into your existing hardware.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 12

Time: 11:00 AM - 12:00 PM

Room: S316

SQL Server indexes come in multiple types: clustered, non-clustered, full text and column store. In this session, you’ll get an understanding of what these types are and when each is an appropriate solution. We will explain and demonstrate each type, and you’ll leave this class with a repeatable indexing methodology you can use to improve your database performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: January 12

Time: 1:30 PM - 2:30 PM

Room: S332

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