Event Date: 14-03-2020 - Session time: 08:45:00 - Track: Admin
Event Date: 14-03-2020 - Session time: 10:05:00 - Track: Other
This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product by providing links to people and organizations who offer training and advice He has now performed this at 4 SQL Saturday's and gotten great feedback from attendees. The slide deck will contain all the links that are shown during the presentation. This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences It will also show how to make any conference more affordable and justify the benefits
Event Date: 14-03-2020 - Session time: 10:05:00 - Track: Cloud
Event Date: 14-03-2020 - Session time: 10:05:00 - Track: BI
Event Date: 14-03-2020 - Session time: 10:05:00 - Track: BI
Event Date: 14-03-2020 - Session time: 10:05:00 - Track: Admin
Event Date: 14-03-2020 - Session time: 11:20:00 - Track: Dev
Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions records and daily growth in 10s of millions, only a few minutes delay from operation store, sub second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries. Working on it, I've learned a lot of DOs and DON'Ts about columnstore indexes. Session covers how to:
Event Date: 14-03-2020 - Session time: 11:20:00 - Track: Dev
Event Date: 14-03-2020 - Session time: 11:20:00 - Track: Admin
This session will talk about an alternative to SQL Server Agent that allows us to orchestrate SQL Server environment in a more centralized manner and opens doors for advanced automation tasks, storing code in repositories and many more! Jenkins, one of the most popular DevOps tools, has a very forgiving learning curve and enables us to use thousands of community-inspired modules from one single point of entry. From Agent Jobs to Jenkins, or how to run your SQL code outside of the box.
Event Date: 14-03-2020 - Session time: 11:20:00 - Track: BI
Event Date: 14-03-2020 - Session time: 11:20:00 - Track: BI
Organizations are moving away from on-premise analytics towards shared data centers and software-as-a-service solutions hosted by platform providers such as Microsoft Azure.
The shared infrastructure of the cloud promises increased economies of scale, extreme scalability and availability, and a pay-as-you-go cost model that adapts to unpredictable usage demands.
Unfortunately, these advantages can only be captured if the software itself is able to scale elastically over the pool of commodity resources that is the cloud.
This talk will cover the journey towards Modern Cloud Analytics Solutions with Microsoft Azure.
This talk will help you understand the potential of Azure Cloud Analytics and learn about our use case and save time for future projects.
Event Date: 14-03-2020 - Session time: 12:35:00 - Track: Admin
Event Date: 14-03-2020 - Session time: 12:35:00 - Track: Admin
In this session, MVP Hamish Watson demonstrates how the noise is based on facts, and how using Redgate tools will make a huge (positive) difference to how you deploy changes to your SQL Server estate. The session is based on Hamish's experiences "in the wild" and lists all the benefits and pitfalls associated with applying DevOps principles to your database systems.
The session contains a demonstration, that is based on a real-world system. And after watching this session you will come away with practical methods of how to start your journey to DevOps brilliance.
Event Date: 14-03-2020 - Session time: 12:35:00 - Track: Admin
Event Date: 14-03-2020 - Session time: 12:35:00 - Track: Cloud
But just sitting on a patch of oil does not make one rich. The oil needs to be drilled, extracted, refined and ultimately sold. Same with data. Getting the right data in the hands of the right people in a timely manner seems to be more of a challenge than most organizations realize, and the reason for that is the limitations imposed by legacy on-premises and cloud v1.0 data warehouses. Snowflake is a Modern Cloud Data Platform, rooted in the cloud, freeing you from those shackles and allowing you to use your data more efficiently, rather than spending all your time managing the underlying infrastructure and costs. Come listen how Snowflake has enabled thousands of customers to make better, faster decisions, save money and discover new ways to use data! As a bonus, come learn how Snowflake enables customers to share relevant data in a modern, low-calorie way!
Event Date: 14-03-2020 - Session time: 13:30:00 - Track: Admin
During this basic session we will explore the features that differentiate XE from trace, with a focus on new features that have been recently released. After this session you’ll be comfortable creating your own XE sessions and will know when you use XE when to use profiler or when it doesn’t matter.
Event Date: 14-03-2020 - Session time: 13:30:00 - Track: BI
In this session Ken will provide some simple M tricks to do amazing things. Building a calendar table in seconds, numbering grouped rows, and speeding up a table with a little buffer action.
Event Date: 14-03-2020 - Session time: 13:30:00 - Track: BI
To demonstrate such an approach, I build an Excel file describing US census data that has more than 300 columns of fixed width data. After demonstrating how this file communicates to business users, I will generate an SSIS package from that metadata using BIML Script. Then I will also look at how you can generate a SQL Server bulk insert format file from the same metadata. A small amount of C# code can generate quite a large extract.
Event Date: 14-03-2020 - Session time: 13:30:00 - Track: Dev
TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.
In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery.
A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code
Event Date: 14-03-2020 - Session time: 13:30:00 - Track: Cloud
Event Date: 14-03-2020 - Session time: 14:45:00 - Track: BI
Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the users location when a button is pressed. The Microsoft Flow we create in this session will take the location and user information and write it to an Excel file. We will also look at a custom connector in Flow that will allow us to refresh a Power BI data set. In the Power BI report we will create we will connect to an Excel file with the location information in it and display it in a report including the location on a map.
The audience will take away useful information about Power Apps, Flow and Power BI including all the code used.
Event Date: 14-03-2020 - Session time: 14:45:00 - Track: Admin
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
Event Date: 14-03-2020 - Session time: 14:45:00 - Track: BI
Data scientists should use the strategic management process to achieve strategic competitiveness and help the company achieve above-average returns. Strategic competitiveness on BI and Data Analytics is achieved when data scientists teams develop and implement a value-creating strategy at work. Those making strategic decisions must adopt a different mind-set, one that allows them to learn how to complete in highly turbulent and chaotic environments that produce a great deal of uncertainty. The effectiveness of the strategic management process at every level is increased when it is grounded in ethical intentions and behaviors. Managing core competence (capability that is valuable, rare and costly to imitate) requires careful analysis of the company's resources and capabilities in their data scientist team. The knowledge of the company's human capital possesses is among the most significant o
Event Date: 14-03-2020 - Session time: 14:45:00 - Track: Admin
Join me on an exploration of what it means to be a DBA in the modern era, and how your existing skills can be leveraged, no matter the platform. Maintenance plans, monitoring, even disaster recovery all work in pretty much the same way across Windows, Linux, Azure SQL DB, and containers.
Then when you go back to work on Monday, you will have a starting point on how to modernize your existing environment and future-proof your career.
Event Date: 14-03-2020 - Session time: 14:45:00 - Track: Admin