New York SQL Events – Upcoming Triple Play……

Robert Pearl, 2011-06-21

If you’re in a New York State of Mind (song by Billy Joel), then you’ll like the triple play of events that are coming this summer and fall to the Big Apple!  Below is an awesome triple play of SQL Server NYC events!  The third one is an exclusive announcement – Remember, you heard it here first on the PearlKnows blog!


First up this week, the New York SQL Server User’s Group invites you to please join Leonard Lobel to discuss SQL Server T-SQL programming enhancements.                      


Date:  Thursday, July 23, 2011   

Time:  6:00 pm            

Location: Microsoft Office, 1290 Avenue of Americas, New York, NY 10104                       

Discover the most important Transact-SQL (T-SQL) features introduced in SQL Server 2008, and get a preview of new enhancements in the next version of SQL Server code-named “Denali.” Learn how to use Table Valued Parameters to marshal entire sets of rows across from client to server, and to pass them between stored procedures. We’ll also dig into MERGE, a powerful DML statement that combines the capabilities of four (or more) separate operations, and look at INSERT OVER DML, which enhances our ability to capture change data from the OUTPUT clause of any DML statement. Date and time enhancements are then explored, including separate date and time data types, time zone awareness, and improvements in date and time range, storage, and precision. This demo-packed session will finish up with a preview of the improvements coming in Denali, including the new THROW statement, improved metadata discovery, server-side paging, and sequences.
Leonard Lobel is the chief technology officer (CTO) and cofounder of Sleek Technologies, Inc., a New York–based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft Gold Certified Partner. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences. Lenni is also lead author in the MS Press book “Programming Microsoft SQL Server 2008”. He can be reached at

 Note that you must register below in advance in order to enter the Microsoft office building:

Registration site:
Event Code: 155743


Event II

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!

And that’s not all!  As an attendee of this class, you will have the opportunity to view first hand, for the first time, a new creation of Adam Machanic (literally came to him in his sleep!), a demo of a new kind of streaming component that according to him, could take a query running from hours to minutes! Using this new method he was able to tune a query that had been running in 4+ hours down to 6 minutes!

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:



Hold onto your hats, folks!  Perhaps this is just a teaser, but, if you are following me on Twitter|PearlKnows, I’ve been hinting at an extraordinary event (only the second of its kind), coming to town in NYC this fall!

Now I know there will be many, many events going on at this time, SQLPASS, SQLConnections, SQLSaturdays, etc. etc.  All great events for learning and training!  This one, however, is unique, and is meant to inspire us SQL Professionals!  It’s about thinking and engineering, imagination and innovation, ideas and inspiration! Most of all, it’s about people and community  People like us!  Not your ordinary training event, it is built more around direct interaction, discussion and discourse with premium speakers from the SQL Server Community!  I know you’ll know each and every one of them!

So, there I said it, SQL and People.  We have a date, we have a venue, and we have great speakers!  Now, we need you to come and be part of this enlightening experience.  Yes, this is SQLPeople NYC!!  From the great founder, trainer and SQL MVP Andy Leonard, and his partner, of SQL Server Magazine, Brian Moran, now Chief Servant Officer at SQL People.  I am honored and proud to be joining these two gentlemen, along with NJ SQL User Group Leader and WIT evangelist, Melissa Demcsak, aka SQLDiva, and SQL MVP, Author, Developer and  XML expert, Michael Coles, aka Sergeant_SQL.

There’s still some planning going on. We’ll be bringing you a whole bunch more details of how and when you can register.  Stay tuned, and bookmarked on PearlKnows.  In the meanwhile, the basic what, where, and when.  The WHO to be announced soon!

What: SQLPeople

Where: Microsoft HQ, NYC

When: Saturday, November 12, 2011





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads