#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day is very special because Rimma Nehme will be giving a keynote on  Cloud Databases 101.

Rimma Nehme is one of those super smart people who works for Microsoft Gray Systems Lab along with the very special Dr David Dewit.

Day 2 started with a talk by Adam Jorgenson, PASS Exec Vice President of Finance.
Adam started talking on how PASS operate, from where money comes and how it’s used? The key thing to note is that PASS is in good financial state with good amount of rainy day fund.

Adam on stage !

Thomas LaRock was back on stage on day 2, and he started talking by thanking outgoing board member Sri Sridharan. Kudos to Sri for all his efforts. He also introduced the new board member Grant Fritchey.

Next up was Denise McInerney,VP Marketing and she talked about her experience of PASS and the career changing decisions she took. Denise mentioned how PASS changes people’s career.

She thanked the volunteers for their hard work, and the winner of PASSion award was announced and the winner was Andrey Korshikov.

Denise confirmed that Summit will be back in Seattle Oct 27-30 2015, and that’s great news !!!

Crowd was eagerly waiting for the keynote to start and Denise requested Rimma to take over the stage.
Rimma talked little about her and cracked some jokes about Dr. David Dewit. She added that she is a great fan of SQLServer/PASS community.

Rimma Nehme on stage giving Day 2 Keynote on Cloud Database 101

The agenda of the talk was based on :
  1. Why Cloud? 
  2. What is a Cloud DB?
  3.  How they are built?
  4.  What is my role as a DBA?
When people like Dr. David Dewit or Rimma talk, they come with great simple slides with lot of information on them. They also tend to use real life analogy to explain things, which is really nice.
Here is an abstract of what Rimma talked:
Why cloud computing?
Why cloud? (Also known as 5th utility! )
Cloud is special because of its characteristics:
  • On demand self-servicing.
  • Location transparent resource pooling.
  • Ubiquitous network access.
  • Rapid elasticity.
  • Measured service pay per use.
History of cloud :
1960’s (Super computers/Mainframe) ,1990(Sales force) ,2002(AWS), 2006(EC2), 2008 – present (Azure, Google Apps).
Where cloud lives: Data Centers(Of course !), and the move to the Next generation Data Centers.
Data center efficiency is measured in terms with PUE (Power Usage Effectiveness) :
Total Facility Power /  IT Equipment power.
Traditional PUE 2.0 vs Modular PUE 1.15(cooling 0%).
Microsoft Data-centers :

Over 100 DC in more than 40 countries, More than 1 Million Servers.

What is a Cloud DB
Platform As a Service, Infrastructure As a Service ,Software As a Service.
Pizza analogy of cloud:
What kind of cloud databases are out there: We have Managed RDBMS, Managed No SQL, Cloud Only DBaaS. Analytics as a Service, Object Store.
How they are build
Why Virtualization : Put under-utilized resources in use. With a drawback that direct access to resources will be lost.
Multi Tenancy : 4 common approaches. Private OS,Private Process/DB, Private Schema,Shared Schema.
Inside Azure SQL DB :
The concept is each account as 1 or more servers, each server has one or more databases, each database has one or more objects.
Everything designed with HA in mind.
Layers of abstraction : Client layer, services layer,platform later, infra layer.
Network topology :
MY role as a DBA
Last but not least Rimma talked about the role of DBA for Cloud.

Rimma wrapped up Cloud 101 talk by requesting Dr.Dewitt to join her on stage, and there was a standing ovation by the crowd.



We #SQLFamily is expecting Rimma to be back next year to give a more in-depth talk on Cloud and we are looking forward to it.

Thanks for reading, and keep watching this space for more !


SQLSaturday Redmond(SQLSat212) – A quick recap !

That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds and learned something new.

It all started with a wonderful keynote by Buck Woody(B/T),and he delivered quite an interesting talk on SQLServer history. A journey way back from 1989 to 2012.


The first session which I attended was AlwaysOn – Finally, A usable ‘mirror’! by Jim Murphy(B/T). This was a beginner level session and Jim delivered it really well. I/m sure anyone who is new to Always ON AGs had lot of takeaways from this session. Jim spoke quite a lot about VNN  – Availability Group listener and gave some good demos on how flexible Always ON AGs fail-over is.


Attending the 2nd session was really a challenge for me. There were 3 sessions happening at the same time and all 3 were interesting to me. This is when things gets really tricky.

Finally I decided to attend the session Being the DBA of the future – a world of on-premise and cloud by Dandy Weyn as I’m focusing on a lot of things related to cloud these days, and eventually will move lot of things to the cloud.

