Event Date: 07-03-2020 - Session time: 09:45:00 - Track: Analytics
After some usage, users have reacted that it's a bit sluggish in usage, and they're not keen on using it anymore.
Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your report, and take actions on these insights.
With the myriad of root causes that are out there, an elimination approach might suit us very well. Some of the main causes will be explained, and we'll get you going on how you can fix it for yourselves.
Be it DAX-measures, modelling issues, or an overload of visuals. Every report can be tuned to handle like a dream, and you can do it too!
Event Date: 07-03-2020 - Session time: 09:45:00 - Track: Administration
Topics to discuss: Backup, Recovery, Shrink, VLF, Replication, AlwaysOn, Best Practices.
Event Date: 07-03-2020 - Session time: 09:45:00 - Track: Developer
All these topics I will explain in the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.
Event Date: 07-03-2020 - Session time: 11:00:00 - Track: Administration
In this demo heavy session we will show how Containers along with Azure DevOps can work for your CI/CD pipeline.
You will leave this session with the knowledge and ability to start creating your own bespoke SQL Server on Linux development / testing environments with automated image builds and releasing to Azure Kubernetes Service (AKS) along with some of the issues / pitfalls of doing so.
Pre-Requisite: To get the most out of this session a basic understanding of what Docker/Containers are, is recommended.
Event Date: 07-03-2020 - Session time: 11:00:00 - Track: Developer
Event Date: 07-03-2020 - Session time: 11:00:00 - Track: Analytics
Event Date: 07-03-2020 - Session time: 13:00:00 - Track: Administration
Event Date: 07-03-2020 - Session time: 13:00:00 - Track: Developer
Event Date: 07-03-2020 - Session time: 14:15:00 - Track: Analytics
Azure Data Factory is a cloud-based ETL tool, allowing data to be copied from on-premises as well as cloud based locations. Transformations can be hand-coded, but recently Microsoft added data flows to the product, which allow you to do data transformations without the need to write custom code. In this session you will see the product in action and learn how to get started building your own flows.
Event Date: 07-03-2020 - Session time: 14:15:00 - Track: Developer
Come to this session and figure out how Intelligent Query Processing (IQP) works and adapts to any type of workload with no application changes required.
Event Date: 07-03-2020 - Session time: 14:15:00 - Track: Administration
What is it? Why would I want to use this over Management Studio? Can I use it instead of Management Studio? Martin will answer these questions – and more – and share with you what happened when as a DBA/Database professional he tried to exclusively use this instead of SSMS. A month’s work of expertise to be shared in 60 minutes, detailing all the caveats and clever tricks needed to avoid pulling his hair out on a daily basis.
Event Date: 07-03-2020 - Session time: 15:30:00 - Track: Developer
Event Date: 07-03-2020 - Session time: 15:30:00 - Track: Administration
SQL Server licensing is a complex beast. It is not always transparent and straight forward to understand what licensing you need. In this session, we will look at how you best license your SQL Servers to get the best return on investment. We will discuss •What SQL Server editions you need to license •SQL Server and software assurance – why you might need both •How can you buy your licenses? o On-premises o Cloud •Licensing models o Core-based o Server+CAL •How to license SQL Server in a virtual environment •Licensing scenarios o High availability o Application mobility o Non-production o SQL Server on containers
Event Date: 07-03-2020 - Session time: 15:30:00 - Track: Analytics
Fast forward 6 months, there is more traction within the business, training is given and workshops are held. The adoption of Power BI is growing. Some departments already use Power BI very extensively and incorporate it in their day-to-day processes. Due to this quick success there is uncertainty regarding the right support team for incidents and problems. Because an app workspace creates an Office 365 group with a lot of artifacts behind the scenes, the creation workflow is controlled by IT. Unfortunately this inhibits the end users. We require more governance, not to further bother the users, but it is essential to stay in control. Responsibilities need to be better aligned between IT and the business. Throughout this session we take you along on our Power BI journey, with tips, tricks, do's and don'ts during the implementation of Power BI (Premium).