Connect(); 2016 - Stories Stack Overflow

[Music]
stack Overflow is the world community of
software developers it's used by over 40
million people every month looking for
answers to their questions uh looking up
documentation and finding new jobs
developers love stack Overflow to the
tune of about 6 billion hits a month
stack Overflow itself only runs on two
SQL servers one for the read write
workload and one for the read workload
but we're talking about 10 and 5% CPU
one can more than easily handle the load
we're just preemptively scaling out so
we have a ton of Headroom people are
surprised when they hear that stack
Overflow can run on a single SQL Server
instance because they just don't realize
how much scaling you can get out of SQL
we trust it because it's highly
available it's highly reliable it's one
of the most Rock Solid pieces of
infrastructure we
have we always say we want to use the
best tool for the job and we'll always
choose the best tool whatever it is at
any time what amazes me is just how
Little Hardware that we need and and we
have literally saved millions and
millions of
dollars stack Overflow Enterprise is a
version of stack Overflow for large
corporations that want to allow their
own internal developers to ask questions
about their internal code privately
within the firewall rather than asking
those questions on the public internet
with SQL Server sp1 we can run the same
code entirely on both platforms and
customers that need Enterprise scale by
Enterprise and customers that don't need
that can buy standard and run just fine
from a programming point of view it's
easier for us and easier for them one of
the greatest things about the
transformation that Microsoft has
undergone is the willingness to work on
every possible platform that really
makes their offerings including SQL for
Linux including Vol offerings from the
consumer all the way up to the
professional developer and the data
center much much more compelling my
favorite thing is when a developer comes
up to me and tells me how much stack
Overflow help them that's really awesome
they usually thanking me as if I had
answered their questions but it's really
the the population of stack overflow