| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:10:00 | Javier Villegas | Enterprise Database Administration Deployment | Monitoring SQL Server using Community solutions (Free) |
| 10:05:00 | Taiob Ali | Enterprise Database Administration Deployment | Azure SQL Database-Business Continuity During Disaster |
| 11:05:00 | Sam Nasr | Application Database Development | SQL Server Security Features |
| 12:05:00 | John Miner | Application Database Development | How to audit and prevent unwanted user actions. |
| 13:05:00 | André Melancia | Enterprise Database Administration Deployment | Hacking SQL Server Is Not Enough |
| 14:05:00 | M A Nakib | Cloud Application Development Deployment | Azure SQL Replication |
| 15:05:00 | Mohammad Asif Waquar | Cloud Application Development Deployment | Integrate existing apps and publish blockchain ledger data to SQL using Azure Blockchain as Service |
| 16:05:00 | Deepthi Goguri | Enterprise Database Administration Deployment | Life Cycle of a Query in SQL Server |
| 17:05:00 | Mikey Bronowski | Enterprise Database Administration Deployment | Multi-server agent jobs administration with happy faces and pigeons |
| 18:05:00 | Ahsan Kabir | Enterprise Database Administration Deployment | SQL Server Internals and Tuning |
| 19:05:00 | Pio Balistoy | Enterprise Database Administration Deployment | Intelligent Query Processing Feature Family |
Event Date: 28-11-2020 - Session time: 09:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 28-11-2020 - Session time: 10:05:00 - Track: Enterprise Database Administration Deployment
While considering Azure SQL Database, two of the most critical questions you need to answer are what are my options for business continuity and how to implement these options?
In this demo intensive session, I will talk about five specific options and show you how to implement those. You will walk out of this session equipped with knowledge and scripts to implement appropriate High Availability and Disaster Recovery solutions for your Azure SQL Database.
Event Date: 28-11-2020 - Session time: 11:05:00 - Track: Application Database Development
Event Date: 28-11-2020 - Session time: 12:05:00 - Track: Application Database Development
Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
Coverage:
1 – Granting correct user access is vital. 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications. 5 – Preventing unwanted SCHEMA changes. 6 – Preventing table TRUNCATIONS. 7 – LOGIN triggers to control who, what, and when. 8 – Change data capture (CDC) an alternative to triggers. 9 - Which of these techniques apply to an Azure SQL database?
Event Date: 28-11-2020 - Session time: 13:05: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: 28-11-2020 - Session time: 14:05:00 - Track: Cloud Application Development Deployment
Event Date: 28-11-2020 - Session time: 15:05:00 - Track: Cloud Application Development Deployment
Event Date: 28-11-2020 - Session time: 16:05:00 - Track: Enterprise Database Administration Deployment
Deepthi will show you how the SQL engine thinks – enabling you to think like it!
Event Date: 28-11-2020 - Session time: 17:05:00 - Track: Enterprise Database Administration Deployment
What SQL Server and pigeons have in common? Not much, besides that you do not want to be a pigeon – pigeon post to be specific. I have been a DBA pigeon in my past. Managing hundreds of SQL Servers and visiting every single SQL Agent to setup the maintenance jobs, backup jobs or any jobs that would help me to keep the servers up and running. Sometimes using SQL scripts, other times Powershell scripts to deploy or update new jobs, but it was still the same ol’ way. Flying between instances like a bird. Until, one day, I found out about MSX and TSX! And now my life is full of happy faces! I want your face to be happy too.
In this session you will learn how easy is to setup this hidden and forgotten feature of SQL Server. Will show you
Event Date: 28-11-2020 - Session time: 18:05:00 - Track: Enterprise Database Administration Deployment
The session includes demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. Cover features specific to that version, but most of the information is relevant to SQL Server 2016 and SQL Server 2014, and some is relevant to earlier versions.
Event Date: 28-11-2020 - Session time: 19:05:00 - Track: Enterprise Database Administration Deployment