Skip Main Navigation
Page Content
This event has ended
The DBA Team event series is presented by Red Gate's SQL Server experts: Steve Jones & Grant Fritchey

The DBA Team presents: SQL Server Maintenance and Monitoring

Red Gate

Friday, March 8, 2013 from 12:45 PM to 6:00 PM (EST)

The DBA Team presents: SQL Server Maintenance and...

Registration Information

Type End Quantity
Friday afternoon with Steve Jones & Grant Fritchey Ended Free  

Share The DBA Team presents: SQL Server Maintenance and Monitoring

Event Details

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 ~

 

Have questions about The DBA Team presents: SQL Server Maintenance and Monitoring? Contact Red Gate

When & Where


DoubleTree Hotel Richmond Downtown
301 West Franklin Street
Richmond, 23220

Friday, March 8, 2013 from 12:45 PM to 6:00 PM (EST)


  Add to my calendar

Organizer

Red Gate

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

 


  Contact the Organizer

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

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.