Scaling SQL Server 2012 in Lisbon, Portugal

I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon, Portugal. This was the first time I have spoken at a SQLSaturday outside of the United States, and I really enjoyed it! This never would have happened without the enthusiasm of fellow SQL MVP Niko Neugebauer, who is a good friend and an all-around good guy!

My employer, SQLskills gave away a certificate for a $500.00 discount on a future SQLskills Immersion Event class at the SQLSaturday preconference event. I also gave away a copy of SQL Server Hardware and a copy of Professional SQL Server 2012 Internals and Troubleshooting in a raffle at the end of the event. 

Here is the preconference session I delivered on Friday:

Scaling SQL Server 2012

How can you scale SQL Server 2012? Scaling up is relatively easy (but can be expensive), while scaling out requires significant engineering time and effort. If you suggest hardware upgrades you may be accused of simply “throwing hardware at the problem”, and if you try to scale out, you may be thwarted by a lack of development resources or 3rd party software restrictions. As your database server nears its load capacity, what can you do? This session gives you concrete, practical advice on how to deal with this situation. Starting with your present workload, configuration and hardware, we will explore how to find and alleviate bottlenecks, whether they are workload related, configuration related, or hardware related. Next, we will cover how you can decide whether you should scale up or scale out your data tier. Once that decision is made, you will learn how to scale up properly, with nearly zero down-time. If you decide to scale out, you will learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data dependent routing. We will also cover how to use middle-tier caching and other application techniques to increase your overall scalability.

This entry was posted in Microsoft, PASS, SQL Server 2012, Teaching, Travel and tagged . Bookmark the permalink.

2 Responses to Scaling SQL Server 2012 in Lisbon, Portugal

  1. Scott Caldwell says:

    Glenn,

    I really appreciate all the work you do for the community. This is a great update to the deck you did for the PASS Summit in 2011.

    Thanks,

    Scott

  2. Pedro Sousa says:

    Hi Glenn,
    I’ve attended the Scaling SQL Sever 2012 workshop in Lisbon and I had lots of fun listening to you. The contents of your presentation were great and I learned some “precious gems” from what you’ve said that will surely make my life go easier.

    Thanks,
    Pedro Sousa

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s