CSI: SQL Server
If your SQL Server was hacked, do you think you would know about it? Would you know how to discover who attacked your server? What was compromised? When? How? Thankfully most DBAs are not fighting off criminals on a daily basis, but understanding SQL Server forensics will allow you to better understand your SQL Servers and will give you the ability to answer that frequent question “What happened?” In this session, I will walk you through the process of how to determine what happened on your server without the use of expensive third-party tools, using only features available in all editions of Windows and SQL Server. You will learn how to parse the various Windows, SQL Server and database transactional logs. We will also explore the wealth of information available within Dynamic Management Views for clues as to what is happening on you SQL Server.
Manager of Database Services
Sarah Barela is the Manager of Database Services at MaximumASP. She has a Master’s degree from the University of Texas in Information Science and more than 15 years of administrative experience with SQL Server. She specializes in the administration of environments with large numbers of SQL. Her latest interests lay in applying cloud technologies to SQL Server Environments. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. She spearheaded a partnership with MaximumASP, Dell and PASS to launch the free hosted Beta offer for Microsoft SQL Server 2008 R2 at www.previewsqlserver.com. She has been a guest speaker at a number of PASS chapter meetings, SQL Saturday events and the 2009 & 2007 SQL PASS Summits.
Register Now for PASS Summit 2010!