Evening Session

We are going to have a Fun evening planned for you who have atteneded the conference or are just coming in for the evening session, with a Experts Panel with a lot of the presenters from the day’s conference taking part to answer those burning questions (wonder if we can stump them) that you bring Some fun with our […]

Read more

Encryption in SQL Server in AD 2016 | 300

Imagine that ‘Moment’, when you get message from your boss at Friday late afternoon: “We will have audit next month, and if I remember well… we have some personal data which should be secured. Could You please be ready for it?”. Thankfully we have few days till the audit, so… Let’s look what options for […]

Read more

Now Where Does THAT Estimate Come From? | 400

The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there’s nothing you can do about it. Or is there? In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge […]

Read more

Advanced T-SQL Technique | 400

Writing SQL queries is not hard, but writing high performance queries is not always simple. Obviously you need to know thoroughly all the language constructs offered by T-SQL, but it is equally important to be creative and capable of thinking outside the box. In this session we will use well known and lesser known T-SQL […]

Read more

Getting release management right for SQL Server | 300

This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’ve hopefully set up some sort of automated build and regression testing process. However, your deployments are still expensive and risky. You find it hard to keep track of what has been deployed to each […]

Read more

Powerful T-SQL Improvements that Reduce Query Complexity | 300

We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012. New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, […]

Read more