Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 28
Azure Analysis Services - Why-When-How
Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. Use advanced mashup and modeling features to combine data from multiple data sources, define metrics, and secure your data in a single, trusted tabular semantic data model.
The Session will discover usage , patterns and more...
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: April 11

Time: 4:00 PM - 5:00 PM

Room: BI room

Large and versatile data sources? unstable structure? Huge volumes of free text?
In this session we will have a short overview of the tool, and the use cases it supports today. An introduction to the unique query language it uses 
Through out the entire session we will have demos for data ingestion, manipulation and query showing the tool capabilities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 11

Time: 3:00 PM - 4:00 PM

Room: Cloud room

This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 11

Time: 10:15 AM - 11:15 AM

Room: Data Engineers room

Power BI is Microsoft's industry leading data analytics discovery and visualization tool that has disrupted the way data professionals interact and derive insights from their data. It is one of the most in-demand and sought-after tools to know in today's IT career market. Join us for a fun and interactive learning opportunity to learn how to ingest, transform and visualize data from a wide variety of sources using Power BI. Learn how to create rich and interactive reports incorporating slicers, drill-down and drill-through actions. Attendees will also learn how to create, publish and share reports and dashboards for desktop and mobile consumption. Attendees will walk-away feeling like real Power BI *superstars, capable of tackling any data project in their paths! *Awesomeness may vary.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 11

Time: 11:20 AM - 12:20 PM

Room: BI room

The past years have seen the explosive growth of large-scale distributed systems, based on microservices architecture. The result is a competitive database marketplace with a huge variety of platforms for us to choose from. But how do we go about making the right choices?
This talk is mostly focused on real life examples and best practices, related to microservices solution, based on Microsoft Azure
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 11

Time: 11:20 AM - 12:20 PM

Room: Architecture room

Monitoring SQL Server is a combination of knowing what you need to monitor in your environment and how to accomplish that monitoring. For most of us, we'll need a way to detect blocking, finding long running queries, discover what filegroups need more space and which jobs failed and this is just as a start. We also need a way to capture more detail of how the system is being used at both the hardware and software level and hopefully be notified before a situation becomes critical to the overall system health. 

Gather all that information, at a constant rate and keeping it long enough to understand trends - that is a challenge that was used to be handled only by expensive tools.

