Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 62
How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties.  Seems like that is all I have done for last many years.  But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios.  In some scenarios a well-defined clustered index may out perform a covering non-clustered index.  Results are very interesting and may surprise you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 9:00 AM - 10:00 AM

Room: Jakku
4-1703

Reports are no longer just black and white columns and rows of numbers. Reports combine tables with charts, KPIs and more. There is a lot to be concerned about when designing reports to provide information to your audience. Today, your company can face lawsuits if your reports are not accessible to all users.  You must consider the way you display your data, the amount of data displayed, the use of color and maybe even the use of animation. Creating attractive reports is not just about making them pretty. It is about grabbing your audience's attention. It is making sure you don't inadvertently introduce accessibility problems that limit who can receive your message, your data. This session while looking at some reporting best practices will also give you information to steer you clear of accessibility concerns to insure access to your results by all consumers of your report.  (Note: Accessibility is governed through the guidelines of the American Disabilities Act)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 04

Time: 12:45 PM - 1:45 PM

Room: Bespin
4-1704

So you have heard about Cubes and (analysis) Models but maybe have never gotten fully “into” them? Or maybe, you have built Cubes and Models but just feel the results did not match with your expectations?

Analysis Services is a broadening platform with offerings On-Premises, in the Cloud, On Azure and everywhere in between. 

With more than 20 years experience on Analysis Services, the speaker will help you make the most of your NEXT efforts at Analysis Services by delivering an example heavy session leaving no doubt about the types of solutions you can achieve with Analysis Services! 

Learning Objective 1:	
Attendees will learn the fundamentals of WHY they should leverage Analysis Services

Learning Objective 2:	
Attendees will be provided guidance on how to start simply with Cubes/Models that can be grown as needs develop

Learning Objective 3:	
Attendees should expect to be able to identify more easily the most relevant data for a Cube/Model
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: Kashyyyk
51-1102

This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services.

This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy,  etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 04

Time: 10:15 AM - 11:15 AM

Room: Kashyyyk
51-1102

Continuous integration, delivery, and deployment are common elements of modern DevOps practices. However, it’s rare to see these practices put into place for data-centric applications, like databases, ETL, data warehouses, or reports. In this session, we’ll cover why these approaches are beneficial for the data organization and the pieces you need to have in place to be successful. We’ll also cover some of the prime trouble spots that organizations run into, as well as some tools that can help jump start your efforts.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 9:00 AM - 10:00 AM

Room: Kashyyyk
51-1102

Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to 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: May 04

Time: 2:15 PM - 3:15 PM

Room: Gamorr
4-1705

In this session we will investigate the various data storage options that are presented for developers in the Microsoft Azure Cloud. We will look at the various storage options for both strongly and loosely bound schema. Topics will include blob and table storage, Azure Search, CosmosDb, Azure Sql Database, and Azure Data Lake Analytics. We will also cover data movement options and security before doing a deeper dive into Azure Sql Database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 10:15 AM - 11:15 AM

Room: Jedha
51-1101

The Internet of Things (IoT) is one of the most talked about emerging technologies nowadays. But what is it and how can it help by business? Most importantly, how do I get started? In this presentation, we will do an interactive demo with a Raspberry PI and a Microsoft Sphere MCU along with several sensors and components to capture and analyze data from a connected device in Azure IoT Hub and IoT Central. Learn how to connect, monitor and manage connected devices using Azure IoT Hub. We will also discuss how Azure IoT Edge can simplify secure deployment of complex event processing, ML, and AI functionality to connected devices to reduce the latency of decision making.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 04

Time: 9:00 AM - 10:00 AM

Room: Gamorr
4-1705

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 10:15 AM - 11:15 AM

Room: Gamorr
4-1705

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion.  Unlike a session on concepts, this session surrounds itself with a real-life situation and how automation was used with DevOps practices to build a solution.
The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 9:00 AM - 10:00 AM

Room: Yavin
4-1702

