Argenis Fernandez is a SQL Server MVP and Senior Database Engineer for SurveyMonkey based in Redmond, WA. He has worked with SQL Server for around 17 years and enjoys large SQL Server farms, high-end OLTP databases, managing Windows environments, performance troubleshooting, high availability, disaster recovery, best practices, and PowerShell scripting. Prior to SurveyMonkey, Argenis worked as a Senior Database Administrator for Coinstar/redbox and as a Senior Consultant on SQL Server Core for Microsoft Consulting Services. In 2013 he founded the Security Virtual Chapter for the Professional Association for SQL Server (PASS) (http://security.sqlpass.org) .
Argenis is a SQL community enthusiast and speaks frequently at major SQL Server conferences, including the PASS Summit, PASS SQL Rally, IT/Dev Connections, SQLBits, and TechEd. He is also a Microsoft Certified Master, an avid Twitter user (you can follow him at @DBArgenis), and occasional blogger on SQL Server topics at SQLBlog.com.
Do you consider the Windows GUI to be a waste of resources? Starting with SQL Server 2012, you can run on top of Windows Server Core 2008 R2 or 2012. In this session we will discuss installation and management, along with lots of tips and tricks.
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail!