Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type




Sessions Found: 39
Where do the estimated rowcount values come from? Look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll also discuss changes in the cardinality estimator in recent versions and look at some new metadata that gives us more statistics information.

Goals:
•	Explore the output of DBCC SHOW_STATISTICS
•	Describe when the density information is useful
•	Look at some problem scenarios for which the statistics can’t give good estimates
•	Understand why cardinality estimation involves more than just the statistics
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 10

Time: 1:30 PM - 3:00 PM

Room: Nexus

Constraining everything in development and testing is database size.  Storage is a bottleneck, and while faster SSD/Flash is available, it is still too expensive due to the size of many databases, especially in DEV and TEST.  More to the point, it takes a lot of time to push terabytes around, and time itself is expensive.  The old joke about "good, fast, and cheap -- pick any two" is so true with data.

Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur,  quality suffers, and things move slowly.

Come learn why data virtualization is the solution to a problem everyone knows.

Good, fast, and cheap -- have all three with data virtualization.  Be able to clone data quickly, and remove the biggest constraint to development and testing.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 10

Time: 8:30 AM - 9:30 AM

Room: Utopia

Troubleshooting spinlock contention, strange wait types, AVs and asserts is no longer a black box. With the availability of SQLCallStackResolver (http://aka.ms/sqlstack) you can start uncovering the true reasons for a particular behavior within SQL Server, without having to open WinDbg! This tool can potentially save you a call to Microsoft Support (or at least go much better prepared to them!) In this session you will be presented live demos of how SQLCallStackResolver has helped in real-life cases, both for SQL Server on Windows and SQL Server on Linux. Latch contention, spinlock contention, AVs are no longer a mystery with this tool. Come and see how you can tackle the most difficult and advanced SQL Server troubleshooting scenarios yourself!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: February 10

Time: 3:15 PM - 4:15 PM

Room: Trident

Are you interested in learning about Azure SQL Databases but are not sure where you should start learning?  Platform as a service (PaaS) databases are here and adoption is growing.  In this session, you will learn how to take your current DBA skills and utilize them with Azure Databases.  We will focus on getting started, migrating databases, disaster recovery, performance, and security.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 10

Time: 9:45 AM - 10:45 AM

Room: Trident

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 10

Time: 1:30 PM - 2:30 PM

Room: Stinger

If you want optimum performance in SQL Server, you have to use indexes. But what if you already implemented indexes and your solution is still slow or it doesn’t scale like you want? Or, if you're on Azure, it is just requiring too much resources, which in turns means just more money to be spent on it? You may have to rethink the way you write your queries. How you write your queries is directly related to how you approach and solve your business problems, and more often than not thinking outside the box is the way to unlock incredible performances. But what this exactly means in a database? And how a developer can do that? In this session, you’ll see how using some lateral thinking and a set-based approach will open up a whole world of possibilities. Thanks to this demo intensive session, you'll never be the same after switching on this new mindset!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 10

Time: 1:30 PM - 3:00 PM

Room: Stinger

In this talk Greg will explore the new Data Masking feature, that came out with SQL Server 2016.  Greg will be discussing: 
•	Why you should mask your data
•	The 4 different masking functions
•	Security around Dynamic Data Masking
•	Benefits, drawbacks and programming considerations around Dynamic Data Masking
•	How to crack Dynamic Data Masking
Greg’s talk will also contain a number Dynamic Data Masking demos. 
After attending this session, Attendee will gain a solid understanding of Dynamic Data Masking and the considerations they should take into account when rolling out this new feature.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 10

Time: 8:30 AM - 9:30 AM

Room: Trident

This session is designed to teach DBAs and developers the best strategy to transfer large data. 

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 10

Time: 1:30 PM - 3:00 PM

Room: Normandy

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:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 10

Time: 9:45 AM - 10:45 AM

Room: Trident

PowerBI is used in many organizations, but how to govern it? this question is still a work in progress. All those features and capabilities and the limitless world of self-service BI, how are the users affected by that? How is IT? Some best practices, lessons learned and fun facts about the platform.
I will be talking about why do we need governance in Power BI? Groups and PowerB, permission management, limitations and how it correlates with other O365 applications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 10

Time: 3:15 PM - 4:15 PM

Room: Normandy

1. Temp Tables & Table Variables by Vern Rabe. 
    This talk will explain how to select between temp tables and table variables.

2. Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints by Rick Lowe
    Ever hear NOLOCK is bad? Ever use one (or a hundred) anyway? Come see some of the bad things that can happen when NOLOCK hints are abused.

3. Change Data Capture in SQL Server, SSIS, Master Data Services by Swagatika Sarangi.
    In This session, you will see a demonstration of implementing Change Data Capture in SQL Server 2017 and Master Data Services web UI 2017. 
   
4. A look at what is required to get an Alexa application up and running on Azure Functions where voice is the UI By Andrew Cook

5. 15 speaking tips in 15 minutes by Arne Rowland.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: February 10

Time: 1:30 PM - 3:00 PM

Room: Origami

Join me in the quest to become a PowerShell DBA! Learn how to improve your career by quickly accessing logistical information within a database rich environment. Discover how PowerShell tools can enable you to gather and store information in a functioning repository, placing views and functions from a day, a week, or even a year ago, right at your fingertips!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 10

Time: 9:45 AM - 10:45 AM

Room: Nexus

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: February 10

Time: 9:45 AM - 10:45 AM

Room: Normandy

SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.

The participant will learn:
1. The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
2. How to install, maintain and backup SQL Server on Ubuntu Linux systems 
3. Several useful Linux commands to monitor/manage SQL Server
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 10

Time: 11:00 AM - 12:00 PM

Room: Normandy

Log Parser is one of Microsoft’s best and most under recognized tools.  Originally designed to read IIS and system logs, its simple complexity makes it a true “swiss army knife” of a tool.  With its ability to read multiple log and text formats and then spit them out in a myriad of formats, it can be used to quickly analyze large amounts of data and present them in a readable format.
This presentation will start with some basic uses of Log Parser, explain some of the core features, demonstrate some of the challenges, and finally focus on using Log Parser to decrypt SSRS logs.  These decrypted logs can then be used as a monitoring system.  
As with most things, there are multiple ways to accomplish a task.  Log Parser will be a welcome addition to your tool belt!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: February 10

Time: 3:15 PM - 4:15 PM

Room: Nexus

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system-maintained “history” tables to track all changes to the table data.

In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 10

Time: 8:30 AM - 9:30 AM

Room: Stinger

Machine Learning Services with Python and R support has transformed SQL Server into a powerful end to end AI platform. Come learn about the advantages of doing in-database machine learning using R and Python languages and get the latest in this technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 10

Time: 3:15 PM - 4:15 PM

Room: Odyssey

When you have to do something more than once, you should script it!  That’s true for SQL Server maintenance tasks.  It’s also important for Business Intelligence projects as well.  Microsoft has provided web services to manage your reporting service and to download reports in various forms.  In this session I demonstrate how to leverage these web services from PowerShell to handle common SSRS administrative tasks:  uploading and copying a report; checking the parameter values, setting the parameter defaults, scheduling a cache refresh.  I addition, I demonstrate how to download a report top PDF using PowerShell.  You will not only come away with a set of PowerShell scripts to manage your SSRS server, you will learn how to work around some of the less intuitive features of PowerShell to use and extend these scripts.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 10

Time: 1:30 PM - 2:30 PM

Room: Utopia

Microsoft Azure Analysis Services & SQL Server Analysis Services help you build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. Join this session for a look forward to what's coming in soon! The demos will cover new features to be announced for enterprise-grade BI models in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 10

Time: 8:30 AM - 9:30 AM

Room: Normandy

This session is for the love of technology and learning.  Its based off research performed on objects, design and code built as similar as possible to see how Oracle and SQL Server compare in performance, usage and storage of indices.  Environments were built on-prem and in the cloud to view differences in different cloud support of database engines and based off trusted measurements in each platform so as to dig into how the use case was built, the similarities and the differences in each. 

Based off this use case, enhanced builds of more advanced index features and discussions of the advantages, reasons for the introduction and how it's effected the direction of each product, the DBAs who are responsible for them and resources. 

Takeaways are:
1.	Receive a strong education on platform differences between Oracle and SQL Server.
2.	Discover hidden insight on index storage and costs.
3.	Learn about great tips on maintaining index health
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 10

Time: 3:15 PM - 4:15 PM

Room: Stinger

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