Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type

Sessions Found: 53
Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged…  we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Infrastructure

Level: Beginner

Session Code:

Date: May 19

Time: 12:10 PM - 1:25 PM

Room: Radio City (6th Floor)

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

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 2:30 PM - 3:45 PM

Room: Majestic

If you are familiar with SSIS , You will like Azure Data Factory. It  is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 1:10 PM - 2:25 PM

Room: Ambassador

You're a DBA or a developer, and you know all about Wait, Queues, IO, In-Memory, etc for getting the most out of your SQL Server T-SQL Queries. But what do you know about performance tuning in Azure SQL DW? 
How do you identify the queries that can be optimized? Can you identify how to optimize those queries? What are the base performance considerations for your MPP environments?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Performance Tuning

Level: Intermedia

Session Code:

Date: May 19

Time: 1:10 PM - 2:25 PM

Room: Music Box

There are many Data Platform offerings available on Azure and new ones are introduced regularly and evolved. In this session we will cover various offering and what scenarios are most suitable for. We will also discuss whether it makes sense to make use of this services or roll your own on-premise or hybrid solutions
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Infrastructure

Level: Beginner

Session Code:

Date: May 19

Time: 1:10 PM - 2:25 PM

Room: Broadway

The job of a data professional is evolving rapidly, driving many of us to platforms and technologies that were not on our radar screen a few months ago. I am certainly no exception to that trend. Most of us aren't just monitoring backups and tuning queries - we are collaborating with teams throughout the company to provide them data and insights that drive decisions. This presentation walks you through how a silly idea from a soccer podcast got me thinking about how Azure Logic Apps, sentiment analysis, and Azure SQL DB combine to provide potentially powerful insights to any company with a social media and sales presence. Join me as I walk you through building a solution that can impact your company's bottom line - and potentially yours too!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 10:35 AM - 11:50 AM

Room: Central Park West(6th Floor)

Most Microsoft BI developers are familiar with authoring DAX measures for SQL Server Analysis Services Tabular and Power BI projects. However, far fewer are experienced with writing DAX queries or integrating DAX queries into MSBI projects. 

This session includes three 20 minute segments as follows: A) DAX Query Structure and Functions B) Embedding DAX Queries into DAX Measures and C) Leveraging DAX Queries in SSRS Reports. Attendees will learn the essential concepts and functions of DAX as a query language, powerful DAX features including variables and set-based functions, and how to utilize DAX Studio to develop and test DAX queries.  

Each segment of this session will be supported by multiple example DAX queries and all queries will be made available for download following the event.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 3:50 PM - 5:05 PM

Room: Belasco

We will discuss all details of deploying SQL Server 2016 AlwasyOn on Google Cloud in real life.  There are already white paper and google official document on creating AlwaysOn. However those are not ready for real production environment. I will show you all missing parts to deploy in real life on GCP
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 3:50 PM - 5:05 PM

Room: Music Box

More and more of our data is originating from or being moved to the cloud, but many of us are doing the same old ETL process with SSIS and other tools. In this session, we will compare a legacy SSIS package and show the process of building the same flow with the newly released Azure Data Factory v2
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 10:35 AM - 11:50 AM

Room: Central Park East(6th Floor)

While human-like deductive reasoning, inference, and decision-making by a computer is still a long time away. But, there have been remarkable gains in the application of AI techniques and associated algorithms when used to solve real-world problems. One such AI technique that can be leveraged effectively to solve problems is Deep Learning. Deep Learning is a subfield of machine learning that focuses on algorithms inspired by, and partially modeled on biological neural networks called artificial neural networks. 
The Microsoft Cognitive Toolkit (CNTK) is a free, easy-to-use, open-source, commercial-grade toolkit that trains deep learning algorithms to learn like the human brain. This session is meant to explain high level concepts of AI, deep learning, and neural networks using CNTK at a level that can be understood by most non-practitioners.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: May 19

Time: 3:50 PM - 5:05 PM

Room: Broadway

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:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 3:50 PM - 5:05 PM

Room: Marquis

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
 - Source to Target mapping documents can be used to generate the code to effect the mapping.
 - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
 - Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
 - Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 2:30 PM - 3:45 PM

Room: Music Box

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition.  Unfortunately the database is commonly considered a bottleneck.  Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver.  Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 1:10 PM - 2:25 PM

Room: Central Park East(6th Floor)

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. 

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 9:15 AM - 10:30 AM

Room: Music Box

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 2:30 PM - 3:45 PM

Room: Broadway

What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream. 

In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I'll give some helpful tricks to getting your next job. You'll learn how to write a resume that gets you noticed, how to navigate interviews, and learn how to decide if a potential job and employer is right for you. 

Bring your own resume to this session, and I'll provide you some personal (and private) feedback on what I would do to help improve your resume so you can land your Dream Job.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 19

Time: 9:15 AM - 10:30 AM

Room: Ambassador

You've just been told by HR that you are no longer a part of their organization.  You've been kicked to the curb.  You are now living in the no-man's land called unemployment.

Unemployment is a scary situation.  You're dealing with emotions and uncertainty.  You don't know if you'll be out of work for days, weeks, or months.

Fortunately, unemployment is survivable.  In this session, I'll share my own experiences (and perhaps we'll talk about some of yours) with unemployment, and how I managed to get through the tough times.  We'll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time.  Hopefully, you'll land on your feet once again before long!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 19

Time: 10:35 AM - 11:50 AM

Room: Music Box

You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, ETL patterns, and more
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 10:35 AM - 11:50 AM

Room: Majestic

Many organizations have hesitated to migrate on-prem databases to the Azure SQL Database platform because they still needed a server and license to run SSIS.  But with the recent announcement of the preview of SSIS in Azure with Azure Data Factory (ADF) v2, Microsoft has cleared this portion of the migration path.  

Come to this session to learn how to set up SSIS in Azure, migrate your existing SSIS packages, and execute packages from the cloud.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 9:15 AM - 10:30 AM

Room: Majestic

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

Level: Beginner

Session Code:

Date: May 19

Time: 10:35 AM - 11:50 AM

Room: Belasco

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