Here’s another awesome SQL event coming to New York City.  (Keep reading for your discount below!) It’s already getting hot here, so by the time July 14, 2011 rolls around, we’re going need something real cool to do.   It’s not your typical SQL Server intro or even intermediate class.  Folks, bring your helmets and diving suits because we’re talking extreme SQL - NYC style.  It will be a crash course in everything you wanted to know about SQL CLR, and were afraid to ask.  You will be surfing the multicore wave of processors, parallelism and performance, as you then deep dive into the inner workings the SQL Server Operating System (SQLOS).  This high-powered, high performance tuning event is coming to town on Thursday, July 14, 2011 through Friday, July 15, 2011. It will truly be rush hour in this exclusive one-time only in NYC class, brought to us by SQL Server MVP and .NET expert Adam Machanic. 

This class, Taking It to the Extreme: SQLCLR and Parallelism with Adam Machanic is not for the faint of heart. If you are a SQL Server professional who wants to take performance tuning to the next level, and, are interested in how to optimize your SQL Server Performance beyond typical methods, having exhausted everything you already have in your arsenal, then reload with 2-days of awesome learning!

This FULL 2-day course is all about driving higher performance by using somewhat non-standard (or less mainstream) techniques. Most performance tuning exercises start and end with I/O and indexing, and by now pretty much everyone understands how to tackle these issues. Once you've finished with that layer, the game is hardly over - there are incredibly gains that can be made by reevaluating how to think about queries, and taking advantage of the massive processor and memory resources available on today's servers. Both days concentrate on how to achieve this goal. As per Adam, "SQLCLR can be used to build algorithms and query paths that the SQL Server query processor doesn't handle well. This can result in extreme performance gains, and I've been able to successfully leverage it in a number of environments. The second day is all about parallelism -- using all of the CPU resources available in the server. Once again, proper use of parallelism, and understanding how to manipulate it, can result in huge performance improvements--5x, 10x, or more depending on the query. I'll also show how to use SQLCLR to create another layer of parallelism using .NET threading techniques." Either of these days can stand on its own in many ways, but together they form a basis to completely re-think query tuning and high performance data access.

So, if you’re serious about SQL Server Performance, learn more and register today! For complete details and class agenda, make sure you click on the event link below. As a reader of the PearlKnows blog, if you register now, you will receive an exclusive early-bird discount!  That’s right!   Use the code SQLCENTRIC, and you will get $125.00 off this excellent 2-day class.  The code can be applied on the registration page, here: http://www.eventbrite.com/event/1595370797

It’s great that Adam will be here in NYC to share his experiences with programming, performance tuning, and optimizing SQL Server in conjunction with related .NET technologies.  You don’t want to miss this rare opportunity to be taught by one of the top SQL Server industry experts!  Once he comes to NYC, he’s sure to make it his own Adam ’s Apple! (Ok, don’t blame him for the bad humor, my bad 😉

Adam is also the creator of the award winning WhoIsActive, a free downloadable utility that let’s see everything you need to know about currently active SQL Server threads and processes. It makes DMV monitoring easy. Think sp_who2 on steroids!  WhoIsActive is deployed as a stored procedure on your server.  It recently picked up the SQL Server Magazine’s GOLD Award as Editor’s Choice, in the Best Free Tool category. The latest version, v.11, is available for download.

A Boston-based independent database consultant, writer, and speaker, Adam has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications. He has optimized data access layer performance for several data-intensive applications. In addition, Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.

Hope to see you there!