Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 32
You're a developer or DBA who wants to get your database code into source control, but you're not sure how to work with it. Should you use release branches? Feature branches? How do you handle emergency hotfixes? There are quite a few discussions and patterns available online for branching application code, but special considerations apply when it comes to database code. In this session, you'll learn to design the simplest branching strategy that meets the needs of your organization, based on the size of your team and your requirements for release practices. We will discuss multiple popular branching models along with “fit notes” describing the strengths and weaknesses of each model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 3:15 PM - 4:15 PM

Room: 233

If you heard of some of the data analytics products on AWS but unsure where to start, this session may help. Amazon Web Services offers analytics tools to enable data ingestion, storage, analysis, and visualization. From this session, take home an introduction to services such as AWS Data Migration Services, S3, Amazon Athena and take an introductory look into Amazon QuickSight, visualization on AWS. Learn how to leverage Amazon’s cloud infrastructure, platform and software as a service to build an analytics and insights solution on the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 310

DBAs agree, Access databases should be converted to SQL Server, but that sounds a lot easier than it turns out to be in most cases. In this session we will discuss when it is appropriate to migrate to SQL Server, migration strategies, how to manage the transition, whether to move to on premises or Azure and finally how to accomplish the task.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 12

Time: 10:15 AM - 11:15 AM

Room: 310

Virtually all of today’s data solutions are hybrid solutions – partially in the cloud, partially on premises – as organizations attempt to fulfill an ‘all in the cloud’ mandate.  The reality is that cloud platforms like Azure do many things very well, but not all things, and functional gaps remain which complicate and sometimes prevent a full migration away from on premises environments.

Azure Analysis Services (AAS) is a good example of this reality – it works very well for many applications but is limited to Tabular Models and cost can explode if those models are not created thoughtfully.  And, what is the path to Azure for my multidimensional cubes? Do I care about Azure Analysis Services if I use Power BI?  As always the answer to these questions is a clear and absolute ‘it depends’.

In this session we’ll explore Azure Analysis Services functionality, fit in various solutions, and gaps and techniques that are important to consider when implementing AAS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 12

Time: 12:45 PM - 1:45 PM

Room: 233

Interested in working with large and varied data sets but don't know where to start? Wondering if your team knows enough to apply advanced analytic techniques?  Not sure if you can use your SQL skills in Big Data world?
Come and learn about Azure Databricks. This service combines power of Apache Spark large scale workloads with fully managed Azure cloud services to build data engineering pipelines, interactively run analytical tasks and implement machine learning algorithms. But what really sets it apart from other cloud analytical services, is that it is a truly collaborative environment that allows you to take advantage of diverse skills in your organization and let everyone work with data.
By the end of this session you will know how to easily connect to various data sources in data lake, quickly spin up Spark clusters, use notebooks to share your code and mix languages like SQL, R, Python, and build visualizations to drive business insights.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 10:15 AM - 11:45 AM

Room: 311

You have probably worked as a direct hire for a company.  You get medical benefits, vacation, and possibly a good 401k.  On occasion you might have accepted a contract.  The pay might be nicer, but you are concerned because you have less job security, no vacation, and no benefits.  Yet, there are some who prefer contracts.  We will cover how to negotiate a wage, appear professional, a look at finances, contractual gottchas, taxes and paperwork.  Since most are experienced at being a direct hire with a company, this presentation will show the benefits of consulting/contracting, so that you can decide what is right for you and your career path.  Presenter has been contracting for 18 of the last 20 years and will share many of his experiences - the successes and the falls along the way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 12

Time: 3:15 PM - 4:15 PM

Room: 311

Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 234

Are you thinking about runing Azure in SQL but don't understand all your options.  Do you find the terms DTU and Elastic Pools confusing.  Want to understand the difference between Azure SQL, Azure SQL Data Warehouse and Azure SQL Managed Instances.  If you answered yes to any of these questions, this session is for you.
In this session I will cover all of the SQL options you have available, the pros and cons of each and how to create and use each of these options.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: October 12

Time: 12:45 PM - 1:45 PM

Room: 380

Dynamic Management views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates, and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases. 

This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 10:15 AM - 11:45 AM

Room: 233

A DBA's suite of scripts is worth its weight in gold.  As Azure moves the SQL DBA to a more Linux focused environment, the opportunity to learn Linux scripting and to add these valuable skills to your pre-existing Powershell skills is a great goal.  This session will teach you how to build out proper shell scripts, tips and tricks, along with how to learn faster.

This session is the second session in the Linux for SQL Server Professionals Learning Pathway. For more information please visit our Learning Pathways page.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 12

