Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 49
Come hear these "emergency" stories called into Microsoft's SQL Server Product Support team. I'll cover common backup\restore problems, SQL Server not starting, lost data, crash dumps, and infectious SQL found on Web just to name a few.  Learn background to the problem and what was done to correct in hope of avoiding your own SQL Server emergency.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Intermedia

Session Code:

Date: December 07

Time: 2:30 PM - 3:30 PM

Room: 210B (80)

Evaluate Session

Source Control is a wonderful resource to improve team collaboration, reduce the risk of problems from lone wolf development and track change efficiently. Developers are already familiar with source control, but ANY Analysts or Operations teams can benefit! If you are struggling to use source control, are frustrated with not understanding the what, why, and how, or want to start using source control then look no further!  We will cover using source control for code in stored procedures and queries for SSMS, SSIS packages, SSAS models and cubes, and SSRS reports.

With this session, you will learn the foundational knowledge to not only to apply to your workplace right away but to lay the groundwork to continue building your skills in Git. We will cover basic terms/concepts of how Git works, understanding the process flow, executing some basic commands in Git, understanding why a merge conflict happens and how to solve it, and using different GUIs if the command line isn't your thing.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 07

Time: 1:30 PM - 2:30 PM

Room: 210B (80)

Evaluate Session

Are you a developer or analyst who has been asked what changed for a particular record, and thus need to get the record at a given time? Well, in 2016, we were introduced to system-versioned temporal tables in SQL Server, which can tell you the full history of what the data looked like if you ever need to fend off questions. You will get to know the business uses for temporal tables, how they are built, the ways to query temporal table records, converting your current in-memory tables, and other elements to consider.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 07

Time: 3:30 PM - 4:30 PM

Room: 112A (60)

Evaluate Session

Aggregations are one of the most important optimization methods for managing big datasets in Power
BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by
answering high level analytical queries quickly from memory while sending more detailed queries back
to the source database.
In this session, you will learn about the concept of aggregations, different table storage modes in Power
BI, how to set up aggregation tables and configure them to improve query performance. You will also
learn how to use DAX Studio to determine if the aggregations are being used.
Prerequisite: Basic knowledge of data modeling in Power BI Desktop.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: December 07

Time: 9:30 AM - 10:30 AM

Room: 112A (60)

Evaluate Session

As containers are becoming more and more prevalent, this session provides an introduction to the different options of running containers in Azure. 

I'll cover the following different options for running Docker containers in Azure: -
Azure Container Registry
Azure Container Instances 
Azure Kubernetes Services

This session is aimed at SQL Server DBAs and Developers who have some experience with Docker  and want to know the different options that are available in Azure. 

Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: December 07

Time: 11:30 AM - 12:30 PM

Room: 112B (60)

Evaluate Session

Stop wasting time using Excel Pivot Tables. Create Pivot Tables in SQL with ease.

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris.
*Not Possible
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 07

Time: 10:30 AM - 11:30 AM

Room: 210B (80)

Evaluate Session

Azure Machine Learning services is an integrated, end-to-end data science and advanced analytics solution that provides professional data scientists and data engineers with tools not only to develop ML models, but also tools for data preparation and wrangling, data visualization, model deployment, and model management at cloud scale. This session will teach the attendees how to get their hands on each tool in the stack.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: December 07

Time: 1:30 PM - 2:30 PM

Room: 112B (60)

Evaluate Session

Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to leverage the learning curve in Microsoft Data Platform, based on my knowledge and experience,  the proven strategies and techniques.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 07

Time: 11:30 AM - 12:30 PM

Room: 208 (50)

Evaluate Session

Are you thinking of converting your large databases from traditional row store tables to Column Store?  If so then you will want to attend this session. We will discuss some important lessons learned from actual deployments of CCI into production and highlight some key areas you want to focus on ahead of time. There are often many ways you can do things but getting it right the first time is crucial with CCI conversions on large scale databases. Come see what these are before it's too late.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 07

Time: 2:30 PM - 3:30 PM

Room: 112B (60)

Evaluate Session

Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way? In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 07

Time: 1:30 PM - 2:30 PM

Room: 113

Evaluate Session

Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption?
The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues.
Highlight of topics
1.	Why corruption occurs?
2.	Detecting corruption – how SQL Servers detects corruption at the page level.
3.	Different types of corruption- e.g. False alarms, memory corruption etc.
4.	Limitation of DBCC & how to speed the DBCC process.
5.	Undocumented DBCC commands.
6.	Monitoring I/O errors.
7.	Verifying backup for corruption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 07

