22-25 April 2026 
SQLBits 2012
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.
SQL Server 2012 brings a whole bag of new features. We'll focus on the awesome new stuff that will make your T-SQL development a breeze.
How did you do your paging so far? Got mad at the lack of proper support? Not any longer! Now there's OFFSET to help you with that
Remember when you had to do those running totals with CLR, subqueries, quirky updates or (GASP!) cursors?No more! Enter the new WINDOWING FUNCTIONS that offer a simple solution to that problem and a bunch of new possibilities.
Ever had identity problems? Let me show you the power of new SEQUENCES!
But wait, there's more! We'll even take a look at the upgraded ERROR HANDLING, new FORMATTING and CONVERTING functions, awesome METADATA DISCOVERY and more.
How did you do your paging so far? Got mad at the lack of proper support? Not any longer! Now there's OFFSET to help you with that
Remember when you had to do those running totals with CLR, subqueries, quirky updates or (GASP!) cursors?No more! Enter the new WINDOWING FUNCTIONS that offer a simple solution to that problem and a bunch of new possibilities.
Ever had identity problems? Let me show you the power of new SEQUENCES!
But wait, there's more! We'll even take a look at the upgraded ERROR HANDLING, new FORMATTING and CONVERTING functions, awesome METADATA DISCOVERY and more.
Speakers
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.