#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 !


#SQLPASS #Summit14 Day 1 Keynote Highlights !


PASS President Thomas LaRock on stage !

PASS President Thomas LaRock kicked off the summit keynote.


Tom talked about the history of PASS and its growth curve. Positive numbers all over the place !

One of the key things to note is that PASS has delivered 1.3 million hours of training which is pretty impressive.



Next up was Microsoft Corp Vice President TK Ranga Rengarajan talking about Evolving Microsoft Data Platform.

Ranga talked about the explosion of data/data sources and its positive trend.He stressed on the evolving Data culture and how data professionals can lead this change.Microsoft data platform is capable enough to manage all the data requirements.


Ranga Rengarajan on stage !

Goal is do more,achieve more via :

Capture Diverse Data

AzureDocDB, AzureHD Insight, Analytics Platform System, Azure Search.

There was a demo by Pier1 Imports on Azure Search, and the demo explained the value of Azure Search capabilities
and its power.

Pier 1 gave another demo of their Promotions app/page which uses AzureDoc DB.

They also achieve scaling using SQLDatabase sharding capabilities.

Pier 1 is also leveraging Geo Replication for its premium SQLAzure Database.

Achieve Elastic Scale

SQL2014 with Win 2012 R2, SQLServer in Azure VM’s, Azure SQLDatabase.

Max Performance

Azure SQLDatabase, SQL2014.

Simplify with Cloud

Hybrid scenarios with SQL2014, Azure as a data lake.

Ranga also talked about various businesses which are leveraging SQLServer to achieve their data/scaling requirements.

Some great numbers for SQLServer this year :

1.2 Million downloads of SQL2014. 1M Azure SQL DB’s deployed.

Major Announcements :

Azure SQL Database Major update : Leap in TSQL compatibility, Larger index handling, Parallel queries, Extended events, In memory Col Store.

Technology Sneak Peak : Pier1 Imports

Pier1 Demo was focused on In memory OLTP/ Col store on Azure SQLDatabase. 13,000 transactions/second were fired up and at the same time a reporting workload was ran and performance was awesome .

They also demonstrated the ability to stretch On Premises database to the cloud.

Next up was Joseph Sirosh, Microsoft CVP Machine Learning & Information Management.

Joseph talked about Azure Machine learning and other capabilities.


Joseph making sure the crowd is engaged !


Again the goal is Do more,achieve more, Put data to work  :

Understand the past
Azure Data Factory

Demo from Pier1 demo on trend/stream analysis using Kinect/Azure Data Factory. Data from Kinect sensors are streamed
to azure and data is analyzed real-time.

Analyze the present
Azure Stream Analytics

Predict whats next
Azure Machine Learning

Demo by Pier1 Imports on machine learning. Pier1 app allows customer to login to the app and the customers
shopping trend/taste data is checked from Azure and results are shown.

Next up was James Phillips , Microsoft GM Data Experiences

James talked about bringing insights to more people – faster.


James talking about Power BI and Machine Learning !


Goal again is Do more ,achieve more :

Simplify data discovery 
Deliver faster time to insight

Connect to on-premises
Data Refresh, Interactive Query

Enable data culture
Live Dashboards, Drill through

James gave a cool demo of PowerBI Dashboard.

Thanks for reading and keep watching this space for more !

SQLPASS Summit 2014 is here, The largest SQLServer Conference !

November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when #SQLPASS Summit happens.

SQLPASS Summit is the largest SQLServer conference in the world, and this year the number seems pretty huge with over 5000 attendees !

#Summit14 will be my 2nd Summit, and I’m really looking forward to it. My 1st was Summit12, and I missed the one which happened in Charlotte, NC (Summit13).

This year is very special as SQLServer 2014 was released this April, and there are tons of SQL2014 related sessions for this Summit.

If you are looking for deep dive sessions on In Memory OLTP,Buffer Pool Extension, Cardinality Estimator, Deep Azure Integration, then Summit14 is what you need to attend. Register here !

I normally check-in for the event little early, and PASS does a great job by opening the registration counters by Sunday evening.

I completed my registration today and here are some pictures for you :




I will be blogging LIVE for Day1 keynote, and will be writing about my summit experience in the next couple of days.

Sleepless in Seattle !

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.