Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type



Sessions Found: 36
How do you go about making a program run a lot faster!  Like 100 times faster?   It’s difficult.  Microsoft tried in the Hekaton project, its in-memory tables feature of SQL 2014, and they got close.  Inspired by that effort, this presentation looks at some recent cases where I’ve been able to achieve huge performance improvements in SQL Server code and how that happens.

When I work on SQL Server performance I emphasize that the first thing to think about is how to accomplish the task in a different way that will be much faster”.   Sometimes there’s a better algorithm.  Sometimes a different technology is more appropriate.  Sometimes it’s a combination of many changes that combine to create the desired outcome much, much faster. 

This presentation is illustrated with examples from my work and we'll look for common threads that might help us all.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA - Optimization/Tuning

Level: Intermedia

Session Code:

Date: July 30

Time: 8:30 AM - 9:30 AM

Room: LC2

This will be an introduction to the new SQL Server 2016 Always Encryption feature. Unlike Transparent Data Encryption Always Encrypted provides encryption in transit as well as encryption at rest. This will be a survey overview of both the operations and development side of Always Encrypted, but will be mainly operations focused. Considerations for porting existing databases to Always Encrypted will also be discussed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA - Database Development

Level: Intermedia

Session Code:

Date: July 30

Time: 12:30 PM - 1:30 PM

Room: LC21

With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.

In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:

1)  Defining what questions we want answered and how to go about this in an effective and efficient manner.

2)  Creating the data model.

3)  How to gather the necessary data, discussing the training and testing aspect.

4)  Processing the model.

5)  Extracting information from our finished model, discussing the implications of this information.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: July 30

Time: 10:00 AM - 11:00 AM

Room: LC22

You are a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you are considering AlwaysOn Availability Groups. This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such as read-only routing and backup off-loading. In addition, you'll learn how to use the Availability Group Listener correctly and why you should be using Windows Server 2012 R2 or above, along with some of my own personal lessons learned.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 30

Time: 8:30 AM - 9:30 AM

Room: LC19

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA - Database Development

Level: Beginner

Session Code:

Date: July 30

Time: 8:30 AM - 9:30 AM

Room: LC20

Virtually everything in business today is an undifferentiated commodity, except how a company manages its information. How you manage information determines whether you win or lose.” Bill Gates.
This talk will be about how important data quality has become part of our lives and how you can apply strategy to test data quality. We will touch briefly on Internet of Things, understand the importance of data quality and high-level approach to test data quality.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
QA Automation

Level: Beginner

Session Code:

Date: July 30

Time: 10:00 AM - 11:00 AM

Room: LC24

I will teach you the world of making DataSets. The use of T-SQL in SQL Server provides many ways to utilize the data you already have.
In this 60 minute session we will go through the progression of useful techniques to manipulate a record set.
Whether you use tables,temp tables, CTE's and/or Table variables, we will find the right situation for each one.
We will also take a look at 2016's SQL Server's new Columnstore indexes on temp tables if and when they are useful.

Trying to get that impossible result set for that report or extract, then please make it to this intermidiate session on how to resolve your dataset woes!

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA - Database Development

Level: Intermedia

Session Code:

Date: July 30

Time: 12:30 PM - 1:30 PM

Room: LC25

High-end storage is expensive, and SQL Server data compression can make your database smaller. So compress all the tables! No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of when compression is the right solution, as well as what type of compression to use. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA - Optimization/Tuning

Level: Intermedia

Session Code:

Date: July 30

Time: 10:00 AM - 11:00 AM

Room: LC2

Do you see your storage as a mysterious box that just makes your databases slower?  As Database Administrators we all know the importance that storage plays in the performance of our servers, but often times our understanding stop there.  In this session we will cover the core components and concepts that make up a Storage Area Network, or SAN, and how to use that knowledge to improve performance and shorten your troubleshooting time.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Storage and Hardware Architecture

Level: Beginner

Session Code:

Date: July 30

Time: 2:00 PM - 3:00 PM

Room: LC19

I will walk you through how to create effective dashboards in Power BI and the importance of understanding your audience.  There are so many visuals to choose from but how do you know what ones to use?  Are there ones that look great on the screen but don't tell a story?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise BI