Join this session to learn how Quest used the Cloud power to build Spotlight Cloud monitoring solution. A fully managed, enterprise-grade tool that can do all of the above, at a price that is affordable by organizations of any size.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (30 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 11

Time: 2:15 PM - 2:45 PM

Room: Cloud room

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 11

Time: 3:00 PM - 4:00 PM

Room: BI room

Come to this session to learn about open-sourced, extensible and collaborative modern tool that empowers data professionals to create and share documents that contain live code, visualizations and text narrations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 11

Time: 3:00 PM - 4:00 PM

Room: Architecture room

Since Profiler was set as deprecated Extended Events is becoming more and more the default tool for event capturing in SQL Server.

In this session you will see some very cool recipes for troubleshooting, such as deadlock capture, blocked process capture, page splits capture and more, besides queries to easily show the information captured by the XE session, allowing you to apply these techniques to immediately monitor your environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 11

Time: 11:20 AM - 12:20 PM

Room: Data Engineers room

Data and Analytics- Overview:
1. Why do organizations need data?
2. What is Business Analytics? 
3. Business Analytics Vs. Business Intelligence
4. Data- Trends
5. Analytics Maturity Model
6. Key Success Factors For Analytics
Business Analytics Applications
How to turn data into actionable insights:
1. Building the analytics platform
2. Analytics strategies
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: April 11

Time: 10:15 AM - 11:15 AM

Room: BI room

Peoples attention span is getting shorter! If you want to to deliver a message that sticks - GET THE THE POINT.

Join this lecture and learn practical tools to design and deliver a shorter more effective message in an authentic and memorable style.
Speaker:

Session Type:
Sponsor Session (30 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: April 11

Time: 2:15 PM - 2:45 PM

Room: Architecture room

The last couple of years have seen the emergency of "Big Data", "Cloud" and "Internet of Things". Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead. Which of course is silly. Sensible companies don't just throw money out of the window. But they need to adapt and change when new opportunities arrive. Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW. This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become relevant. And some pitfalls you need to know about along the way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 11

Time: 12:25 PM - 1:25 PM

Room: BI room

In 2017 I have session about SQL 2017 and Containers  . Customers use Always On Availability Groups to provide varying levels of HA and DR support for their SQL Server deployments across different platforms, including containers .  This session presents an view of how Docker containers work and how SQL Server runs in them. I  will cover  practical scenarios where with SQL Server and  containers how to deploy and configure a highly available SQL Server solution using Availability Groups on containers in a Kubernetes cluster as follows :

 ·         Using the Docker client
·         Exploring the Docker System
·         Customize a SQL Server Container
·         update a SQL Server Container
·         Multi-instance SQL Server using Containers
·         What’s New with SQL Server and Containers with 2019
·         Using SQL Server containers on windows  
·         Databases, Containers, and Pods: SQL Server on Kubernetes

·         SQL Server 2017 - Shared storage HA in Kubernet
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 11

Time: 4:00 PM - 5:00 PM

Room: Auditorium

Sql server is here to stay. the database in the cloud architecture or on premise is the heart of the business. SQL alone is not enough to allow us big insights from our data , insights we need in order to stay in competition. for these purposes we need data lake , we need search engines , columnar databases , predictive analytics tools etc. in this session we will discuss how we can move data in real time from our main SQL Server to the data lake , we will discuss several big data leading products such as Snowflake , Vertica , Elastic search etc and how we can integrate quickly from SQL server to these products.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 11

Time: 10:15 AM - 11:15 AM

Room: Architecture room

Once upon a time there was Oracle. Few years later DB2 and Sybase were born. Sybase gave birth to SQL Server. The world was nice and simple. But ~10 years ago all hell broke loose.
SQL, NoSQL and NewSQL; In-memory and Disk-based; Cloud and On-premises; Key-value store, Document store, Graph, Column store and Timeseries; Enterprise and Community;
We will make sense of those buzzwords, review the most popular database technologies - when they are a good fit and when they aren't and analyse typical use-cases and architectures. Last but not least - we will review few less popular technologies that are worth consideration and adoption.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 11

Time: 10:15 AM - 11:15 AM

Room: Auditorium

Elasticsearch is a data store built for addressing various data challenges using the foundations of speed, scale and relevance. It provides advanced querying, search and real-time analytics capabilities. Throughout this talk, Arthur Gimpel, Solutions Architect at Elastic, will introduce Elasticsearch and the Elastic Stack, demonstrate different use cases of using it as a main data store, or alongside with your current databases, using the polyglot persistence architectural approach.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (30 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: April 11

Time: 2:15 PM - 2:45 PM

Room: BI room

Azure SQL Database Is a PAAS service of a database. You can not install agents, Maintenance or Outages are happening without letting us know and the monitoring is hard.
Also, the servers are not available and you need to be creative to monitor it.
Azure gives us Log Analytics. And I build PS scripts and PowerBI dashboards.
In this session, i will go over those solutions and show some examples.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 11

Time: 10:15 AM - 11:15 AM

Room: Cloud room

This Azure SQL Database pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts. It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment. After attending this pre-con, you will be able to:
•	Understand how Azure SQL Database works
•	Know the newest and most important features to manage your Azure SQL Database
•	Design scalable architectures
•	Design Disaster Recovery plans
•	Manage security on your Azure SQL Database
•	Monitor and troubleshoot Azure SQL Database
•	Face a migration project
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 11

Time: 11:20 AM - 12:20 PM

Room: Cloud room

You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what?
In this pre-conference session we will analyze common use cases of poorly performing queries, such as the improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques.
The topics in this session are relevant for SQL Server versions 2005 through 2017. We will also demonstrate some of the new features introduced in the latest versions of SQL Server, such as Adaptive Query Processing. At the end of the session, you'll have a list of tips and techniques to apply in your environment.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: April 11

Time: 11:20 AM - 12:50 PM

Room: Auditorium

Need to Follow Regulation ? need to store your keys in safe place ? at this session we will learn with a step by step approach how to use Azure Key Vault to implement TDE and encryption in complex production environment,identify pitfalls and problems and how to avoid them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 11

Time: 4:00 PM - 5:00 PM

Room: Data Engineers room

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