Time: 11:30 AM - 12:30 PM

Room: 210A (60)

Evaluate Session

All kind of things can be done for improving query performance and IOPS (IO operations), however what if your hardware and disk drives were not properly configure to give SQL the best performance.  This session review the basics of disk drives, partitions, controllers and storage hardware and then looks into ways to improve SQL performance with correct  disk drive architecture.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: December 07

Time: 9:30 AM - 10:30 AM

Room: 210A (60)

Evaluate Session

This session will show attendees a way to dynamically ingest data into a centralized data store (i.e. SQL Server or Data Lake) using Azure Data Factory from multiple sources.  If going into SQL Server the processes will automatically create all needed tables and stored procedures for the process.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 07

Time: 3:30 PM - 4:30 PM

Room: 111 (60)

Evaluate Session

Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt?  What else can you do to protect your sensitive data?
 
In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings.  This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.   
 
You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance.  Also, you will gather information on how to fully protect and review your sensitive data usage.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 07

Time: 11:30 AM - 12:30 PM

Room: 111 (60)

Evaluate Session

Turbo charge your career, your projects, and your team by changing the way you approach failure, learning, practice, and praise.   This session will cover research in cognitive psychology and neuroscience in an actionable path forward to eliminate perfectionism and other career-stifling behaviors and thoughts, which those of us in the tech industry are particularly susceptible to.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 07

Time: 3:30 PM - 4:30 PM

Room: 210A (60)

Evaluate Session

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. Cloud providers are democratizing technologies and techniques that were complicated and proprietary just a few months ago. This presentation walks you through how a silly idea from a football podcast got me thinking about how Azure Logic Apps, the Cognitive Services API, Azure SQL DB, and Power BI 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 (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: December 07

Time: 10:30 AM - 11:30 AM

Room: 112B (60)

Evaluate Session

Using SentryOne Plan Explorer, a 100% free product, DBAs and Devs write better performing SQL code in a fraction of the time otherwise possible. Plus, troubleshooting existing SQL code becomes a fast, easy, and visually vibrant experience. Learn all the ways SentryOne Plan Explorer helps in this demo-packed session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Vendor Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 07

Time: 12:30 PM - 1:15 PM

Room: 210A (60)

Evaluate Session

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization or embed them in your app or website. This session is for users are who want to automate Power BI row-level security by replicating the security of another data source such as corporate ERP. Many organizations maintain tight data security within their organization. Row-level security needs to be defined within Power BI. This can be difficult if you have many users and security changes happen quite often. If you are using a corporate ERP system that has security built into it, you would end up doing redundant work of managing security at two places, in ERP as well as in Power BI. DAX query can be used to filter out rows based on user ID/user name. We will go over the demo of the entire process starting from bringing data into SSAS, creating data model, applying row level security & publish the report. Never again you will have to manually manage roles within Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: December 07

Time: 3:30 PM - 4:30 PM

Room: 112B (60)

Evaluate Session

Curious how to monitor your IT Services using Power BI? Come see how UCF tracks our IT services to ensure our staff, students, and faculty are meeting their teaching, learning, research, and service objectives. Utilizing ITIL (Information Technology Infrastructure Library) practices, ServiceNow data, and Power BI we are able to take quantitative information and turn it into graphical visualizations to aid leadership and our customers in making informed decisions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: December 07

Time: 3:30 PM - 4:30 PM

Room: 208 (50)

Evaluate Session

Applications often integrate with APIs for the purpose of retrieving data from a disk-based storage system like SQL Server. This poses challenges due slow queries and amount of data sent down the wire. In this presentation, we discuss the performance concerns with this type of architecture especially for big data scenarios.  Oscar Garcia shows how to address those concerns by following a series of steps in which an application is refactored with minimum changes to support an in-memory data store and data streaming.  We start by discussing the challenges when using data queries. We structure the data for in in-memory storage. We replace the API requests with real-time data streaming.

Learning Objectives:

SQL Server Query Challenges

Redis Cache Basic Operations and Structure

Angular App with Socket.io integration

Node.js Backend with Socket.io and Redis support

Real-time data integration
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 07

Time: 1:30 PM - 2:30 PM

Room: 112A (60)

Evaluate Session

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