February 2, 2011 1 Comment
While much of North America is bracing for the Snowpocalypse 2011, my thoughts are turning to sunny Florida.
I’m not just thinking of an escape from the cold, dreary weather that February brings with it. No, I’m thinking of the warm hospitality of sunny Orlando and SQLConnections.
I’m going to deliver a couple of sessions at the conference. Check out all of the sessions.
SSC01: Locking and Blocking Made Simple
A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.
SSC04: Tips and Tricks for Writing Better Queries
Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However, to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we’ll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better.
As I tune into the weather channel and see the nasty arctic weather that’s pelting almost 1/2 of the continental United States, I can hardly wait. I hope to see you there, too.