SQL Server For Developers: Database is no dumping ground!

2015

TL; DR

Come to this all day session to learn everything you as a developer need to know about SQL Server. We'll look at structuring data, isolation levels and attack vectors to name just a few things.

Session Details

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.

3 things you'll get out of this session

Mladen Prajdic's previous sessions

Social Engineering: Hacking People

The best attacks happen when people don’t even realize they are being attacked and in this session we’re going to try to fix that and educate you on how to realize when someone is trying to socially engineer you.

Thē wönderfűl wôrld of ćollåtions, eñcodingß and téxt sţoræge

Once you get to talking or thinking about characters, collations, encodings, sort orders, diacritics, code pages, etc, a brain melt is what you end up with. In this session we'll look at what all of these things are, how they all fit together.

Getting To Know SQL Server Encryption Capabilities

How to increase security by using symmetric and asymmetric server encryption, client side Always Encrypted, secure SSL/TLS channels and Transparent Data Encryption for data at rest.

An End-to-End Approach to App and DB Security

Learn about the methodology to increase security related development practices, backed by real world examples. Including securely accessing a database, properly encrypting data, using SSL/TLS, etc

Think Inside the Box! Understanding the Query Life Cycle

In this session we'll take two queries, a read and a write one, and look at the whole trip from the client through the server and back to the client. On this journey we'll try to identify where things might go wrong.

Optimizing database access and diving into .Net SqlClient

Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader()

From SQL Traces to Extended Events. The next big switch

This session will give you insight into both of the current tracing technologies in SQL Server. Old SQL Trace has served us well but new times call for new technology. The new Extended Events are a new lightweight tracing mechanism built into SQLOS.

Awesome new T-SQL candy in SQL Server 2012

We'll focus on the awesome new SQL Server 2012 stuff that will make your T-SQL development a breeze. We'll look at new stuff like OFFSET, WINDOWING FUNCTIONS, SEQUENCES, ERROR HANDLING, FORMAT & CONVERT functions and METADATA DISCOVERY.

Database Testing-Minimizing "If it can break, it will."

A look into the world of database testing, how to go about it, why do we really need it and how to work well with your peers and managers for greater project success.