Time: 10:15 AM - 11:15 AM

Room: 275

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: October 12

Time: 2:00 PM - 3:00 PM

Room: 235

This is the advanced part 2 of Innovative Data Modeling.  Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. We will explore how you can use continuous integration and delivery to further maximize value.   Let's look at platform specific techniques and also explore design options for Azure SQL Data Warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 12

Time: 3:15 PM - 4:15 PM

Room: 235

Newly available in Azure, Databricks is a managed service that makes it easy to run computations across a cluster of computers. This session will focus on what you need to know about Databricks to get started with coding out your own ETL or data science solution. The session will showcase a machine learning algorithm coded in Python that's been parallelized using the Databricks platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 12

Time: 12:45 PM - 1:45 PM

Room: 310

Have you been asked to assist in a migration to the cloud? Where do you start? What are the potential pitfalls? How do you know which path to take to lead you to success? In this session you'll learn about the challenges of migrating from on-prem to the cloud and how to overcome them to ensure success for you and your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 3:15 PM - 4:15 PM

Room: 275

Azure Data Factory (ADF) is a cloud-based data integration service that automates data movement and data transformation using both cloud and on-premises data sources and destinations. This introductory session will cover basic components of an ADF solution including integration runtimes, linked services, datasets, pipelines, activities, and triggers. We'll also discuss the development environment and integration with source control as well as monitoring. This session will include demos to show you how to build, execute, and monitor a pipeline. And since Data Factory is frequently updated with new features, we'll look at some of the latest releases. If you have been waiting to dip your toe in the ADF waters, this is your chance to learn the basics and ask questions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 12

Time: 12:45 PM - 1:45 PM

Room: 311

Modern-day computing power makes it possible to create sophisticated predictive models that classify data, perform anomaly detection, and predict behaviors and tendencies. 
Using data engineering principles and the latest tools released by Microsoft in Azure Machine Learning service to create a data science framework, you’ll see how to develop predictive models through the entire life cycle and incorporate them into your applications in a way that impacts the decision-making ability of everyone in your organization. 

Through a case study, you’ll learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target and how to use data appropriately and adapt it to the model for maximum results. Best practices will be presented for developing, monitoring, and maintaining predictive models. Integrating predictive models into your architecture will allow you to take a step toward making predictive analytics pervasive in your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: October 12

Time: 2:00 PM - 3:00 PM

Room: 311

Power BI Premium is the top level of Power BI that your company can pay to get dedicated capacity for your Power BI reports and models. But at a starting price of $5000/month is it something your company needs and is it worth that price? 

In this session, we will go over all of the current features offered with Power BI Premium and the features that we know are coming in the future, so that you can help make that decision for your company. With multiple demos in this session, you can see these features for yourself to help determine the worth. 
Come to this session if your company has been thinking about Power BI Premium, but you have been unable to determine if it is right for your company. At the end of this session, you will be armed with all of the knowledge you will need to make the right decision.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 12

Time: 9:00 AM - 10:00 AM

Room: 235

Microsoft’s Power BI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement Power BI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point Power BI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, Power BI, and how to make these work for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 12

Time: 12:45 PM - 1:45 PM

Room: 234

Every wonder if you could predict the outcome of the Superbowl? Or know the score of any game? The NFL is perfect for predictive analytics: it has a fixed time frame, a set playing field, and rigorous rules.  These are characteristics we can only envy in the business world. With the integration of ML Services in SQL Server 2017, we have the strength of statistical languages like R and Python right within the database engine. In this session, John will demonstrate the steps for successfully preparing the data, then run a regression model to predict the scores for the current week’s scheduled NFL game.  Want to know if your team is likely to win against the spread?  Wanna bet?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 12

Time: 3:15 PM - 4:15 PM

Room: 310

Data masking is likely to become a new legal requirement.  Don't let this catch your organization unaware and flat-footed!

For decades, IT has been negligent, using production data during software development and testing, exposing sensitive data to those not authorized to access it.  That decades-old practice must end.

Data masking is the solution for providing non-production environments (i.e. DEV, TEST, etc) with realistic but artificial data for development and testing, while reducing the surface area of risk for breaching data.

The alternative, generating test data, incurs classic problems of engineering bias as well as blindness to true-to-life testing scenarios which arise in the "wild".

Masking real production data retains realistic data conditions and distributions while merely obfuscating real data.

Masking is important, and sophisticated software packages are available today, but the field is new enough that there is lots of room for improvement in all of them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 12

Time: 2:00 PM - 3:00 PM

Room: 310

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