This was an intermediate level session and I had lot of take away’s from this session. Dandy was a great speaker and he gave some cool demos by setting up a virtual machine in Windows Azure platform and showed some real networking concepts to connect that VM to your domain. This was something which I was really looking for.


After a yummy lunch(Yep, SQLSaturday offers great food too) I was all set for the big one.

This was one session I was eagerly waiting for, Machine Learning for Mere Mortals by Dev Nambi (B/T).  The session was super exciting and everything was new to me for this one. Machine learning is all about building predictive models from available data. Dev gave multiple real life examples and gave some good demos explaining the concept from a high level perspective. Lot of learning for me and I’m looking forward to read/explore more on this.


Next up was Windows Azure SQL Database – your cloud database by Scott Klein . This was a Windows Azure SQL Database 101 talk and Scott was a real good speaker. There were couple of good demos explaining the whole SQLDatabase concepts and he was kind enough to answer my multiple questions offline via an email after the event.

The final session for the day was like icing on the cake. I have no words to describe how useful was the session Why I Won’t Be Hiring You by Nicholas Cain(B/T). The session was all about how good you need to present your resume to a recruiter. The session was really interactive and there were lot of great questions. Nicholas is a super nice speaker and he really knows what he is talking about. Kudos to him !


I had a great time meeting and talking to wonderful #SQLFamily members and my first SQLSaturday experience was indeed memorable.

Thanks for reading and keep watching this space for more.

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?


This is my first SQLSaturday and I’m super excited to attend this event.

SQLSaturday’s are always a great opportunity to learn something exciting, and shake hands with those people who are really passionate about SQLServer.

SQLSat212 has got some good sessions and I’m looking forward to have a great time out there.

I’m sure SQLSat212 keynote will be interesting as its been delivered by none other than Buck Woody(B/T).

There are a lot of cool sessions lined up for the event and you can get the complete list here.


PASS always does a great job by providing all the required details for folks who are attending the events, and all the required/valuable details regarding this event can be found here –


I’m really looking forward to meet and say a big hello to the lovely #SQLFamily members.

I will be writing about my first SQLSaturday experience after the event and will be posting whole lot of pictures.

Thanks for reading and keep watching this space for more.

PASS Summit 2012 News – Check- in Experience!

Registration and Check in for PASS Summit 2012 was opened yesterday (Nov 4th), and I decided to utilize this opportunity and check-in little earlier than the first day of the conference (Nov 7th).

A great benefit of completing this well before the conference day is I can avoid checking in during the busy conference day morning. I can spend more time meeting and talking to my friends whom I’m eager to meet.

Yes, I mean it! Really excited to meet you all and make friends for a life time!

I reached Washington State Convention Center with my wife Deepthi by around 5.15 PM, and we were happy to see PASS Summit 2012 posters/banners guiding us to the exact location where the registration/check-in was happening. No confusion what so ever!

There was already a decent queue when I reached the check-in area, and I could see happy faces all around me. Everyone looked really charged and excited about PASS Summit.

I’m new to PASS Summit and was super excited to check-in for the greatest SQLServer event in the world.

I had to stand in queue for like 5 minutes and finally when my turn came, the lady who was responsible for check-in happily inquired my details and handed over me the PASS Summit 2012 kit.

Thats it ! All set to attend PASS 2012 Summit and have a great time learning new things and meeting friends. Connecting with people is the most important part of this conference and I’m really looking forward for this.

There are 2 very important events occurring tomorrow, one is First-Timers Orientation Meeting between 5.15 PM – 6.30 PM PST and PASS Summit 2012 Welcome Reception between 6.30 PM – 8.00 PM PST.I will be attending both the events and will write a detailed blog post with lot of photos.

Check out my flicker stream for all the PASS Summit 2012 photos,I will keep updating this stream during the next few days.

Thanks for reading.

PASS Summit 2012 Countdown Begins !!!

All roads lead to Seattle!

If you are a SQLServer professional, then you don’t want to miss this event.

Over 190 technical sessions, 2 days of pre-conf sessions with in-depth learning opportunities, networking with MVPs/Microsoft CSS/SQLCAT members! This is what PASS Summit is all about, and the great news is that you still have chance to register for this mega event.

PASS Summit 2012 will be my first SQLServer conference of this magnitude, and I’m very much humbled and truly excited to get a chance to attend this event.

So when is PASS Summit 2012 happening –

