Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 48
You have multiple SQL Servers and you need to quickly identify where to focus your efforts to ensure you pass security audits. This session will show and give you a handful of scripts that quickly collect information to then diagnose the basic compliance for your SQL Servers.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration (DBA) & Deployment

Level: Beginner

Session Code:

Date: June 03

Time: 8:30 AM - 9:30 AM

Room: 119

Agility and Business Intelligence are two good things that often struggle to be good together. A primary cause of this struggle is the inability of traditional Data Warehouse models to respond to change in a (business) timely manner. Data Vault is an evolution of Enterprise Data Warehouse modeling that removes the barriers to Data Warehouse agility. A Data Vault warehouse eliminates re-engineering both of the data schema and ETL as the model evolves in response to changing business needs and definitions.
In this session we’ll compare modeling techniques in real world scenarios to understand how Data Vault can make your EDW more capable and agile.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (75 minutes) (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 03

Time: 11:30 AM - 12:45 PM

Room: 121

We will take a look at an introduction and overview of Azure Analysis Services - Microsoft 's cloud-based analytical engine and Platform as a Service (PaaS) offering. We will discuss Azure Analysis Services features and capabilities, use cases, provisioning and deployment, managing and monitoring, tools, and report creation. Although Azure Analysis Service is in Public Preview at the time of this session submission, we will incorporate the latest publicly  available information.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 2:20 PM - 3:20 PM

Room: 128

In this session, we discuss the newly announced Azure Cosmos DB - Microsoft's globally distributed, multi-model database.  Azure Cosmos DB was announced on May 10th, 2017, during the Microsoft BUILD conference.  Azure Cosmos DB is a superset of the Azure DocumentDB – offering a write optimized, resource governed, schema-agnostic database engine that natively supports multiple data models: key-value, documents, graphs, and columnar. It also supports many APIs for accessing data including MongoDB, DocumentDB SQL, Gremlin (preview), and Azure Tables (preview), in an extensible manner.  Let’s take a look at Azure Cosmos DB and how it impacts the game.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 8:30 AM - 9:30 AM

Room: 121

If you are new kid in the world of Big Data? Let's look at some of the topics of Big Data.
We will learn about foundations of big data and social physics, What is the importance of data quality and data privacy. We will have a quick look at personal sensors and human behavior
This module will explore the various sources of data, how to leverage personal sensors to predict behavior, and introduce you to the key features of 'Funf'

We will explore the basics of data dynamics and data interrogation, and the importance of interdisciplinary research and testing on yourself, to assist in analyzing a data set.

What are the fundamentals and structure of peer networks? 
We will also talk about HDInsight and take a look at Microsoft's items in play.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: June 03

Time: 3:30 PM - 4:30 PM

Room: 119

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 03

Time: 10:10 AM - 11:10 AM

Room: 124

Often the first choice for statistics, data analysis, and machine learning, R has a variety of use cases that make it a great fit. And due to the open-source nature of R, there are many packages that make R a great tool for developing dashboards.

In this session, we will discover and understand how to build dashboards in R using a few different patterns. We will also understand how to deliver this content to the consumer in multiple forms, including on-demand (web and bot), interactive (web), and batch (email).

You will leave this session with an understanding of how to start developing dashboards in R and how to deliver them to your user community. To get the most from this session, some general knowledge of R and programming languages is required.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 03

Time: 10:10 AM - 11:10 AM

Room: 122

Everyone’s talking about DevOps.  In this session, we’ll discuss what DevOps is and learn about its history.  We’ll also talk about what specific challenges DBAs may face when adopting DevOps.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration (DBA) & Deployment

Level: Beginner

Session Code:

Date: June 03

Time: 10:00 AM - 11:00 AM

Room: 121

I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001.  Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery.  In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself.  We will discuss the documents we had and how they were used in our recovery.  We will also discuss what documents we didn't have, and how they could have made the process better.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 03

Time: 2:15 PM - 3:15 PM

Room: 124

If you do not have enough disk space and do not want buy more space, one way to get more space is compress the tables and also do some house keeping.

I am going use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles.
And in the final I will defrag the indexes and update the statistics, since shrink datafile is not fragmentation aware task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration (DBA) & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 10:00 AM - 11:00 AM

Room: 119

You are a data analyst by trade. Your SQL skills are likely used to write research queries, do quality control for the query results, and churning out reports. However, you're now concerned with loading and manipulating data in the database. You're now asked to write statements that don't start with SELECT. In short, you're becoming a junior SQL developer.

This session will provide you with some high-level essential resources, from additional T-SQL query operators to SQL Server Data Tools and what relational database concepts, to help you navigate this uncharted territory...coming from a speaker who has been in the same position. You will come out of the session eager to use these resources to moonlight as or transition to a developer in the SQL Server space, ideally blending this developing skill set with your analyst skill set to create a well-rounded data professional!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 03

Time: 3:40 PM - 4:40 PM

Room: 128

What are all the high availability (HA) and disaster recovery (DR) options for SQL Server in a Azure VM (IaaS)?  Which of these options can be used in a hybrid combination (Azure VM and on-prem)?  I will discuss how data is stored in Azure, and then go over the HA/DR options such as AlwaysOn AG, Always On FCI, Basic Availability Groups, Database Mirroring, Log Shipping, Backup to Azure, SQL Server data files in Azure, Azure Site Recovery, Azure VM Availability Set, and Azure SQL Data Sync.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration (DBA) & Deployment

Level: Beginner

Session Code:

Date: June 03

Time: 11:40 AM - 12:40 PM

Room: 123

Navigating the brave new world of In-Memory OLTP can be daunting. We will cut through the confusion, and as a result, you will be able to make informed decisions about:

Available index types (Range, Hash, and Columnstore), and their usage
Index maintenance and troubleshooting
Statistics
How indexes affect recovery
Indexes and Temporal tables
Indexing capacities for non-Enterprise editions in SQL 2016/SP1
Parallelism for indexes
Support for ascending/descending indexes
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 03

Time: 2:20 PM - 3:20 PM

Room: 127

R is growing to be the standard tool for Data Analytics. Microsoft has deeply embraced R and has included it as a component in SQL Server, Azure and Cortana. R is the standard language for Data Science. This session will provide an overview of R, its uses, how it works with SQL Server and how you can continue your learning. Topics will include:
?- Overview of Infrastructure – How does R work within an environment
?- Data Wrangling - How do you get at data and structure it for your use.
?- Statistical Analysis and Packages - How can you use the analytic features that are important to you.?   
      - Introduction to Machine Learning - Machine Learning is currently a hot button topic. 
? - Visualization and Reporting in R - A key feature is the robust level of visualizations. We will do an overview
Speaker:

Session Type:
Extended Session (75 minutes) (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 03

Time: 11:40 AM - 12:55 PM

Room: 122

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 03

Time: 2:15 PM - 3:15 PM

Room: 123

Have you been thinking about presenting at a user group?  Are you being asked to present at your work?  Is learning to present one of the keys to advancing your career?  Or do you just think it would be fun to present but you are too nervous to try it?  Well take the first step to becoming a presenter by attending this session and I will guide you through the process of learning to present and becoming good at it.  It's easier than you think!  I am an introvert and was deathly afraid to speak in public.  Now I love to present and it's actually my main function in my job at Microsoft.  I'll share with you journey that lead me to speak at major conferences and the skills I learned along the way to become a good presenter and to get rid of the fear.  You can do it!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 03

Time: 2:15 PM - 3:15 PM

Room: 125

We'll take a closer look at employing SQL Server MDS to manage master data.
The following topics will be covered (tentative list):
- Master Data Management Process
- MDS architecture
- Development 
- Models, Entities & Business Rules
- Loading data (automated & manual)
- Security & Management
- Integration
- Deployments & Change management
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 03

Time: 3:35 PM - 4:35 PM

Room: 123

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 03

Time: 10:00 AM - 11:00 AM

Room: 120

In-Memory OLTP table was first introduced in SQL Server 2014. However, a massive number of limitations makes In-Memory OLTP table usage practically impossible. In SQL Server 2016 many of those limitations were eliminated which made it possible to start implementing In-Memory OLTP table in the database. The session 'Migrating a Disk-based Table to a Memory-optimized Table' will cover the process of migrating the disk tables to In-Memory OLTP table. This process is not straight forward and requires analysis before making a final decision for migration. However, the benefits of In-Memory OLTP table is worth the effort. If you are looking to improve transaction speed and reduce blocking for your server, the In-Memory OLTP tables is an excellent way to accomplish this task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: June 03

Time: 2:10 PM - 3:10 PM

Room: 119

Extended events is designed to be a replacement to Profiler and delivers expanded monitoring and troubleshooting and offers less performance overhead than profiler. Learn how to log long running/high cpu/high IO queries, determining queries which timeout, and to debug sql server processes.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration (DBA) & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 11:40 AM - 12:40 PM

Room: 125

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