Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 44
Are you a DBA who knows nothing or very little about .NET? It's a more common than you might think, but most DBA's cringe at the thought of seeing C# code. Still, there are a lot of gems in this tried and tested toolbox. In this session, we'll cover the portions of .NET that are useful for any data professional. If you're into database development, administration, or ETL - .NET has some useful implementations that you can leverage easily.

No .NET experience is needed for this session. Basic understanding of programming concepts such as if/then logic and loops is suggested.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 07

Time: 1:15 PM - 2:15 PM

Room: 1402

You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL. 
 
In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 07

Time: 9:00 AM - 10:00 AM

Room: 1002

The Apache Spark framework can accelerate processing 100x or more on Hadoop from diverse data sources such as Cassandra, Hive, or HBase.  Using Azure’s HDInsight and Spark we’re going to look at the architecture and go step by step through examples with R and Python against public data sources.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 07

Time: 2:45 PM - 3:45 PM

Room: 1402

By now you have probably seen many Power BI demos and likely love what you see in the product.  However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try.  So what do you do when your data is not perfect or your business problem is more complex?  In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work.  This session will give you many tips on how to solve real world problems with Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 07

Time: 1:15 PM - 2:15 PM

Room: 1400

So you know the basics and fundamentals of T-SQL, what's next? Come join Mitchell in this demo heavy session as he walks through more advanced T-SQL concepts and how they can make you more efficient in your T-SQL development. Some of the items covered in this session include CTEs, Window Functions, Merge Statement, and more!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: May 07

Time: 12:00 PM - 1:00 PM

Room: 1400

Deep Learning as a general approach to image processing tasks like detection, recognition and localization have enjoyed tremendous success in recent years. However, deep learning has not yet been applied to certain ripe areas of medical imaging - specifically detecting cancer in gigabit sized scanned slides (commonly referred to as whole slide images or WSIs). In this session Matt will describe the development of an end-to-end image processing system that NLP Logix developed to automate the process of detecting WSI that contain cancer cells. The session will walk through the process of designing the system, training a deep model using TensorFlow (expect a discussion on GPUs) and call out all challenges encountered along the way.

The system developed by NLP Logix received an IEEE award for image process as part of the 2016 Grand Challenges in Biomedical Image Analysis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: May 07

Time: 4:00 PM - 5:00 PM

Room: 1402

So you have your availability groups configured and everything reports green.  How do you measure SLA compliance? Do you know when replication is delayed? Were you notified when it failed over last night?
This session will answer all these questions and more, and will show you what you should be looking at to ensure no surprises...
We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts to show what to monitor in your AG and how to setup alerting so you know when to take action.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 07

Time: 2:45 PM - 3:45 PM

Room: 1202

This session is focused on leveraging Microsoft Azure Machine Learning with stock data to build a predictive model.  This session will cover gathering and loading the data, building a predictive model, evaluating the model, publishing and using the web service for predicting stock movement.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: May 07

Time: 9:00 AM - 10:00 AM

Room: 1402

Data Warehouses and OLTP systems are different!  But there are some core concepts that we need to understand for managing and maintaining both.  Do you want to know how you can load data faster, just by setting up your database correctly?  Are your queries running slow?  Want to understand how you can reduce locking and blocking in reporting queries?  Do you have a system with views, that reference views, which reference more views?  Let's discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 07

Time: 2:45 PM - 3:45 PM

Room: 1406

How to get started in Azure-PowerBI from a DBA background.
You know SQL.  You probably have SQL installed on your own box; you’re familiar and comfortable with SSMS.  There’s all this talk of Azure.   There’s all this talk of PowerBI.  You're not sure how to start.  You're not sure where you even want to go.  You're not sure why you would use Azure...  You're not quite sure what tools you need, let alone how to tie them together.  That's why you want to come to this session.  I'll start you off with what you know...SSMS, and add tools and connections until you have filled Azure with data from SSMS and then tied Azure to PowerBI.  Along the way we'll highlight key parts of the techniques that tie all these pieces together.  At the end you'll see a PowerBI presentation sourced from Azure that you saw created from your favorite, comfortable tool...SSMS.
This set of knowledge can help you in your career planning, and if nothing else, should help you in creating a technical strategy!


Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 07

Time: 9:00 AM - 10:00 AM

Room: 1400

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 07

Time: 4:00 PM - 5:00 PM

Room: 1404

So now that your data warehouse is complete now what? In this session Chris will show you how to create your first fully functional Cube in 1 hr. In this session we will cover all of the basics including some best practices to get you up to speed when working with analysis services. This session was designed for someone with little to no experience with SSAS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 07

Time: 10:15 AM - 11:15 AM

Room: 1102

If you are a Developer or a DBA and have dynamic SQL statements in your application, you need to attend this session! In this session we will walk through a simple method to change inline dynamic SQL statements to stored procedures. This method will allow Developers and DBA’s to have reusable execution plans and the ability to more specifically tune stored procedures. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 07

Time: 12:00 PM - 1:00 PM

Room: 1404

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances.  Sometimes, it becomes important to move that data from one database to another.  SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious.  Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development.  This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 07

Time: 1:15 PM - 2:15 PM

Room: 1406

A look at the advantages of using Database Projects within Visual Studio. We'll look at partial database projects, tools for sql developers, TFS integration, DACPACs, and what happens during the build and publish steps. This will be demo heavy with a slide deck to remind you of the key points of the session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 07

Time: 12:00 PM - 1:00 PM

Room: 1402

Lets talk about Database Security Permissions Roles and I'll show you how to correctly grant the access needed to allow other to their job without risking the entire database.  I will also touch on auditing so you can prove *who did what!*  Furthermore, I'll show you some tips and tricks to getting SQL itself to accomplish task that you may not to grant access to a human.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 07

Time: 10:15 AM - 11:15 AM

Room: 1202

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 07

Time: 9:00 AM - 10:00 AM

Room: 1102

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 07

Time: 1:15 PM - 2:15 PM

Room: 1404

My technical path started at a SQL Saturday event in Jacksonville in 2010.  Today I am Microsoft Certified and working full time as a Business Intelligence Report Developer.  Sometimes it’s hard to envision the finished product of your labors when you’re in the middle of the construction mess.  And it’s hard not to become frustrated when you can’t instantly learn all the great technical stuff out there.  Well, you’re heard that Rome wasn’t built in a day, and neither will your technical studies.  Building a solid technical foundation takes time and a ‘no quit’ attitude.  If there was another way to do it, I would have found it by now!  
Three foundation bricks for your technical base:
1.	How to learn/improve T-SQL on your own?  The Best and the Cheapest Way to Learn T-SQL
2.	The Importance of the Technical Community in the learning process
3.	Finding a Mentor and being a good mentee!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 07

Time: 10:15 AM - 11:15 AM

Room: 1002

Power BI is the future of Microsoft's reporting platform. It is a powerful tool allowing users to import data, model data and create stunning reports all with very little effort. Power BI Desktop gets a lot of updates and you can be sure this session will show you the latest and greatest.  

Learn how to organize your data, create relationships and build useful calculations. Next, we will visualize the data with a variety of beautiful charts, graphs, maps and gauges. Finally, we will show you how easy it is to deploy and consume the report. It sounds like a lot of work, but you will be surprised at how quickly and easily an actionable model and report can be built. We will do it all in less than 60 minutes!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 07

Time: 12:00 PM - 1:00 PM

Room: 1102

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