Date(s) - 05/10/2019
9:30 am - 1:30 pm
Note: This is a half day event so there will be no lunch. And therefore, you do not have to buy any lunch coupon. The event has no cost attached to it.
Data Platform Day – Schedule
|09: 30 am – 10: 30 am||Accelerated Database Recovery and Indirect Checkpoint Scalability||Accelerated database recovery greatly improves database availability, especially in the presence of long running transactions, by redesigning the SQL Server database engine recovery process. Database recovery is the process SQL Server uses for each database to start at a transactionally consistent – or clean – state. A database, with accelerated database recovery enabled, completes recovery significantly faster after a fail over or other non-clean shutdown.
Prior to SQL Server 2019, you may experience non-yielding scheduler errors when there is a database that generates a large number of dirty pages, such as tempdb. SQL Server 2019 introduces improved scalability for indirect checkpoint, which should help avoid these errors on databases that have a heavy UPDATE/INSERT workload.
|Database Administration & Development||Sanjeev Kumar (Support Engineer, Microsoft) & Mohammed Hanzala (Support Engineer, Microsoft)|
|10: 30 am – 10: 45 am||–||DataPlatformGeeks Introduction||–||–|
|10: 45 am – 11: 00 am||–||(Tea/Coffee Break)||–||–|
|11: 00 am – 12: 00 pm||DELETE Vs TRUNCATE – Myths & Misconceptions||DELETE and TRUNCATE are two commands that helps in data deletion. Even though these commands are considered to be most basic ones, still there are lot of misconceptions around them, especially TRUNCATE. TRUNCATE can’t be logged, TRUNCATE can’t be rolled back etc. In this session, we will try to debunk all the myths and misconceptions.||SQL Server 2019||Satya Ramesh (Sr. Consultant, SQLMaestros|
|12: 00 pm – 12: 15 pm||–||(Tea/Coffee Break)||–||–|
|12: 15 pm – 01: 15 pm||Machine Learning Features in SQL Server 2019||About machine learning.
Seamless integration of Development and deployment of Machine learning programs in SQL Server database.
Setup and configuration process with the sample programs on the Classification and regression programs in SQL Server-2019.
|Database Administration & Development||Srinivasa Reddy (Sr. Architect, Happiest Minds)|
|Date & Time|| 05th October 2019 (09:30 AM – 01:30 PM)
Note: Come by 9:00 AM for registration and security formalities. Please be seated by 9:30 AM.
|Venue||Prestige Ferns Galaxy (Microsoft Office)
Ground Floor, MPR1
6/18, Bellandur Gate Road, Bengaluru, Karnataka 560103
|How to Register?||Step 1: You need to become a registered member with us (DPG registration is free with loads of benefits).
Step 2: Once you become a member, Login with your credentials.
Step 3: Come back to this page using the link you received in the email. Click the “Click to Attend” button.
Step 4: You will get confirmation immediately, however, do make sure that you have also received an event booking confirmation email.
Bookings are closed for this event.