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.

Agenda:

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 ~