The main event happens from Nov 7th – Nov 9th 2012, however there are 2 days of exclusive pre-conf sessions happening from Nov 5th – Nov 6th.

Count down begins !!!

A complete list of pre-conf sessions and regular conf sessions are made available on the PASS website and you can refer it here.

PASS Summit is not just about attending tech sessions. Apart from learning new things there is great scope for networking and talking to different people with whom you interact over twitter and other social networking means. This means a lot to me and I’m really looking forward for it.

So where’s all the fun is happening?

It’s happening at Seattle, one of the beautiful cities in Washington State(Ever green state).

If you are new to Seattle and also a first timer for PASS Summit, then I would really recommend you watching the on-demand SQL PASS 2012 1st Timers Webcast by Denny Cherry(B/T). Denny provided lot of information during his hour long webcast which includes key information about after hour parties which is very important from networking perspective.

The main conference event occurs at Washington State Convention Center and here is a walking map from the closest transportation station to the convention center –

Apart from attending conf sessions and after hours parties, what else you can do at Seattle. Here are some of my suggestions. I’m local to Seattle and been exploring this beautiful city since last year –

1. Capture this view with your cam and share with your friends and family

[Image source, courtesy – http://www.flickr.com/photos/bryce_edwards/2360672546/ ]

This is Seattle skyline view, and you will get similar great views from Kerry Park

Reaching Kerry Park is very easy and in case you are not driving a car, then the best option is to catch a bus.Approx time to reach the park from downtown via bus in 20 minutes.

2. Ride the ducks of Seattle

This is a mini Seattle tour option, and this ride is fun and exciting. You will see the key places of interests in and around Seattle.You will also get a chance to ride through water.

Your ride captain might wear some funny caps like these.

Check out the details at http://www.ridetheducksofseattle.com/

3.  Pike place market and fish throwing.

Pike place market is easily one of the happening places in Seattle. It’s always a fun place to be,and you will get everything except quality SQLServer training here ! Be it food,drinks or even fresh flowers.

It’s very close to the convention center.

You can also witness ‘ fish throwing ‘ action within the market too. This fish throwing is a tradition. People working in the fish market will be throwing fish that customers have purchased, before they are wrapped.

Here is a shot which came out of my camera couple of months back.

4. Space needle

Space needle is a major landmark and a beautiful tower in Seattle. You can purchase tickets to take lifts and reach the observation deck of the tower to get magnificent views.

Details about pricing and other key information are made available here.

View from the top of the tower is truly amazing.

Reaching space needle is also very much easy and you can either decide to take a quick walk (0.9 miles from West lake center) or take bus.

5. EMP Museum

EMP Museum is dedicated for music. Its founded by Paul Allen (Microsoft co-founder)

Its a nice place to spend time exploring the history of music and also we have a community appreciation party at EMP during summit.

Here are some of my photos from the museum –

Roots and Branches Guitar Sculpture

Big screens with rock music

I am really looking forward to meet you all during PASS Summit 2012 and have a great experience.

See you all soon.

Thanks for reading.

You don’t want to miss this out,Serious SQLServer training – 24 Hours of PASS event !

Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all about.

The event kicks off at 12:00 GMT on Sep 20 and runs for 24 consecutive hours.

The sessions are selected carefully, and are categorized into 6 tracks –

Enterprise Database Administration (DBA)

Application Development (AppDev)

BI Information Delivery (BID)

BI Platform Architecture, Development & Administration (BIA)

Cloud Application Development & Deployment (CLD)

Professional Development (PD)

Complete details of sessions are available at http://www.sqlpass.org/24hours/fall2012/SessionsbyTrack.aspx

I’m looking forward to attend some great sessions next week, and my favorite picks are –

Characteristics of a Great Relational Database by Louis Davidson

Digging Into the Plan Cache  by Jason Strate

Three Ways to Identify Slow Running Queries by Grant Fritchey

Fasten Your Seatbelt – Troubleshooting the Most Difficult SQL Server Problems  by Klaus Aschenbrenner

SQL Server Private Cloud != Azure by Allen Hirt and Ben DeBow

What’s All the Buzz about Hadoop and Hive? by Cindy Gross

DBCC, Statistics, and You by Erin Stellato

Best Practices for Upgrading to SQL Server 2012 by Robert Davis

PowerShell 101 for the SQL Server DBA by Allen White

Using SQL Server 2012 Always On by Denny Cherry

Leadership – Winning Influence in IT Teams by Kevin Kline

I’m really excited ! Are you ? Register here

Thanks for reading.