What we're about
Upcoming events (1)
Microsoft Data Platform Group Birmingham - Thursday 3rd December 2020, 7:00pm *** Registration on MeetUp required to gain access to remote link! *** ***This is using GoToWebinar! *** Session: On Transactions and Atomic Operations Agenda 6:30pm – 7:00pm Setup and Join 7.00pm - 7.15pm - Understanding the Statistics in SQL Server - Lightning Talk with Deepthi Goguri 7:15pm - 8:30pm - On Transactions and Atomic Operations with Gail Shaw If there’s one thing that we, as SQL developers don’t do, it’s use transactions as often as we should. Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie. 1) Understand what transactions are and what they do. 2) Learn how to use transactions in combination with error handling to roll back changes on errors 3) Learn how transactions affect logging and locking. Venue Wherever you have access to Computer or Smart Device! This session will be online only! Other Details The link to GoToWebinar will be made available prior to the event and will be open from 6:30pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help. Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] Reiss McSporran Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss) Email: [masked] Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Main Speaker Profile Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail is a Data Platform MVP, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQL Saturdays locally and internationally, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related. She lives in Johannesburg, South Africa. Sponsors RP Analytics recruitment Ricoh Purple Frog handle the organisation.