Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 50
Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it may take considerable time to gather the information you will need.
In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 14

Time: 8:45 AM - 9:45 AM

Room: 1224 (30)

With the proliferation of SQL, NoSQL and Big Data databases, organizations can now target specific fit-for-purpose database platforms that align with their particular application requirements regarding scalability, elasticity, functionality and manageability. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 14

Time: 1:45 PM - 2:45 PM

Room: 1226 (30)

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

Azure ML:

The main functionality of Azure ML and how to set it up.

Different components in Azure environments Such as Data import and Export into Azure studio in “Dataset” component using “Import Data”, “Export Data”, “Enter Data Manually”.

Using “Reader” component to fetch data from cloud services

Data format conversion such as “Convert to CSV”, “Convert to Dataset”

Manipulation: Add columns and rows, Apply SQL Transformation, Clean Missing Data, Join Data, Remove Duplicate Row, Select Column in Dataset.

Split and Sample: Partition and Sample and Split Data.

Scale and reduce: Group Data in Bins and Normalize Data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Half Day Session (240 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 13

Time: 9:00 AM - 1:00 PM

Room: 3100 (52)

This full-day session will focus on principles for designing and implementing a data lake. There will be a mix of concepts, lessons learned, and technical implementation details. During the session we will build a data lake from the ground up, populate it, organize it, secure it, integrate it with a data warehouse via logical constructs, and query the data. You will leave this session with an understanding of the benefits and challenges of a multi-platform analytics/DW/BI environment, as well as recommendations for how to get started.

Target audience:

Technologists who are considering using a data lake. No data lake experience is required. However, familiarity with SQL Server and data warehousing is suggested, as the scenarios discussed will primarily focus on extending functionality and improving agility for an existing data warehouse.

You will learn in this session:

    Scenarios and use cases for expanding an analytics/DW/BI environment into a multi-platform environment
Speaker:

Accompanying Materials:

No material found.

Session Type:
Half Day Session (240 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 13

Time: 9:00 AM - 1:00 PM

Room: 2215 (40)

The Azure Resource Model (ARM) enables Azure infrastructure automation for both IaaS and PaaS deployments.  Using Visual Studio as a management tool enables repeatable, automated, source controlled deployments for test and development environments, enabling true DevOps practices for all aspects of pre-production systems.  In this session, I will demonstrate, explain, and deploy a IaaS/PaaS hybrid environment (SQL and BI stack elements) using ARM templates, Visual Studio, source control integration, and PowerShell scripts.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: October 14

Time: 1:45 PM - 2:45 PM

Room: 1225 (30)

There's a ton of buzz around Data Science and Machine Learning. What is it? What can we do with it? Do I have to learn a new language or tool? We will walk through an example of how to use Azure Machine Learning to predict income based on demographic data. You'll see why Azure Machine Learning is the future of data science.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 14

Time: 1:45 PM - 2:45 PM

Room: 2218 (41)

Azure ML is the Microsoft cloud based Machine Learning tool. It provides variety of algorithms for doing descriptive, Predictive and Prescriptive analysis. Moreover, it supports the variety of Data science the techniques for data wrangling, feature selection, cross validation and so forth for enhancing the accuracy. In this session, I will first talk about how to measure the accuracy of the predictive or descriptive analysis in azure Ml. then I will show how to do feature selection in Azure ML to find proper attributes. Finally, I will demo how to do data sampling and Cross validation using existing components in Azure ML which will help us to enhance the machine learning accuracy.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 14

Time: 3:00 PM - 4:00 PM

Room: 2150 (95)

Automating extract packages is trivial, you simply use INFORMATION_SCHEMA.  The problem is not all your data sources have easy to read metadata like SQL Server.  How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.  

With that schema, automatically generating your extract package is a matter of seconds!  Join me while I share my interrogator project with you and start saving hours at work today!
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 14

Time: 3:00 PM - 4:30 PM

Room: 2212 (30)

Sponsor Session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Sponsor Session

Level: Beginner

Session Code:

Date: October 14

Time: 12:30 PM - 1:30 PM

Room: 1225 (30)

Getting started with basics of Azure environment, such as Accounts, VNET, Storage and creating VMS.  Once we fly by reviewing several building blocks, we then build Active Directory VM, SQL Server VM and App Server Tier VM using Azure portal and PowerShell.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 14

Time: 8:45 AM - 9:45 AM

Room: 1226 (30)

Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption?
The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues.
Highlight of topics
1.	Why corruption occurs?
2.	Detecting corruption – how SQL Servers detects corruption at the page level.
3.	Different types of corruption- e.g. False alarms, memory corruption etc.
4.	Limitation of DBCC & how to speed the DBCC process.
5.	Undocumented DBCC commands.
6.	Monitoring I/O errors.
7.	Verifying backup for corruption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 14

Time: 10:00 AM - 11:00 AM

Room: 1233 (41)

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 14

Time: 8:45 AM - 9:45 AM

Room: 1225 (30)

Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what things Power Query can do. M is the language behind the scene of Power Query, you will learn how M can be more beneficial than the Power Query Graphical interface. You will see demos of transformations that you can do with M Code. You will learn about Functions, Parameters, Generators and many other amazing features of this tool. This session is full of live demos. Prepare to be amazed by what Power Query can do with heaps of demos in this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: October 14

Time: 3:00 PM - 4:00 PM

Room: 1225 (30)

Sponsor Session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Sponsor Session

Level: Beginner

Session Code:

Date: October 14

Time: 12:30 PM - 1:30 PM

Room: 1226 (30)

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression. 

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 14

Time: 3:00 PM - 4:00 PM

Room: 2214 (39)

Join us for a discussion of strategies and architecture options for implementing a modern data warehousing environment.  We will explore advantages of augmenting an existing data warehouse investment with a data lake, and ideas for organizing the data lake for optimal data retrieval. We will also look at situations when federated queries are appropriate for employing data virtualization, and how federated queries work with SQL Server, Azure SQL DB, Azure SQL DW, Azure Data Lake, and/or Azure Blob Storage.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 14

Time: 10:00 AM - 11:00 AM

Room: 2150 (95)

DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful.  The DBA was often the most resilient and robust member of the operations team and most resistant to change.  This mentality was essential to the protection of company’s critical production data.

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”.  We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.  
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as:
•	Develop, Rinse, Repeat
•	Test Until Your Five Year Old Can Do It
•	Human Intervention Creates Human Error- Automate EVERYTHING.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: October 14

Time: 8:45 AM - 9:45 AM

Room: 1233 (41)

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

Time: 8:45 AM - 9:45 AM

Room: 1223 (30)

DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services Tabular mode. If you know Excel, you already know the basics of DAX (without even knowing it).  PowerBI also uses DAX for all the formula expressions.  We'll cover the basics of DAX, and go over some time intelligence functions.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 14

Time: 8:45 AM - 9:45 AM

Room: 2212 (30)

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. 

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 14

Time: 8:45 AM - 9:45 AM

Room: 2150 (95)

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