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.

No comments:

Post a Comment