Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type



Sessions Found: 52
Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/Dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged…  we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Technical Session by a Sponsor (60 minutes)

Track:
Technical Vendor Session

Level: Beginner

Session Code:

Date: April 21

Time: 10:20 AM - 11:20 AM

Room: K

Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it may take considerable time to gather the information you will need.
In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 21

Time: 2:10 PM - 3:10 PM

Room: A

TBD
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 21

Time: 11:40 AM - 12:40 PM

Room: D

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 21

Time: 2:15 PM - 3:15 PM

Room: D

Azure SQL Data Warehouse - Migrate on-premises to cloud: How to and Best Practice 
We will discuss what is Azure SQL DW and ways to build it and migrate to it.  Azure SQL DW is a SQL-based, fully managed, petabyte-scale cloud data warehouse, that is highly elastic and enables you to set up in minutes and scale capacity in seconds.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 21

Time: 10:10 AM - 11:10 AM

Room: E

With so many new technologies it can get confusing on the best approach to building a big data architecture.  The data lake is a great new concept, usually built in Hadoop, but what exactly is it and how does it fit in?  In this presentation I’ll discuss the four most common patterns in big data production implementations, the top-down vs bottoms-up approach to analytics, and how you can use a data lake and a RDBMS data warehouse together.  We will go into detail on the characteristics of a data lake and its benefits, and how you still need to perform the same data governance tasks in a data lake as you do in a data warehouse.  Come to this presentation to make sure your data lake does not turn into a data swamp!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 21

Time: 11:30 AM - 12:30 PM

Room: C

Has your company been building data warehouses for years using SQL Server?  And are you now tasked with creating or moving your data warehouse to the cloud and modernizing it to support “Big Data”?  What technologies and tools should use?  That is what this presentation will help you answer.  First we will level-set what big data is and other definitions, cover questions to ask to help decide which technologies to use, go over the new technologies to choose from, and then compare the pros and cons of the technologies.  Finally we will show you common big data architecture solutions and help you to answer questions such as: Where do I store the data?  Should I use a data lake?  Do I still need a cube?  Do I need the power of MPP?  Should I build a "logical data warehouse"?  And we'll close with showing some architectures of real-world customer big data solutions.  Come to this session to get started down the path to making the proper technology choices in moving to the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 21

Time: 3:35 PM - 4:35 PM

Room: D

Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or whether or not a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? The answer is baseline metrics.

Only if you have baseline performance information can you answer these questions and form a plan to address the issues at hand. In this session, we will be discussing several open source tools you can combine into an inexpensive baselining system you can use to troubleshoot issues and answer important questions.

Attendees in this session will learn how to collect important metric data, what data to collect, and how to interpret that data and develop a plan of action to address any issues.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 21

Time: 11:50 AM - 12:50 PM

Room: H

With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 21

Time: 2:10 PM - 3:10 PM

Room: B

With system implementation and data sourcing being more widely distributed than ever, from on premise to cloud and cloud services to self-service BI, challenges to manage your enterprise data has only grown exponentially harder.  We will review options and scenarios for implementing Master Data Management (MDM), and discuss how a Data Governance framework to support the entire process becomes very critical to the success of your business.  We will look at design patterns available to support your MDM effort, tools, such as SQL Server Master Data Services, and the setup of the organization oversight as an integral part of the overall picture.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 21

Time: 2:20 PM - 3:20 PM

Room: H

There are many Data Platform offerings available on Azure and new ones are introduced regularly and evolved. In this session we will cover various offering and what scenarios are most suitable for. We will also discuss whether it makes sense to make use of this services or roll your own on-premise or hybrid solutions
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 21

Time: 8:50 AM - 9:50 AM

Room: H

DAX is the native formula language for Power BI and SSAS Tabular. At least, that's how most of us have experienced it.

DAX is actually a query language, with rich semantics to represent all manner of analytical queries. Join us for a deep dive into using DAX to its full potential to answer complex queries using Tabular's in-memory model for lightning speed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Advanced

Session Code:

Date: April 21

Time: 10:00 AM - 11:00 AM

Room: C

We will discuss all details of deploying SQL Server 2016 AlwasyOn on Google Cloud in real life.  There are already white paper and google official document on creating AlwaysOn. However those are not ready for real production environment. I will show you all missing parts to deploy in real life on GCP
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 21

Time: 8:30 AM - 9:30 AM

Room: A

Automation and configuration management are essential tools in the belt of all IT practitioners.  In this session you'll learn about Microsoft's Desired State Configuration tool, and how you can leverage it to automagically deploy SQL Server in a consistent and repeatable way.  You'll also see how DSC can be used to make changes or correct the dreaded configuration drift.

There will be demos! No death by PowerPoint.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 21

Time: 8:40 AM - 9:40 AM

Room: G

How outsource administrative tasks to your end user groups in a safe, secure, and repeatable pattern.   Now you no longer have to pause and stop what you are doing to create that new login, and replicate it to your Disaster Recovery.   You do not have to stop and perform a backup/restore to refresh the development environment.  Empower your end users, let them do this on their own without compromising your security.

There will be a demo!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 21

Time: 3:35 PM - 4:35 PM

Room: E

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?

This presentation will review the following techniques to fix your woes.

Coverage:

1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: April 21

Time: 8:40 AM - 9:40 AM

Room: D

There's no doubt about it, being an entrepreneur can be very rewarding. However, it is far from easy. So, before you embark on that journey, you have to ask yourself if this is the right thing for you to do. But, how do you know?

Attend this inspiring session by Prof Joe Wehr of the MCCC and discover the good and the bad of becoming an entrepreneur. 

This includes the things everyone needs to know, like
- how to strategize and create a business plan
- how to secure financing
- what to look out for before hiring (hiring mistakes are very costly)

And the less obvious, including
- knowing when and how to get out (retirement, anybody?)
- the not so subtle difference between a consultant and an entrepreneur (this is an eye-opener)
- how to legally extend the reach of your cash (ever heard of multitasking your money?)

If you have been thinking about “it” but aren't sure if you're ready, you need to attend this session. You might be surprised what you learn about yourself.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 21

Time: 10:10 AM - 11:10 AM

Room: D

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately, the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 21

Time: 11:50 AM - 12:50 PM

Room: I

No need to be afraid of availability groups.  No more multi-subnet clusters.  Use DAG to implement cross cluster replication.  Learn how to expand your replication using the distributed availability groups using virtual and physical servers.  Configure solutions to provide high availability and disaster recovery to any degree.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 21

Time: 11:30 AM - 12:30 PM

Room: A

Take advantage of Python-based analytics in SQL Server 2017. This session will cover setting up Python Machine Learning in SQL Server 2017 and exploring data models through analytics using publicly available healthcare claims data. You won't need to know Python to get value from this session, but an understanding of programming will be very helpful.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: April 21

Time: 8:50 AM - 9:50 AM

Room: I

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