The Naïve Bayes series of algorithms are some of the simplest classification algorithms, but they tend to offer reasonably good results very quickly for a number of problems, including Natural Language Processing problems such as spam classification, as well as more classical feature-driven classification.  In this talk, we will look at the math behind Naïve Bayes classification, solving problems by hand before looking at a package in R which solves the problem for us.  By the end of this talk, you should be able to apply Naïve Bayes to existing problems.  No experience with statistics is required, although there will be a small amount of math.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: May 04

Time: 2:15 PM - 3:15 PM

Room: Kashyyyk
51-1102

You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially
when it comes to indexes. Some of the things you have probably heard are:
? keep clustered index width small
? unique indexes perform better
? keep non-clustered index width small
? compressed indexes have fewer logical reads
? add one index for each column

But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice.
Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about
performance, and the right indexes will give your application a big performance advantage.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: Jakku
4-1703

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 04

Time: 11:30 AM - 12:30 PM

Room: Coruscant
51-1205

Back in 2003 Microsoft released an addition to SQL Server 2000 named SQL Server Reporting Services (SSRS).  This is a story of the journey of the BI Engine that could. From updates, to periods or rest and updates again. Not only has it been updated, but new features, capabilities and event a new project has been born from its humble beginnings. Now, paginated reports, the only type of report that was available when SSRS was initially released, are available in both on-premises and cloud-based solutions.  Join this session to experience the journey of SSRS and how to create and deploy reports across all the different products available in the Microsoft Ecosystem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: Bespin
51-1209

This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization.  It will also touch a little on why you might choose Power BI over Power Pivot and why you might not.  It will also look at how to create drill down detail screens to expose the details behind your visualizations.  Finally, we will touch on how to publish your Power BI results for others in your organization to share.  A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 04

Time: 9:00 AM - 10:00 AM

Room: Coruscant
51-1205

Implementing DevOps for data isn’t easy. The tools, technologies, and practices are still evolving, and organizations often struggle to make the transition to more agile ways of delivering data-centric solutions. During this session, we’ll discuss the top 5 issues that impact successfully moving to a Data DevOps approach, including challenges with people, processes, and technology. Since one size does not fit all, we will also cover multiple potential solutions to these blockers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 04

Time: 2:15 PM - 3:15 PM

Room: Yavin
4-1702

Power BI has many features that are appealing but clearly the storytelling capabilities are what set it apart from other BI tools.  Features like bookmarks, tooltip report pages, and drillthrough filters are just a few examples of how you can make dull reports a real interactive experience.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: May 04

Time: 9:00 AM - 10:00 AM

Room: Bespin
4-1704

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 04

Time: 9:00 AM - 10:00 AM

Room: Hoth
4-1706

In this breakout session, you'll learn the basics of the DAX language, Power BI’s modeling language. Belinda will introduce you to the concept of calculated columns, measures, and basic data modeling, with some practical examples. This introduction will cover basic calculations and an overview of scalar and table functions. This session has practical examples of business analytics and users.  To the Developer, DAX feels like a programming language; to the user, DAX feels like Excel formulas.  
1.	Define DAX and understand where it fits and why it is important
2.	Perform and Review some basic DAX commands
3.	Differentiate modeling with DAX versus the Power BI Query Editor
4.	Build a Date Table to allow for the use of Time Intelligence DAX calculations
5.	Overview of CALCULATE in DAX functions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 04

Time: 12:45 PM - 1:45 PM

Room: Coruscant
51-1205

Do you want to make your deployments risk free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your Team? Are your application and database deployment separate processes? Do you encounter issues while deploying your database changes? Do you want to automate your testing process? Is your database slowing you down?

If the answer to any of the above questions is a Yes, then this presentation is for YOU. 
Come join me in this 60 min session to understand the problems with traditional database development, why organizations are moving towards achieving Continuous Integration and Database DevOps, the problems it tries to solve and learn about the toolsets which will assist you in this journey towards painless database deployments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 04

Time: 10:15 AM - 11:15 AM

Room: Yavin
4-1702

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