The DBA Team presents: SQL Server Maintenance and Monitoring
Friday, March 8, 2013 from 12:45 PM to 6:00 PM (EST)
Richmond, United States
Can you be certain your SQL Servers will run well for your clients?
Want to make maintenance and monitoring easier?
Join Red Gate's DBA Team and SQL Server experts, Steve Jones (Editor of SQLServerCentral) and Grant Fritchey (Product Evangelist) for top tips and advice on core database administration tasks.
These two SQL Server MVPs will take you through four key areas to help solve your DBA headaches, including: setting up a backup strategy, monitoring your servers for unusual activity and indexing.
You’ll leave this half-day seminar with a solid understanding of how to maintain and monitor your SQL Servers – as well as how to get the most from the Red Gate tools you have to make these tasks even easier for you. Plus you’ll get a chance to see the tools in action, ask questions and join us for a free SQL Happy Hour at the end of the day.
Register now to secure your seat for this half-day seminar.
12:45pm – 1pm ~ Attendee arrival and registration ~
1pm – Welcome & introductions
1:15pm – 2pm – Core Monitoring for SQL Server, Steve Jones
Good DBAs ensure that they are always aware of the state of their instances. All systems should have monitoring in place, not just so you know when things go wrong, but so you understand what a normal workload looks like and can plan for the future. This session will cover the basics of monitoring a SQL Server system and the various metrics you should be tracking.
2pm – 2:15pm ~ Demos with the Red Gaters in the networking area with refreshments ~
2:15pm – 3:00pm – Getting Started with SQL Server Backups, Grant Fritchey
Backups are fundamental to protecting the investment your business has in its data and they’re the foundation of disaster recovery planning. We'll go over best practices for database backups, to ensure you're establishing that foundation correctly within your systems. This introductory level session covers full, log, and differential backups, as well as restores and restores to a point in time. Come along to be sure you've got the right protection in place for your systems.
3:00pm –3:45pm – Understanding Database Corruption, Grant Fritchey
A DBA’s primary purpose is to ensure that the information in their charge is accessible by the correct people within their organization. Despite everything you do to make sure you've got your servers configured, monitored, and tuned, with well-tested backups in place, you can still lose data through corruption. But what is corruption in a database? This session lays out exactly where database corruption can come from, how to find out exactly where the corruption is within a database, and the methods you have available to recover from database corruption.
3:45 – 4:05pm ~ Q & A with the Red Gaters in the networking area with refreshments ~
4:05pm – 5pm – Indexing for SQL Server, Steve Jones
Indexes are important for improving the performance of your queries, but they add overhead to your server and require maintenance. This session examines how indexes work and the basic maintenance that you should perform to ensure your system is running at its peak level.
5pm – 6pm ~ Happy Hour & Q&A with the DBA Team ~
Red Gate Software makes ingeniously simple software for people who work with SQL Server, .NET, Microsoft Azure, and Oracle.
If you use SQL Server, Red Gate tools can help you compare, source control, deploy, monitor and back up your databases.
They can also help you understand and fix .NET code problems, compare and deploy Oracle databases, and manage applications, storage, and diagnostics in Microsoft Azure.
Try all our tools for free at www.red-gate.com
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.