Next Meeting

Hi Folks -

Hope you are all doing ok in this cold weather. We are finally ready to get back together again in the new Microsoft Offices at 11 Times Square (West 41st and 8th Avenue). Please join on on Tuesday (yes, Tuesday not Thursday) February 25th at 6:30 PM (yes, not 6:00, the presentation will actually start at 7:00 but pizza etc will be there at 6:30) for a special presentation by Kimberly Tripp and Jonathan Kehayias. Please make sure to register at https://clicktoattend.microsoft.com/en-us/Pages/EventDetails.aspx?EventId=179143 The full abstract and agenda is below.

Groups/Target Audience: SQL Server and .NET User Groups, anyone that works with SQL Server that wants to talk techie on Tuesday night

Presenters: Kimberly L. Tripp & Jonathan Kehayias, SQLskills.com

Abstract: Our title seems strange but it runs across multiple themes. First we’ll take a look at Service Broker in SQL Server and how it can extend service oriented architectures into the data tier with asynchronous message processing. As for the other theme, database developers, DBAs, architects – don’t always talk to each other. In this evening session, we’ll cover a mix of really interesting topics that help bridge the gap across these disciplines. Reading plans and understanding plans with Plan Explorer (both the free and the Pro versions will be discussed) – this is something everyone should be able to do. And, we’ll raffle off a PE Pro Edition (thanks SQL Sentry) in addition to talking about the FREE Plan Explorer. Then, we’ll dive into statement execution methods and plan cache. Different coding strategies on our servers can have a profound effect on both cache and performance. But, how can you write more effective code that takes less caching and has better plans? Some of this content comes from a newly released Pluralsight course titled: SQL Server – Optimizing Ad Hoc Statement Performance and for those of you that attend – Pluralsight will give you a monthly trial. And, we’ll also raffle off two Annual Plus subscriptions (thanks Pluralsight)!
How can we all just get along? Come to this fast-paced, demo-packed session led by industry-experts Kimberly L. Tripp and Jonathan Kehayias of SQLskills. And, after the presentation, Kimberly, Jonathan, and Paul Randal (also of SQLskills) will hang out for an open Q&A on almost-anything-SQL. We’ll post a list of topics and open up the floor!

Sponsors:
· Pluralsight: www.pluralsight.com

· SQL Sentry: www.sqlsentry.net

· SQLskills: www.SQLskills.com

Agenda:
6:30pm – Pizza, networking, settling in
7:00pm
Service Broker (~15 mins) – Jonathan Kehayias
SQL Sentry’s Plan Explorer (~15 mins) – Jonathan Kehayias
Statement Execution (~15 mins) – Kimberly L. Tripp
Plan Cache (~15 mins) – Kimberly L. Tripp
8:15pm – Raffles (must be present to win)
SQL Sentry Plan Explorer Pro License
Pluralsight Annual Plus Subscriptions
$100 off (per day) for an Immersion Event of your choice
(maximum value $500 for a 5-day event)
Everyone – 30-day trial subscription to Pluralsight
8:30pm – Open Q&A (all 3 of us)

Location:
Microsoft
11 Times Square (West 41st Street and 8th Avenue)
New York, NY 10036

Enhancing SQL Server with a NO SQL DB

Please join us on Tuesday, December 3rd for a special presentation from FatCloud, the makers of FatDB at the Microsoft Offices at 1290 6th Avenue, at 6:00 PM.
I’m sure you’ve all been hearing the buzz about “NO SQL” databases. Well in this presentation, instead of hearing how new databases will replace SQL, come here how to use a NO SQL database to enhance your SQL Server environment.
In the first part of our meeting, the makers of FatDB will present the type of applications and situations where NOSQL is useful in a SQL Server environment and demonstrate how the features of their database, including the easy two way integration with SQL Server can help solve these problems.
In the second part of our meeting, we will have actual hands on walk throughs of coding examples. To take full advantage, bring your laptop and have it loaded with Visual Studio 2012 or Visual Studio Express and Download and install FatDB  (fatcloud.com/download.html)
The vendor will also be supplying refreshments, and giveaways. Please click on the link below to register.  Registration Link