Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type




Sessions Found: 34
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:

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

Accompanying Materials:

No material found.

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:

Accompanying Materials:

No material found.

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 10

Time: 11:00 AM - 12:00 PM

Room: Origami

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:

Accompanying Materials:

No material found.

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:

Accompanying Materials:

No material found.

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

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:

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: 3:15 PM - 4:15 PM

Room: Normandy

1. Temp Tables & Table Variables by Vern Rabe. 
    You may have heard that temp tables are better than table variables for larger data sets. Or that table variables don’t have statistics. Or that table variables are outside of transaction scope. Or that temp tables and table variables log to the transaction log like permanent tables do. We’ll look at these in a little more detail, and maybe even dispel a myth or two in this short session.

2. Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints by Rick Lowe
    Most of us have heard that using the NOLOCK hint is not recommended. But why is this? What is it about NOLOCK that sends most DBAs into a tizzy? And how about other hints such as ROWLOCK and RECOMPILE - are they OK to use? Come hear a discussion on why exactly query hints cause problems when used excessively, and watch some demos of NOLOCK craziness in action. 

3. Third Session

4. Fourth Session
Speaker:

Accompanying Materials:

No material found.

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:

No material found.

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:

Accompanying Materials:

No material found.

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:

Accompanying Materials:

No material found.

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

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:

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: 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: Beginner

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:

No material found.

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

It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. 

In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 10

Time: 11:00 AM - 12:00 PM

Room: Stinger

Data is exploding across enterprises.  Much of it is semi-structured junk.  Or is it junk?  What are you going to do with it until you can find out?  Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data.  When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL.  In this session I will demonstrate the similarities and differences between U-SQL and T-SQL.  I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 10

Time: 11:00 AM - 12:00 PM

Room: Utopia

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