SQL Server For Developers: Because a Database Isn't Just a Dumping Ground

This T-SQL and .Net development oriented workshop will give you deeper insight, tips, tricks, and best practices of most important developer related areas of .Net and SQL server.

Mladen Prajdić is a SQL Server MVP from Slovenia and a C# and SQL Server developer for over 10 years.

He develops a popular add-in for SSMS, called SSMS Tools Packhttp://www.ssmstoolspack.com
He blogs athttp://weblogs.sqlteam.com/mladenp
And he also tweets athttps://twitter.com/MladenPrajdic

In this 300 level 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