Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 32
Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood. 

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: October 07

Time: 2:30 PM - 3:30 PM

Room: R2

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 07

Time: 9:00 AM - 10:00 AM

Room: R3

SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.  

In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics.    Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 10:30 AM - 11:30 AM

Room: R8

This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization.  It will also touch a little on why you might choose Power BI over Power Pivot and why you might not.  It will also look at how to create drill down detail screens to expose the details behind your visualizations.  Finally, we will touch on how to publish your Power BI results for others in your organization to share.  A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 07

Time: 10:30 AM - 11:30 AM

Room: R2

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 07

Time: 2:30 PM - 3:30 PM

Room: R3

Today's Business Intelligence Tools allow to secure the data for a variety of business scenarios. Learn How Row Level Security and other security data technologies can be implemented in Power BI, SSAS, and SQL Server and can change the design of corporate Apps using Active Directory.
In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design and architecture of data security using different tools: Power BI, SSAS, SQL Server, Web Apps and explain when to use them, their differences and their limitations. Throughout the session, we explore and demo various ways to secure the data and witness how to implement the security in each.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 1:15 PM - 2:45 PM

Room: R3

How to set up a Requirements Analysis to develop successful databases
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 07

Time: 1:15 PM - 2:15 PM

Room: R6

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 9:00 AM - 10:00 AM

Room: R1

If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are some limitations. Cozyroc’s Excel Source Plus and Excel Destination Plus components remove those limitations. In addition, Cozyroc’s Excel Task enables editing of Excel files from SSIS packages. In this session, I’ll talk about the capabilities of the Cozyroc components and demonstrate how easy it is use use these components with SSIS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 07

Time: 12:00 PM - 1:00 PM

Room: R5

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 07

Time: 1:15 PM - 2:15 PM

Room: R7

CosmosDB was announced at Build 2017 as an extension to Microsoft's DocumentDB offering and is positioned to be a key component of the Microsoft Data Platform. In this session, we will explore CosmosDB's graph API that is built using Apache's TinkerPop and Gremlin projects. Graph databases allow you to build a powerful data model that explores connections and paths between data. At the end of this session, attendees will have a solid understanding of what a graph database is and how you can use Gremlin and the .NET API to interact with a graph database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 07

Time: 10:30 AM - 11:30 AM

Room: R3

Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 2:30 PM - 3:30 PM

Room: R8

SQL Server 2016 lifted several limitations from its initial implementation.
This session will cover how to implement InMemory objects, new capabilities (Defaults, Checks, FK validation, Triggers); performance gains; and an introduction to monitoring these objects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: October 07

Time: 2:30 PM - 4:00 PM

Room: R7

This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 07

Time: 10:30 AM - 11:30 AM

Room: R6

Testing allows database code to be consistently verified during the development process, but it can be challenging to get testing setup for database development. This session will give an overview on the purpose of database testing, the installation of the tSQLt framework, and the design of unit and integration tests. I will use general concepts of test driven design to create and run tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement testing in a development environment and create and run your own tests.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 07

Time: 1:15 PM - 2:15 PM

Room: R4

Logging messages in your database is a common request, and there are a million ways to do it. This presentation will cover basic methods and progress through more advanced ones.  We'll also show how autonomous transactions (available in some database products, but not natively supported in SQL Server) can be accommodated with some interesting techniques.

We'll examine user-defined events, linked servers and the new SESSION_CONTEXT() feature in SQL Server 2016, to provide different levels of logging and transaction management, and cover their best use cases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 07

Time: 9:00 AM - 10:00 AM

Room: R8

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 07

Time: 1:15 PM - 2:15 PM

Room: R2

So you have your availability groups configured and everything reports green.  How do you measure SLA compliance? Do you know when replication is delayed? Were you notified when it failed over last night?
This session will answer all these questions and more, and will show you what you should be looking at to ensure no surprises.
We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts to show what to monitor in your AG and how to setup alerting so you know when to take action.
Demo:  Show AG dashboard and cause AG failures and excessive delay and show how alerts are sent
Goals:  
Teach what to monitor in AGs for proper health
Alert on events when they occur which the DBA should know about
Demonstrate alerts and notifications when failures or delays occur in your environment
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 9:00 AM - 10:00 AM

Room: R6

vSphere 6.5 has made a lot of changes to enhance the performance of Monster VM’s. Databases by their very nature are the classic Monster VM’s. If Monster VM’s are not virtualized properly they will never perform well and can negatively performance of other VM’s on the hosts. In this presentation, we will teach you how to properly virtualize Monster VM/Databases with vSphere 6.5. We will discuss why you virtualize, installation issues, how to Architect for performance discussing vSphere 6.5 specifics, the storage layer, the processor, Memory considerations, the network layer.  Topics include NUMA, Memory reservations, how to avoid common mistakes. Lesson learned here help you optimize any workload you are virtualizing. With Special emphasis on Monster VM’s on Vsphere 6.5
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 07

Time: 1:15 PM - 2:15 PM

Room: R1

In this session of Getting Started with Azure Data Lake Analytics, we will learn about fundamental concepts and considerations for designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics using Microsoft's new Big Data language, U-SQL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 07

Time: 2:30 PM - 3:30 PM

Room: R4

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