Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


Sessions Found: 17
Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Saturn / 81

DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Keynote (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 22

Time: 10:30 AM - 11:45 AM

Room: Nebula / 40

Demonstrate the steps to import raw data from text file, Access Database and Excel file into Excel 2016, and then build a dashboard using PowerPivot, Power Map and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Nebula / 40

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Saturn / 81

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Jupiter / 81

Administering SQL Server environments can seem like a daunting task for any DBA.  In this session, we’ll provide some guidelines and tips to help new DBAs get started on the right foot.  Backups/restores, integrity checks, index maintenance, documentation, security and alerting will be some of the topics covered in this session.  We’ll also be covering some of the online resources that are available.  Bring your questions!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Mercury / 81

Microsoft SQL Server Analysis Services & Azure Analysis Services help you build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. Join this session for a look forward to what's coming in SQL Server Analysis Services vNext & Azure Analysis Services. The demos will cover new features familiar to Power BI Desktop modelers such as Power Query integration. Various modeling enhancements will be included such as Detail Rows allowing users to easily see transactional records, and improved support for ragged hierarchies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 10:30 AM - 11:30 AM

Room: Mercury / 81

Walkthrough creating SSRS hosted Power BI with On-Premise Servers. 
-  Basic Setup of SSRS and Power BI preview on a development environment
-  Creating a Simple Dashboard
-  Publishing Report to SSRS
-  Highlight of currently available features and key capabilities not available
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Galileo / 270

Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Galileo / 270

While the DAX language gets all of the Power BI attention and love, its partner M is nonetheless a powerful workhorse that can be harnessed to do amazing things. We will begin by introducing ourselves to the functional language by building a calendar -- absolutely necessary for all of those lovely DAX time intelligence functions to work. From establishing the time period in question to deciding on what information we need and how we want it presented, our understanding of M will grow as we progress through this construction.

We then look at what to do when the information you get is incomplete and contradictory. Cleaning up data and handling errors and missing data will be our focus in an example of combining multiple data sources into a single data set. We consider this crucial step in the ETL cycle.

Our examination will conclude with a discussion of best practices, centering on coding style and deciding on when to solve a problem with M versus when to rely on DAX.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Mercury / 81

Always On Availability Groups (AGs) were introduced in SQL Server 2012. AGs significantly expanded our HA/DR options. However, in both SQL 2012 and SQL 2014 two limitations were extant in the code—both Network Transport and Log Redo significantly compromised performance. In SQL Server 2016, these limitations have been significantly improved. 

Our work shows enhancements of 7x – 10x, allowing over 1/2GB/s (4Gb/s) across the wire. These improvements expand solutions options for Tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs. 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 22

Time: 10:30 AM - 11:30 AM

Room: Jupiter / 81

Choosing where to store your data is far more difficult than ever. We can be paralyzed with choice! This session seeks to ease that anxiety and provide direction for application developers and DBAs. You'll learn the differences between DocumentDB, Azure Table Storage, Azure Blob Storage, Azure SQL Database, Azure SQL in a VM, Azure SQL Data Warehouse, Azure Data Lake Analytics, Azure Data Lake Store, and more. See demos and review case studies so you'll have a complete view of how data is stored in Azure and how to choose great between these great tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Jupiter / 81

Data Science is an ever increasing topic in the Data Analytics space and the R language is at the center of most conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages.  

The R language is run as a desktop application and was not built with performance and scale required to accommodate Big Data. Revolution Analytics, a wholly owned subsidiary of Microsoft, has solved the performance and scaling issues of a desktop application by creating a more robust enterprise architecture. SQL Server 2016 brings the power of R and Revolution Analytics into the industry leading relational database. 

This session will introduce R and demonstrate the functionality and power of using R within SQL Server. 

This presentation is ideally suited for Business Intelligence professionals that are interested in understanding the new R Service that is being added to SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: April 22

Time: 10:30 AM - 11:30 AM

Room: Galileo / 270

Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security? This session builds on a full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the constraints to projects! The attendee will leave with a clear understanding of:
* Principles of virtualization and why it’s the answer to so many challenges we face today.
* How easy it is to secure data in the cloud using data masking features.
* The ease of connecting to the cloud and migrating environments.
* How to troubleshoot when issues arise and the tools available to diagnose issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Galileo / 270

Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone.
In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part.
This session is for you…
- if you are struggling to find enough new clients,
- if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you,
- if you feel like you are treading water when it comes to marketing.
Join this session and get started on your way to becoming a Phenomenal IT Consultant.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Nebula / 40

This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 10:30 AM - 11:30 AM

Room: Saturn / 81

In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.
We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Jupiter / 81

Sessions Found: 17
SQLSaturday