Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 43
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:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 05

Time: 11:45 AM - 12:45 PM

Room: 51-1209 (Prof Dev)

This session is a talk on data and transaction log files; performance and best practices. How many databases have you come across where SQL Server was installed with all the default settings and wonder why performance is poor?  We will discuss the defaults that affects SQL data files and how they ruin database performance. We will look at best practices, things to watch out for, and undoing the damage.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 05

Time: 1:00 PM - 2:00 PM

Room: 51-1102 (DBA)

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:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: May 05

Time: 9:00 AM - 10:00 AM

Room: 4-1705 (Data Science / Visualization)

In this session, we will explore all the various ways to pivot into the data science field. We will go over some common scenarios, and will inspect different pieces of advice found on the Internet.
Speaker:

Accompanying Materials:

Session Type:
Lightning Talk (15 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 05

Time: 2:15 PM - 2:30 PM

Room: 51-1101 (Dev)

Over the past few decades, mobile devices have become incredibly important to the way we communicate, play and do business. In 2017, the time spent per day on mobile devices has reach a new record high of 3 hours and 15 minutes per day. With this much time on-the-go, it’s necessary to have your data right there with you. 

In this session, you will learn how to design Power BI reports optimized for mobile devices and learn the ins and outs of the Power BI mobile app.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: May 05

Time: 3:45 PM - 4:45 PM

Room: 4-1705 (Data Science / Visualization)

In this 60 minute interactive workshop, attendees are given the knowledge & tools to take charge of their listening skills & to improve the quality of their communication with other professionals. Ever have trouble getting the right message across to your co-workers or clients? This topic deals with the ways we communicate – accurately and inaccurately – and includes 2 interactive elements: table exercise about voice inflection called “Really? REALLY?!” & volunteer activity called the “Alien Press Conference” – a hilarious take on verbal & non-verbal cues. Other topics include: Challenges of Communicating; Listening to Understand, Not Respond; 7 Stages of Communication; Verbal vs Nonverbal Cues; Tone is Everything; 5 Ways to Change Your Listening Habits Now; and more. Attendees will learn: 
•	How to control their voice tone and inflection to improve their message delivery;
•	How to develop and improve their active listening skills;
•	How to use non-verbal cues to their advantage; more
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: May 05

Time: 10:15 AM - 11:15 AM

Room: 51-1209 (Prof Dev)

WIll present a sample business intelligence/analytics application of cloud technologies such as Azure Sql Server Analysis Services, Power BI and Azure Machine Learning and how it all works together.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: May 05

Time: 3:45 PM - 4:45 PM

Room: 4-1704 (Azure)

Creating Your Personal Brand & Behind the Staffing Curtain
I will share my experience over the years in Staffing to provide some tips and tricks to help the community.  I will discuss online presence, personal branding, selecting a staffing vendor, resume tips and tricks, nailing a technical interview, industry trends and anything else that may come up!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: May 05

Time: 3:45 PM - 4:45 PM

Room: 51-1209 (Prof Dev)

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 05

Time: 3:45 PM - 4:45 PM

Room: 51-1205 (Intro to DBA)

Dataset to Deployment (to Azure!!?) in one session, seriously?  Well, it depends.  Sixty minutes is not enough time to become an expert on how to create a dataset, develop a report with SQL Server Data Tools (SSDT) and deploy the report to a Report Server in Azure; but you can become familiar with the SSRS components and the report deployment process.  Whether you are new to 2016 SSRS or have some SSRS experience, there’s something to learn for everyone.  
In ‘Dataset’, we’ll talk about different options and ideas to create a good dataset.  Then in ‘Develop’, we’ll look at the various components inside SSDT; building a report along the way.  In ‘Deploy’, we’ll walk through the steps to configuration and deploy the report to a Report Server sitting on a VM in Azure.   Yes, Azure! 
By the end of the session, you will be more familiar with the SSDT environment and the report deployment process.  You won’t be a pro after this one session, but you will definitely be on your way!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 05

Time: 2:15 PM - 3:15 PM

Room: 4-1705 (Data Science / Visualization)

Have you ever encountered harassment at work? Me, too.
In your workplace, what would you do if someone was choking?  If their clothes were on fire?  Statistically, you are far more likely to witness harassment. Do you know what to do?
Bystanders have unique power to resolve harassment and restore respect in the workplace. Uncertainty is the biggest reason Bystanders don't take action. Vagueness about what action to take, and when. Indecision about when and what action is warranted. Even doubt about the role Bystanders should play.
In this session you will:
* Bystander will cultivate an awareness about workplace harassment.
* Bystander will learn to employ to observations and interpretation of cues and clues  to workplace harassment.
* Bystander will apply measured steps to develop a plan of action/response  in the face of workplace harassment.
* Bystander will confidently take action using moral courage and candid  conversation to restore respect and resolve workplace harassment.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 05

Time: 2:15 PM - 3:45 PM

Room: 51-1209 (Prof Dev)

-- analyse database Sql Server configuration: Degree of parallelism and Cost threshold of parallelism, TempDB, disks latency
-- analyse databases configuration
-- maintenance plans: what works best
-- index maintenance: rebuild or reorg
-- Statistics maintenance
-- new indexes? Duplicate Indexes? We got it
-- slow sprocs? slow queries? we will give them a new life
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 05

Time: 10:15 AM - 11:15 AM

Room: 51-1103 (Features)

SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.

The participant will learn:
1. The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
2. How to install, maintain and backup SQL Server on Ubuntu Linux systems 
3. Several useful Linux commands to monitor/manage SQL Server
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 05

Time: 9:00 AM - 10:00 AM

Room: 51-1103 (Features)

Every few months the headlines are filled with news of yet another system outage inconveniencing customers and users. As data platform professionals, the systems and servers for which we are responsible generally form the foundation of our companies’ customer-facing applications. In this fast-paced session, we’ll discuss the differences between high availability and disaster recovery as well as the tools and technologies Microsoft provides us within SQL Server to keep our databases up, our users happy, and our DBAs well rested.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 05

Time: 2:15 PM - 3:15 PM

Room: 51-1205 (Intro to DBA)

Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes.  

In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 05

Time: 10:15 AM - 11:15 AM

Room: 51-1205 (Intro to DBA)

Azure Data Factory (ADF) has long been a service that confused the masses. With pipelines, data sets, availability schedules, and JSON littering the code based environment it was no wonder the learning curve was steep. With the introduction of Azure Data Factory Version 2 that has all changed. The environment is simplified, scheduling is easily understood, pipelines are more straightforward, and there is more functionality now than ever before. Data Factory now feels like a true cloud-born ETL tool for everyone who is already familiar with SSIS. As a bonus, the lift-and-shift story has never been easier as SSIS packages can now be run natively in ADF. 

 In this session, Brad will walk through the major features including creating the environment, authoring your first pipeline, scheduling, monitoring, deploying SSIS packages, and interacting with on-prem data sets. At the end of this session, you will be ready to orchestrate data movement with Azure Data Factory like a pro!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 05

Time: 3:45 PM - 4:45 PM

Room: 4-1706 (Warehousing)

When database servers slow down the options are generally to tune or scale up. Massively Parallel Processing, or MPP, databases offer an alternative: scale out. A traditional database engine uses a single processor and memory space to process queries while an MPP engine will divide and conquer by spreading the workload across multiple servers resulting in increased query performance. MPP databases don't operate the exact same as a traditional database engine. In this session Brad will explore the similarities and difference of operating in an MPP environment, dive into distribution theory, discuss join and aggregation compatibility, and get you up to speed on all the basics of MPP theory. By the end of the session you'll be well positioned to understand the design pattern differences, ETL considerations, and query basics of MPP databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 05

Time: 1:00 PM - 2:00 PM

Room: 51-1103 (Features)

Introductory session on Azure machine learning, overview and practical demo.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: May 05

Time: 2:15 PM - 3:15 PM

Room: 4-1704 (Azure)

What is this “Azure SQL Database” that I keep hearing about? In this session we will start from the beginning and answer the big questions around what it is, how you use it, how much does it cost, and most importantly why you would and should use it in your particular environment/situation.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 05

Time: 9:00 AM - 10:00 AM

Room: 4-1704 (Azure)

This session will provide an introductory into failover clustering of SQL Server, including when and why to cluster SQL.  We will cover the required components and walk through how clustering works behind the scenes
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 05

Time: 9:00 AM - 10:00 AM

Room: 51-1102 (DBA)

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