Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 33
Azure Cosmos DB is the first and only globally distributed, multi-model database system. The service is designed to allow customers to elastically and horizontally scale both throughput and storage across any number of geographical regions, it offers guaranteed less than 10 ms latencies at the 99th percentile, 99.99% high availability and five well defined consistency models to developers. It’s been powering Microsoft’s internet-scale services for years.
In this session, we will cover how you can get the most out of Azure Cosmos DB by gaining a deep insight in to the system internals. From global distribution to partitioned collections to automatic indexing - this session will equip you with invaluable insight in to building blazingly fast planet-scale applications
Speaker:

Accompanying Materials:

Session Type:
Regular Session (50 minutes)

Track:
Azure

Level: Intermedia

Session Code:

Date: August 26

Time: 2:00 PM - 2:50 PM

Room: Theatre C300

Experts in all the represented fields will be answering your questions in this room. First come first answered!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 26

Time: 3:00 PM - 3:50 PM

Room: C400

With the shift to microservice architectures, gone are the days where all of an organization’s data is stored in a single, massive, relational database. We’re quickly shifting to a polyglot persistence approach for dealing with data — using separate data stores that are each best suited to the data being stored.

We’ll look at the wide variety of managed services available to store data on Microsoft Azure including the usual suspects such as SQL DB, MySQL, PostgreSQL, Table Storage, and others like Cosmos DB, Redis, Search, and more. The audience will walk away with a broad understanding of Azure’s data portfolio and  be able select the right tools to meet their data persistence needs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: August 26

Time: 10:00 AM - 10:50 AM

Room: Theatre C300

Explore Usage of Azure Datafactory to mesh data from various cloud offerings such as AWS and Google Cloud. Many vendors would have more than one cloud offering and they would bring the data together. We will explore strategies to connect data from various sources, obstacles, workarounds, troubleshooting and best practices, all hands-on
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: August 26

Time: 11:00 AM - 11:50 AM

Room: C150

The power of cloud storage and compute power has made data warehousing possible for businesses of all sizes. What was once a large capital expenditure and multi-year implementation can now be deployed and ready to use within minutes and allow any organization to collect, query and discover insights from their structured data sources. 

With a full T-SQL interface and compatibility with the rest of the Microsoft data stack, Azure Data Warehouse can fit transparently into your business data strategy and leverage already existing and familiar development and management skills.
 
In this session we will look at the main concepts of the Azure SQL Data Warehouse service, how it's different than SQL Server and the advantages it provides to an on-premises solution.
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: August 26

Time: 10:00 AM - 10:50 AM

Room: C130

Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing. There's even a bit of In-Memory OLTP. This is a demo-heavy session.
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
dev

Level: Beginner

Session Code:

Date: August 26

Time: 9:00 AM - 9:50 AM

Room: C150

Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
DW/BI

Level: Beginner

Session Code:

Date: August 26

Time: 1:00 PM - 1:50 PM

Room: C130

With the proliferation of both SQL and NoSQL databases, organizations can now target specific fit-for-purpose database tools for their different application needs regarding scalability, ease of use, ACID support, etc. 

Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations. All of these are new challenges that are coming into the field of responsibility of the SQL DBA professional.

In this session we'll compare the NoSQL and SQL offerings from AWS, Microsoft Azure and Google Cloud, their use cases for each one based on our own client projects, and how they are different to the different SQL Server features we are familiar with.
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: August 26

Time: 3:00 PM - 3:50 PM

Room: C100

Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
dev

Level: Beginner

Session Code:

Date: August 26

Time: 10:00 AM - 10:50 AM

Room: C150

We have more information available to us today than ever before.  So much so that we run the risk of not being able to tell concise stories.  There's a lot more to creating that story than just getting the correct information.  Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 26

Time: 10:00 AM - 10:50 AM

Room: C100

If you are working with SSAS Tabular, Power BI, or good ol' Power Pivot for Excel, you've likely run into a need for DAX, the formula and query language of these tools.  A very common task is to augment, override, or otherwise modify a filter context.  This sounds easy enough, but if you've had experience beyond simple filters, the syntax and behavior may seem confusing, or worse, counter-intuitive. The purpose of this presentation is to discuss the different types of filters, their behavior, and their interactions with other DAX formulas.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: August 26

Time: 2:00 PM - 2:50 PM

Room: C130

If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are some limitations. Cozyroc’s Excel Source Plus and Excel Destination Plus components remove those limitations. In addition, Cozyroc’s Excel Task enables editing of Excel files from SSIS packages. In this session, I’ll talk about the capabilities of the Cozyroc components and demonstrate how easy it is use use these components with SSIS.
Speaker:

