| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:40:00 | Guy Glantser | Enterprise Database Administration Deployment | Working with Very Large Tables Like a Pro in SQL Server 2017 |
| 09:40:00 | Sebastiano Galazzo | Other | Machine Learning - Best Practices and Vulnerabilities |
| 10:50:00 | Sergio Govoni | Enterprise Database Administration Deployment | SQL Server Query Optimizer end-to-end |
| 10:50:00 | Stavros Menegos | Cloud Application Development Deployment | Design, Build, Deploy Monitor a Store on the Cloud using Azure Services as Lego blocks |
| 12:00:00 | Hugo Kornelis | Application Database Development | Hash Match, the Operator - part 1 |
| 12:00:00 | André Melancia | Enterprise Database Administration Deployment | Hacking SQL Server Is Not Enough |
| 13:45:00 | Dr. Subramani Paramasivam | Advanced Analysis Techniques | Exploiting Artificial Intelligence within Power BI |
| 13:45:00 | Hugo Kornelis | Application Database Development | Hash Match, the Operator - part 2 |
| 14:55:00 | Marcelo Fernandes | Enterprise Database Administration Deployment | Effectively Troubleshooting Latency and Failover of Always On Availability Group |
| 14:55:00 | Paul Wehland | Enterprise Database Administration Deployment | Introduction to Polybase |
Event Date: 15-06-2019 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment
The latest versions of SQL Server, including 2017, offer several new features that can make all these challenges go away. In this session we will analyze a use case involving such a large table. We will examine features such as Incremental Statistics, New Cardinality Estimation, Delayed Durability and Stretch Database, and we will apply them on our challenging table and see what happens...
Event Date: 15-06-2019 - Session time: 09:40:00 - Track: Other
For projects carrying a simple or well kown problem we can find a lot of ready-made solutions, but this extremne easy to use could be one of our best enemy when facing with specific custom problems. With this session we will cover how to apply best practices in configurin ML but much more, do we reaaly need it always? The second part will cover vulnerabilities of ML discovering how easy could be to fool a neural network by some techinques (Like pixel attack) and their implication in projects that requires no security issues.
Event Date: 15-06-2019 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-06-2019 - Session time: 10:50:00 - Track: Cloud Application Development Deployment
Furthermore, how all these can be orchestrated and programmed on Microsoft .NET Core 3.X, how to build custom API's and put all of them in action.
Event Date: 15-06-2019 - Session time: 12:00:00 - Track: Application Database Development
Hash Match is the only operator that can have either one or two inputs. It is the only operator that can either block, stream, or block partially. And it is one of just a few operators that contribute to the total memory grant of an execution plan. If you ever looked at execution plans, you will have seen this operator. And you probably have a rough idea of what it does. But do you know EXACTLY what happens when this operator is used? In this two-hour 500-level session, we will dive deep into the bowels of the operator to learn how it performs. It is going to be wild ride, so keep your hands, arms, and legs inside the conference room at all times; and please remain seated until the presenter has come to a full stop.
Event Date: 15-06-2019 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Event Date: 15-06-2019 - Session time: 13:45:00 - Track: Advanced Analysis Techniques
Event Date: 15-06-2019 - Session time: 13:45:00 - Track: Application Database Development
Hash Match is the only operator that can have either one or two inputs. It is the only operator that can either block, stream, or block partially. And it is one of just a few operators that contribute to the total memory grant of an execution plan. If you ever looked at execution plans, you will have seen this operator. And you probably have a rough idea of what it does. But do you know EXACTLY what happens when this operator is used? In this two-hour 500-level session, we will dive deep into the bowels of the operator to learn how it performs. It is going to be wild ride, so keep your hands, arms, and legs inside the conference room at all times; and please remain seated until the presenter has come to a full stop.
Event Date: 15-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment
Event Date: 15-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment
Come to this Intermediate talk to learn how you can get started using Polybase in SQL Server right away and learn about the 3 core EXTERNAL objects used in Polybase. We will compare the differences and similarities between Polybase and Linked Servers. In SQL 'Aris' (2019), Polybase will grow further and add additional connectivity and querying potential. We will take a first look at how Polybase is central to SQL 2019 Big Data Clusters. Azure Kubernetes Services makes SQL Server Big Data Clusters easy to create and deploy.