Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 20
2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 13

Time: 11:30 AM - 12:30 PM

Room: Room4

With the introduction of SQL 2016, Query Store has become a unique tool in the DBA toolkit for its almost surgical like performance adjustment capability for systems.  This session will show how to use this feature in adjusting the performance of your SQL Servers in a much more granular way than the impact of using other performance tools that are available to the DBA - comparing and contrasting the Query Store with the traditional methods along the way.  It will also show you how to monitor the impact of your changes, and the changes in the environment, from using Query Store.  Finally the session will cover the basic architecture of query store, the reporting environment, and the DMVs that support query store.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 13

Time: 11:30 AM - 12:30 PM

Room: Room2

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations?  This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 13

Time: 9:00 AM - 10:00 AM

Room: Room4

Does your database development process match your agile front-end counterparts?
Is SQLServer Data Tools the right tool for an agile deployment methodology?

Join me in a fresh approach that will build deployments designed to be agile from the beginning, and also support the capability for zero down time deployments by supporting multiple states of the application, so database deployments can be made in advance, without breaking the application or requiring an outage.

We will touch on how about 35 different types of DDL changes can be prepared to support transition periods, so deployments can run against a live system with no disruptions to also support the next release of your application.

This approach is a new mindset, but with a few months of planning can be leveraged to turn a deployment from a feared event to showing off your true enterprise level DevOps skills. Some demonstrations will show how ReadyRoll can be used to build migrations that support transition periods.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 13

Time: 1:30 PM - 2:30 PM

Room: Room1

You have probably heard the buzz about Azure Machine Learning, aka Azure ML,  over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 13

Time: 1:30 PM - 2:30 PM

Room: Room3

In this session you will be learn what Cosmos DB is and why it is the hottest thing in Azure. What does massively scalable, mullti-model, globally distributed, well-defined consistency models look like? Most important, who is going to be using it and why?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 13

Time: 2:45 PM - 3:45 PM

Room: Room3

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 13

Time: 10:15 AM - 11:15 AM

Room: Room1

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: Intermedia

Session Code:

Date: October 13

Time: 11:30 AM - 12:30 PM

Room: Room1

"SQL Operations Studio (preview) offers a modern, keyboard-focused T-SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich T-SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand T-SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience."

And, it runs on a Mac (and Linux, and Windows, too). Similar to Visual Studio Code, SQL Operations Studio (still in pre-release form) lets you connect to and manipulate your databases without spinning up Visual Studio (or SSMS). We'll walk through how to get the bits and install them, then connect to and query a database (in Azure) - we might not even use a mouse! If time permits, we'll take a look at Code Snippets - a built-in capability to make your T-SQL coding super-productive!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 13

Time: 1:30 PM - 2:30 PM

Room: Room2

Finding any IT industry publication that does not frequently reference Hadoop and Big Data is nearly impossible. Even so, to many SQL Server professionals it remains a mystery. 'Introducing Hadoop to SQL Server Pros' bridges the gap between knowledge of SQL Server and Hadoop. The first half of the session describes how Hadoop works by comparing it to what you already know about SQL Server. The second half is a series of demonstrations of Hadoop functionality. If you've ever wondered how Hadoop works and how it may effect you as a data professional, this is the session to attend.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 13

Time: 10:15 AM - 11:15 AM

Room: Room3

T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them. 
They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty. 
Attend this session to learn how T-SQL windowing functions apply to many real world examples.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 13

Time: 11:30 AM - 12:30 PM

Room: Room3

This interactive session will cover the lessons learned from the practical experience of a SAS provider as they went from 1 ½ 9s to 6 9s of availability concurrently expanding data volume from 500 GB to 5 PB while maintaining customer responsiveness . The session with cover all aspects of the processes used, design and evolution of the architecture, implementation strategies and processes used, monitoring, and the politics behind the availability.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 13

Time: 2:45 PM - 3:45 PM

Room: Room2

LUNCH
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 13

Time: 12:30 PM - 1:30 PM

Room: Room1

PowerShell has allowed DBAs to manage huge numbers of SQL servers, all automatically. Now BI practitioners can reap the same benefits of scale and automation. Scenarios that are normally extremely time consuming can be done quickly, all with a few lines of PowerShell.
This session will be filled with demos based on real-life scenarios and use-cases. We will demonstrate how to scale and automate your BI solutions, with a minimum of effort. In particular, we will be covering PowerShell cmdlets & their integrations with SSRS, SSIS, SSAS, and Power BI. 
By the end of the session, you'll be able to accomplish in minutes what would normally take hours or days. You’ll know ways to quickly migrate and deploy hundreds of reports to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also solve some pesky ETL tasks: deploying large-scale SSIS solutions, updating parameters for existing packages and streamlining data imports for Power BI Report Server
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 13

Time: 10:15 AM - 11:15 AM

Room: Room4

PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions. In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 13

Time: 10:15 AM - 11:15 AM

Room: Room2

In this session we will cover the best strategies to track and improve SSRS / Power BI Report Server performance and scalability. We will cover methods of tracking report performance through DMVs, leveraging the Report Server ExecutionLog3 catalog view, and monitoring Power BI Report Server / Reporting Services using performance monitor (perfmon), and more. We will analyze this information through T-SQL queries in SSMS and Power BI analysis. 
We will discuss when to scale out the Report Server and when to focus on the reporting dataset queries that driven through report execution. We will cover methods of isolating Report Server performance from OLTP activity and solutions to isolate expensive reports when you cannot isolate the OLTP and reporting overhead. Finally, we will cover Reporting Services and Power BI Report Design techniques to improve report performance and scalability. This session is a must for both DBAs and report developers looking to improve report performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 13

Time: 2:45 PM - 3:45 PM

Room: Room4

Database source control can be challenging and tricky to implement. This session will be a discussion on setting up a good foundation to implement source control. During this session we will go over getting buy-in for source control, managing database changes, and avoiding common pitfalls.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 13

Time: 9:00 AM - 10:00 AM

Room: Room1

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services.  In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services.  We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL.  We'll then discuss some of the powerful open source packages that are available to aid your data analyses.  Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 13

Time: 9:00 AM - 10:00 AM

Room: Room3

This sessions introduces to the participants a slice in the life of a DBA managing and supporting a very large environment. It covers the differences between mid and large environment, key aspects to focus on and tips & tricks to manage a very large environment.
The session will provide some insight about CMS and PBM to the participants. 
Few techniques that can be implemented using CMS will be explored, along with some automation ideas.
The audience would leave the session with a different mindset when they think of a very large environment.
The presentation style being drafted will ensure that the participants stay engaged from  start till the finish, as many interesting real life examples will be shared with the audience.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 13

Time: 9:00 AM - 10:00 AM

Room: Room2

In this session we will explore the newest capabilities of Power BI desktop and Power BI Premium. 

With Power BI Premium we now have a scalable solution where dedicated hardware powers cloud-based reporting and Power BI Report Server brings self-service cloud capabilities on-prem.
We will cover Power BI desktop scenarios with Advanced Analytics including forecasting, narrative science, and clustering. We will cover bookmarking, tool tips, Q&A, quick insights, and other recently released capabilities built into Power BI Desktop. 

Finally we will cover the capabilities Power BI Report Server brings and the top tasks available to Enterprise Reporting with the ability to render Power BI reports on-prem, add reporting comments, leverage the latest Power BI Desktop reporting capabilities, and schedule Power BI refresh.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 13

Time: 1:30 PM - 2:30 PM

Room: Room4

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