|Start Time (24h)||Speaker||Track||Title|
|10:30:00||Cláudio Silva||Enterprise Database Administration Deployment||dbatools and Power BI walked into a bar|
|10:30:00||Pedro Reis||Advanced Analysis Techniques||"DAX" the way to do it|
|11:45:00||Niko Neugebauer||Enterprise Database Administration Deployment||Batch Execution Mode on Rowstore Indexes|
|11:45:00||Dennes Torres||Analytics and Visualization||PowerBI: From Zero to Hero|
|14:00:00||Andrew Pruski||Cloud Application Development Deployment DevOps||SQL Server Kubernetes|
|14:00:00||Gabi Münster||BI Platform Architecture, Development, Administration, Information Delivery||Analysis Services - And the journey goes on...|
|15:15:00||Ivan Campos||Enterprise Database Administration Deployment||SQL Server 2019 what's new for the DBA's|
|15:15:00||Rui Romano||BI Platform Architecture, Development, Administration, Information Delivery||Feel at Home in Power BI Online|
|16:30:00||Pedro Sousa||Enterprise Database Administration Deployment||Azure Database Migration Service|
|16:30:00||Gabi Münster||BI Platform Architecture, Development, Administration, Information Delivery||Continuous Intelligence... What's This All About?|
Event Date: 23-11-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
The current DBA team/client just throws a list of instances where you should have access and want you to do magic!
Fortunately, we can leverage the dbatools PowerShell module to get a whole bunch of information that will give us a state of the art and help to answer some questions. What resources (CPU/Memory) are allocated? Which version and edition is installed? What is the size evolution of my database, filegroup or table? Do you know how many records the biggest table is growing by every day? What will a forecast tell you about your database/file group/table size in 2 months? will you need more space?
I will show how you can save the information gathered by dbatools on a central database. On top of that, how can you leverage from a couple of Power BI dashboards that I have created. This dashboard will help you answer these and other questions faster than you thought it would be possible.
Event Date: 23-11-2019 - Session time: 10:30:00 - Track: Advanced Analysis Techniques
Many times data models are configured in a way that the formulas which are applied to it are simple and fast to calculate. But with the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at the same time. And by knowing DAX, you can also plan your models in a better way just by leaving it up to DAX.
In this session you will learn:
Event Date: 23-11-2019 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
Learn with me how and when it will function, and which challenges we shall meet on the path of making our workloads work blazingly faster, while also learning which cases one should be very careful about their application and usage.
Event Date: 23-11-2019 - Session time: 11:45:00 - Track: Analytics and Visualization
Event Date: 23-11-2019 - Session time: 14:00:00 - Track: Cloud Application Development Deployment DevOps
This session will provide an overview of running SQL Server in Kubernetes, which is the leading orchestrator.
Topics covered will be: - An overview of Kubernetes. Definition of pods and services. Deploying SQL Server containers to Kubernetes. Persisting data for SQL Server in Kubernetes. An introduction to Helm Chaos engineering for SQL Server in Kubernetes using Space Invaders!
This session is aimed at SQL Server DBAs and Developers who want to learn the what, the why, and the how to run SQL Server in Kubernetes.
Event Date: 23-11-2019 - Session time: 14:00:00 - Track: BI Platform Architecture, Development, Administration, Information Delivery
Which new features are to come? Which modes are affected by changes? What does this mean in regards to strategic positioning?
Event Date: 23-11-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-11-2019 - Session time: 15:15:00 - Track: BI Platform Architecture, Development, Administration, Information Delivery
A lot of best practices and tips to be shared though the session.
Event Date: 23-11-2019 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
At this session, we discuss the several scenarios available with this tool and see some hands-on demos.
Event Date: 23-11-2019 - Session time: 16:30:00 - Track: BI Platform Architecture, Development, Administration, Information Delivery
Even in the near past, support for CI processes of BI projects was almost not there. But, the last few years brought some changes to the perception of this topic and shifted the mindset. Let's look at advantages and challenges for CI in BI and at possibilities to implement such a process for Analysis Services.