Session Type:
Lunch Session (50 minutes)

Track:
DW/BI

Level: Beginner

Session Code:

Date: August 26

Time: 12:00 PM - 12:50 PM

Room: C150

Power BI provides analytics solutions for your whole organization. Small Businesses can profit by exposing their data, and see the impact in their clients sites. I will introduce "Oil test Systems" a small business that tests oil in trucks. It's clients portal and the test data as other insights and recommendations, can be viewed by the clients using SharePoint 365. Performance dashboards are displayed using PowerBI, giving the business the opportunity for efficient decision making. The demo was built without code, every ITPro can do it!.
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: August 26

Time: 3:00 PM - 3:50 PM

Room: C150

Learn the journey of an Open Source Content Management's move from on premise to the cloud. DNN (formerly known as DotNetNuke) has traditionally been an on-premise solution on IIS and SQL Server. While building a new solution for content management we literally hit a limit with the on-premise Sql Server tools. We needed a schema free database - DocumentDB came to rescue. Find out why we didn't go with MongoDB. We also needed search capability, where Azure Search became the tool of choice. We need logging and telemetry from our application - App Insights was chosen. We also use Event Hubs, Stream Analytics and Data Lake. I will talk about all of these here, and present you a full picture on how to build real life scalable business applications using Azure technologies. We will focus mostly on the Data aspects of the architecture in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: August 26

Time: 11:00 AM - 11:50 AM

Room: C400

Service Pack 1 for SQL Server 2016 was released to the market in November. It brings lot of enhancements and value for a customer that can greatly improve their experience with SQL Server. This session will cover some of the key enhancements that will entice a customer to upgrade to SQL Server 2016. In this session, we’ll also talk about several supportability and diagnostic improvements in the database engine and high availability technologies that will help customer and the field quickly identify and resolve issues in a mission-critical environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: August 26

Time: 3:00 PM - 3:50 PM

Room: Theatre C300

A look at the intersection of hardware, software, and internet. See what it takes to bring your next workshop project to life including stories about the success and failures of creating a Smart Mirror. We will take a look into hardware including that from the hardware store and the software required to make the magic happen.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 26

Time: 9:00 AM - 9:50 AM

Room: C100

Data Lakes have become a new tool in building modern data warehouse architectures. In this presentation we will introduce Microsoft's Azure Data Lake offering and its new big data processing language called U-SQL that makes Big Data Processing easy by combining the declarativity of SQL with the extensibility of C#.   We will give you an initial introduction to U-SQL by explaining why we introduced U-SQL and showing with an example of how to analyze some tweet data with U-SQL and its extensibility capabilities and take you on an introductory tour of U-SQL that is geared towards existing SQL users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
Azure

Level: Intermedia

Session Code:

Date: August 26

Time: 1:00 PM - 1:50 PM

Room: Theatre C300

With SQL Server almost available on Linux, seasonal SQL Server DBAs, who spent most of their work on Windows, should hone their skills on Linux.

The session will explore the essential skills needed to manage SQL server on Linux. It will also explore the most common tasks and procedures DBAs commit on Windows and their equivalents on Linux. Some troubleshooting skills on Linux will be explored, as well
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (50 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: August 26

Time: 1:00 PM - 1:50 PM

Room: C150

As amazing as our Power BI reports and dashboards are, they are designed for a full sized web page, not the smaller mobile phone screen.  In this session Ken will walk through the process of taking a regular Power BI report and then optimizing both the report and dashboard for mobile consumption, all with tools built in to the Power BI ecosystem.  We’ll look at changing layouts, location filtering, setting alerts, annotations and more!
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: August 26

Time: 10:00 AM - 10:50 AM

Room: C400

The 2016 product release was a big upgrade that, once again, brought SSRS into center stage as a market-leading reporting and dashboard design tool for operational and BI reporting.  The big news was that SSRS reports truly run in all modern web browsers and work on mobile devices and all desktops in a new modern web portal.  The introduction of Mobile Reports, formerly known as Datazen, gives mobile device users interactive, tactile and actionable dashboard style reporting on all the popular mobile smartphones and tablets.  The 2017 product brings even more goodness with the integration of Power BI Report Server, on-premises Power BI report integration in a cloud-free platform.  Join Paul for a full-day pre-conference session where you will explore new capabilities and learn to integrate modern reporting into your data platform.

This session covers:
• What’s new in Reporting Services 2017 (and 2016)? 
• Reporting Services and Power BI Report Server Architecture 
• Parameter improveme
Speaker:

Session Type:
Regular Session (50 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: August 26

Time: 1:00 PM - 1:50 PM

Room: C100

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