Sunday, August 18, 2013

SQL Saturday #235 - Attended Sessions

Tried to post most of the pictures right after the event.

Now will try to go through some sessions I've attended along with attached presentations.

I've attended ONLY "Intermediate" sessions. There were only four advanced from forty-eight in total.
It doesn't mean event held on lower level, it shows highest level of event itself

First was a "Database Health and Performance" by David Klee (Link to Presentation):

Really HIGH level of database administration and problem research.
Room was full of people, but I was lucky and David gave me a wonderful book "Microsoft SQL Server 2012 BIBLE".

Second session was also crowded.It was "SQL Server Internals and Architecture" with famous Kevin Kline. Surprisingly, all SQL Server internals are considered now as "intermediate" knowledge.

During the session Kevin presented latest book from "SQL Sentry" called "High Performance Techniques for Microsoft SQL Server". Book is priced as $9.99 on amazon, but using the promo code "HighPerf1" you can get that book absolutely free

He distributed some other books after his presentation.

Third session was after the lunch.
"SQL Server Databaseology 201" by John Morehouse.
Deep internals of SQL Database pages' structures.

Guess what? - That was also "Intermediate"!
Presentation is HERE

Here are some slides from the presentation:

Session was awesome and covered things you can't easy find in internet.

Fourth session was mind blowing with Ashish Sharma. By his words he is the sales guy, but room was still full of SQL Server professionals who woud like to hear about new features of SQL Server 2014.
Even though there were no technical detail, but it extended horizons of our views in couple of years into the future.

Calm down, and forget what you previously learn.


How we will do it now?

That will be done in the memory!

No, that is impossible!

Take it easy

Our heads are blown-up

Trying to catch up

I personally can not accept that!!!

Fifth session was "SQL Server Storage Engine under the hood" by Thomas Grohser.
No doubt it was also "Intermediate"
You can download that presentation here.

I was lucky to attend all best sessions. there were not enough chairs

People were staying and some sitting on the floor.

Again, very deep down into pages relationship structure.

List of helpful DMVs

Most useful counters

The last, sixth session was "Database Development with SQL Server Data Tools" by Leonard Lobel.
I believe I've already seen presented features before, but somehow did not use them in my latest project.
No doubt I'll try it in my next. That was about managing your SQL code, easy deployments and source control using SSDT. Unfortunately SSDT does not provide out of the box access to objects' extended properties and not very flexible with deployments that requires step-by-step implementation, but I'm sure there have to be ways around. Just have to try it.

Download his presentation from this link.

Just as a little bonus a picture of the building where event was held:

That day entire 6th street was closed for vehicles and given to people. Food, refreshments etc.

I've heard that Microsoft is going to move to another building. So, will see where we will have NYC SQL Saturday next year.

Saturday, August 17, 2013

SQL Saturday #235 in New York City

<= SQL Saturday #200 in Philadelphia, PA

SQL Saturday #250 - Pittsburgh, PA =>

Just attended SQL Saturday annual event in NYC.

That was incredible! A lot of familiar faces and many faces I've remembered since the Last year's event.

I'd rate that event as a top SQL Saturday on the East Coast.
Hundreds of participants, the top SQL Gurus, the biggest SQL industry sponsors....

That SQL Saturday was different than others. It was more innovative and advanced.
Multiple times during the event I heard that I have to forget what I've learned and start over again.

That was because multiple new technologies are just emerged or being shaped.
Starting from Solid State Devices, that require different administration practice and finishing with newest release of SQL Server 2014 with it's tables in memory, that require special programming technics.

That is very hard to translate in that blog all new concepts I've got from there and describe all sessions I've attended, so, will publish only pictures with some comments.

First floor. Security-volunteers distribute passes into the building

6-th floor. 7 A.M. - almost empty

MS Tech Center

First sponsors are already set  

Volunteers are getting ready for early registration

Confio gave away Kindle Fire HD

 Everybody knows Pragmatic Works
 PASS table

 Natasha is not tired yet

 Everything ready for registration

 Speakers are getting ready
 First attendees

 And Coffee!!!

 Hey, some russian faces!
 All sponsors are ready for event

 Second speaker's room. That is a first time when there are so many speakers.


 Rush time. Long line to register.

 Ready for kickoff

 Another russian face

 Nothing can stop people to come to the event!!!

Lanch time discussion "Women in technology"

Kevin presents "Barbi Astronaut"

 After presentation discussion

 Long line to the men room

Wrapping out.

Getting ready for prizes.

Trowing away flash-memory cards' killers (aka USB car chargers)

  Distributing empty water bottles from sponsors

Some kind of information that probably nobody got.

Prizes started from SIOS

Some people did not believe that everything is fair and wanted to get their name by themselves :-)

WOW!!!! Melissa won a Kindle!!!

 That was very funny Paul Rizza - ETL Guru won SSIS book.

Rise hand how are first time at SQL Saturday

The main prize of the event - backpack from PASS 2012 conference.

 Another kindle

 Happy new owner of toy helicopter

 SQL Saturday #235 volunteers (pictured by Chris Bell)