Argenis Fernandez is a SQL Server MVP and SQL Server Solutions Architect for Pure Storage based in Redmond, Washington. He has worked with SQL Server for approximately 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 Pure Storage, Argenis worked as a Lead Database Operations Engineer for SurveyMonkey 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) security.sqlpass.org
. Argenis is a SQL community enthusiast and speaks frequently at major SQL Server conferences, including PASS Summit, PASS SQLRally, IT/Dev Connections, SQLBits, and TechEd. He is also a Microsoft Certified Master, an avid Twitter user (you can follow him at @DBArgenis), and an occasional blogger on SQL Server topics at SQLBlog.com and PureStorage.com/Blog.
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!