Build Schedule

Advanced Filters:
  • Track

    clear all















  • Speaker


  • Level


  • Session Type



Sessions Found: 31
This session will show a lot of things in the world of data that went very, very wrong... 
And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let's have some "Schadenfreude"!
After a log day, come in and have some fun before the evening event starts
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 28

Time: 3:30 PM - 4:45 PM

Room: 4

This session is an introduction to tuning backups.  Learn how to take those backup jobs to disk and change them from running for hours to running in minutes.  We’ll be discussing the advantages & disadvantages of using the following parameters: COMPRESSION, BUFFERCOUNT, & MAXTRANSFERSIZE.  We’ll also be covering the concept of striping database backups.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 28

Time: 3:30 PM - 4:45 PM

Room: 21

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 (75 minutes)

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: July 28

Time: 10:00 AM - 11:15 AM

Room: 19

In this presentation we'll learn the basics of constructing a predictive model in the R programming language.  We'll start by discussing visualizations that help us understand our data and then build and test a predictive model. Key points include selecting the model, training it, and evaluating the model's effectiveness. In the process, we'll learn about the R language and the popular integrated development environment RStudio.  Find out what all the hype is about!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Machine Learning and AI

Level: Beginner

Session Code:

Date: July 28

Time: 2:00 PM - 3:15 PM

Room: 5

This is an open session where you may show up any time and ask any technical or professional questions of our panel of speakers.

Ask the Experts is an opportunity to find answers and resources to address ongoing challenges, learn more about our speakers, and maybe stump them : )
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Panel

Level: Beginner

Session Code:

Date: July 28

Time: 3:30 PM - 4:45 PM

Room: 20

Azure Data Factory (ADF) has done some mileage since it's beginning in 2015. It has evolved and is now able to integrate your SSIS loads and do lots of work with your data in Azure. In this session, you will learn the new features of Azure Data Factory V2 and how SSIS packages can be triggered from it. 
This session will also introduce concepts like the modern data warehouse and what are the new challenges that comes with data integration both on-premise and cloud based.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Big Data

Level: Intermedia

Session Code:

Date: July 28

Time: 12:30 PM - 1:45 PM

Room: 5

Success of a good BI infrastructure is measured by two most important factors: 
a) Better access to data and 
b) Increased operational efficiency
How can you set up your own BI infrastructure in the cloud to address these? 
What components do we consider?
We can do that by proper selection of technology and vendors from Azure Market Place. How do we keep an eye on possible use of Big Data for your BI. We will also look at the best practices for doing so. We will take a fleeting look at some of the storage options for us in Azure and some Big Data concepts as well.
We will learn about Copy Data Virtualization in Azure Market Place that can help you provision terabytes worth of information in matter of minutes. 
We will also learn about setting up teams and ways to train them(and yourself) in this fast evolving world of Azure.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: July 28

Time: 10:00 AM - 11:15 AM

Room: 20

With so many new technologies it can get confusing on the best approach to building a big data architecture.  The data lake is a great new concept, usually built in Hadoop, but what exactly is it and how does it fit in?  In this presentation I’ll discuss the four most common patterns in big data production implementations, the top-down vs bottoms-up approach to analytics, and how you can use a data lake and a RDBMS data warehouse together.  We will go into detail on the characteristics of a data lake and its benefits, and how you still need to perform the same data governance tasks in a data lake as you do in a data warehouse.  Come to this presentation to make sure your data lake does not turn into a data swamp!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: July 28

Time: 12:30 PM - 1:45 PM

Room: 4

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over 100 times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application Development

Level: Intermedia

Session Code:

Date: July 28

Time: 10:00 AM - 11:15 AM

Room: 5

With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done,  how to extract data from a tabular model using Data Analysis Expressions (DAX).
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Self-Service BI

Level: Intermedia

Session Code:

Date: July 28

Time: 8:30 AM - 9:45 AM

Room: 19

An estimated 2,000 new applications are released daily yet, the demand for new applications is increasing. Resulting in enterprises that lack sufficient resources to meet demand. Costly storage, compute and licenses required to maintain multiple copies of production databases are scarce. Delays in development cycles result as developers wait for DBAs, who in turn wait for storage administrators to provision the required space. The business suffers as project delays lead to deferred revenue or customer service impact. Actifio virtualizes production system data, delivering instant, non-disruptive access for application development and test without the need for additional storage. Virtually multiplying the output of a production environment, while simultaneously reducing costs. This session will provide an understanding of how to utilize Actifio for application development and test
data automation to reduce application development cycle time, reduce costs and eliminate production impact.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (30 minutes)

Track:
Application Development

Level: Intermedia

Session Code:

Date: July 28

Time: 11:30 AM - 12:00 PM

Room: 21

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:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
QA/Automation

Level: Beginner

Session Code:

Date: July 28

Time: 8:30 AM - 9:45 AM

Room: 5

Do you know what your SQL Server environment looks like? Using PowerShell along with dbatools and PowerBI we will cover how to collect, store, and document this information.

Finding a free and simple method to gather information about my SQL Server environment was difficult. Using a combination of PowerShell, the dbatools module, and a PowerBI report I finally found something that works for me. I hope it can be helpful for you as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 28

Time: 12:30 PM - 1:45 PM

Room: 21

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?

This presentation will review the following techniques to fix your woes.

Coverage:

1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: July 28

Time: 8:30 AM - 9:45 AM

Room: 21

If you work in an agile environment, design requirements often come to us as stories with the phrase: "As a type of user, I want to ..."

For example: As a DBA, I want to be able to break down user stories to understand how they translate into our current database design and usage and have an understanding as to how it will affect future needs.

That user story is also the goal for the session. This will present one approach to how we can think about these user stories to find the data that we need to design our databases for. We'll even work through an example together. 

This is for DBAs who are involved in any part of designing databases, who want to practice how to come up with database designs, or who just another way to think about how they approach their database development in general.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: July 28

Time: 2:00 PM - 3:15 PM

Room: 4

Abstract:

Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan.

I will be introducing the brother’s grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek.

Coverage:

1 – Creating a database from scratch.
2 – Creating a table with LOB field.
3 – Loading files via BULK INSERT.
4 – Performance via traditional techniques.
5 – Creating a full text index.
6 – Performance with the full text index.
7 - Using FTI in a Azure SQL database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: July 28

Time: 3:30 PM - 4:45 PM

Room: 19

PCI-DSS, SOX, ISO, GDPR... What are the Cyber Standard regulation and how do we implement them in SQL Server? In this session I will cover the main security regulations and will discuss the security configuration required to comply with each one of them.
The focus will be on the new GDPR standard.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 28

Time: 2:00 PM - 3:15 PM

Room: 7

On-premises data warehouse solutions are typically a large up-front capital expense which expensive boundaries to expansion. This led my organization to look to the cloud. In this session, I cover the basics of Azure SQL Data Warehouse, its architecture, and why you should be interested in combining the flexibility and scalability of the cloud with a massively parallel processing data warehouse.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise BI

Level: Beginner

Session Code:

Date: July 28

Time: 8:30 AM - 9:45 AM

Room: 7

You have decided to migrate your on-premise SQL Server database to Microsoft Azure SQL Database and then realize you cannot restore a backup to Azure's Platform as a Service. Seriously!? In this talk, I will explain three different migration methods and demonstrate how they can be used to launch your database into the cloud.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 28

Time: 10:00 AM - 11:15 AM

Room: 7

Have you been thinking about presenting at a user group?  Are you being asked to present at your work?  Is learning to present one of the keys to advancing your career?  Or do you just think it would be fun to present but you are too nervous to try it?  Well take the first step to becoming a presenter by attending this session and I will guide you through the process of learning to present and becoming good at it.  It's easier than you think!  I am an introvert and was deathly afraid to speak in public.  Now I love to present and it's actually my main function in my job at Microsoft.  I'll share with you journey that lead me to speak at major conferences and the skills I learned along the way to become a good presenter and to get rid of the fear.  You can do it!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 28

Time: 10:00 AM - 11:15 AM

Room: 4

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