Level: Beginner

Session Code:

Date: July 30

Time: 2:00 PM - 3:00 PM

Room: LC24

In this presentation, Bryan will explain the principles of Dimensional Modeling, the foundation of a data warehouse.  He will identify best practices and pitfalls to avoid especially if you come from a relational database background.  The focus is to show how dimensional modeling is applied and provide you with the skills to build your own dimensional models. If you've had a hard time understanding dimensional modeling or have put off learning this critical subject, you need to come to this presentation. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: July 30

Time: 2:00 PM - 3:00 PM

Room: LC22

Being able to group data into logical and meaningful sets can be extremely useful.  When the data involved is a non-repeating sequence of integers, grouping is not too difficult.  Most real data, though, is made up of dates, times, decimals, and rarely can guarantee non-repeating, non-null data sets.

This is a fast-paced session that delves into methods that can be applied to any data.  Want to know how many production incidents make up a single common problem?  Can we track sales success by the number of  consecutive weeks that an agent has exceeded their goal?  How about the longest home run streak hit by Derek Jeter at night games on Tuesdays?

Discussion will include performance, CTEs, recursion, set-based vs. iterative analysis, and some pretty hairy TSQL!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA - Database Development

Level: Advanced

Session Code:

Date: July 30

Time: 2:00 PM - 3:00 PM

Room: LC20

Beginners are frequently confused by the myriad of options available for date data types and manipulating date and time values. This presentation will review the most common date and time related data types, date formats, and many of the common challenges in manipulating dates and times. Some examples will be finding the first or last day of a month, quarter, year - adding Time and Dates together, finding and expressing the difference between date and date/time values, and when and how to manipulate dates and times using string manipulation techniques. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA - Database Development

Level: Beginner

Session Code:

Date: July 30

Time: 3:30 PM - 4:30 PM

Room: LC20

Gerrit is a free, web-based team collaboration code review tool which was developed at Google (https://code.google.com/p/gerrit/  ). Adopting Google Project Gerrit is fun! In this presentation, you'll get a chance to learn the basics of Gerrit: what is Gerrit; how we integrate with Git as well as Continuous Integration tools. We will explore topics including how to adopt Gerrit seamlessly, how to collaborate among teams on code review process, how to navigate Gerrit UI, how to troubleshoot, how to administer Gerrit, and so on. You will learn a benefit of this valuable code review tool as a part of database/application development process improvement.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA - Database Development

Level: Intermedia

Session Code:

Date: July 30

Time: 12:30 PM - 1:30 PM

Room: LC24

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL.  In this session, we'll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,).  We'll go over step-by-step in getting started with U-SQL, and review some use case scenarios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 30

Time: 8:30 AM - 9:30 AM

Room: LC24

You've seen demos on Azure Machine Learning Studio but did you know the real magic is done by calls to R code. In fact, R has been used to do predictive analytics for years which is why Microsoft integrated it into SQL Server 2016. In this presentation, we'll see how easy it is to select, train, and use models in R. We'll also discuss assessing the model's fit and comparing different models. All this will be done using Shiny, R's version of ASP .Net, i.e. essentially R Server Pages but amazingly easy to use which serves to demonstrate R's extensibility.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: July 30

Time: 3:30 PM - 4:30 PM

Room: LC21

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you. Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 30

Time: 10:00 AM - 11:00 AM

Room: LC20

Is your brain mush from too much technical content, but you just need a break before the next session or the raffle? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 30

Time: 3:30 PM - 4:30 PM

Room: LC23

A session full of demos demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster.

We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA - Optimization/Tuning

Level: Intermedia

Session Code:

Date: July 30

Time: 2:00 PM - 3:00 PM

Room: LC2

How outsource administrative tasks to your end user groups in a safe, secure, and repeatable pattern.   Now you no longer have to pause and stop what you are doing to create that new login, and replicate it to your Disaster Recovery.   You do not have to stop and perform a backup/restore to refresh the development environment.  Empower your end users, let them do this on their own without compromising your security.

There will be a demo!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA - Administration

Level: Beginner

Session Code:

Date: July 30

Time: 3:30 PM - 4:30 PM

Room: LC25

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