Session room

The Agenda

Agenda Home

SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.

2024 Training Days

Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.

  • 08:00 Registration opens and breakfast served.

  • All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
  • All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
  • No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.

SQL Server For Developers: Database is no dumping ground!

Description

In this pre-conference session we'll go over what every developer dealing with SQL Server and .Net has to know to be as effective and productive as possible. Because speed is important too, we'll also focus on areas where you as a developer can contribute most. We'll cover:
  • Basic normal forms, data structures and data types make you understand why the database is designed the way it is
  • The query optimizer, workers and threads show us how the query actually gets executed inside the engine
  • Isolation levels and locking provide us with knowledge about concurrency and blocking issues
  • Having fun with T-SQL tips and tricks will teach you to write better queries. Diving into the .Net SqlClient will teach you some interesting database access features to make your programming easier
  • Saving the best for last, we'll look at a few attack vectors that can be used against your company, not only focusing on SQL Server,and what you as a developer can and should do to protect against them
Even if you are a seasoned developer you are going to learn something in this session.

Learning Objectives

Previous Experience

Tech Covered