Todd's Blog

Todd's Tips for System Adminstrators

Connect

OttawaSQL.net Event: Increase Performance of your SQL Server Applications, Michelle Gutzait

posted on

clip_image002

November 12th Evening Event:

Increase Performance of your SQL Server Applications –

Performance Tuning for Developers and DBAs, Michelle Gutzait

Speaker: Michelle Gutzait

Date: Thursday, November 12th, 2009

Time: 6:00 PM to 8:30 PM

Venue: Microsoft Ottawa Office

RSVP: http://www.clicktoattend.com/?id=142866

Session:

Performance degradation of an application due to database growth or coding against database performance best practices is very common. This could often result in rewriting parts of the application or partial database redesign. This session is about how to prevent performance issues as much as possible and also how to tune applications when performance degrades. One of the goals of the presentation is to give some tips around how we can be proactive by designing our database and application to be more scalable and possibly more performance. It contains information for the DBA as well as for the developer, in relation to the database and database environment.

clip_image004

Speaker Bio:

Michelle Gutzait is the SQL Server Team Lead for The Pythian Group, a worldwide company providing Remote Administration services for databases, operating systems, SANs and networks. Michelle has been involved in IT for 20 years as a developer, business analyst and database consultant. For the past 10 years, she has worked exclusively with SQL Server.  Her skills include SQL infrastructure and database design, performance tuning, security, high availability, disaster recovery, very large databases, replication, T-SQL coding, DTS/SSIS packages, administrative and infrastructure tools development, reporting services and more.  She regularly blogs at http://michelle-Gutzait.spaces.live.com

Refreshments:

Pizza and pop will be provided.

Note: No one will be admitted by building security after 5:55 PM, and the event will start promptly at 6:00 PM.

OttawaSQL.net is a community group of Ottawa area developers and IT professionals.  We share an interest in Microsoft’s data technologies especially:  SQL Server, SharePoint, PerformancePoint, Workflow Foundations, LINQ, ADO.NET and Entity Framework.

October 15th Evening SQL Server DBA Event: Disaster Recovery

posted on

OttawaSQL.net 

 

October 15th Evening SQL Server DBA Event: Disaster Recovery – Edwin Sarmiento, MVP for SQL Server

 

Speaker: Edwin M. Sarmiento, MVP for SQL Server

Date: Thursday, October 15th, 2009

Time: 6:00 PM to 8:30 PM

Venue: Microsoft Ottawa Office

RSVP: http://www.clicktoattend.com/?id=142063

Session 1 (6:00 PM to 7:10 PM):  Understanding and communicating business-orientated disaster recovery  concepts and objectives

So you have a database maintenance plan that does a backup of your databases and you’re pretty sure that it works fine. But is that really enough? Are you sure that you will be able to meet your service level agreements if and when disaster strikes? This session will explain the need for understanding and communicating business-orientated disaster recovery concepts and objectives to the business stakeholders. This will include defining your RPO and RTO and how it affects your disaster recovery plan.

Session 2 (7:20 to 8:30 PM):  Disaster Recovery for the Paranoid DBA

In the first session, much have been said about disaster recovery in general. In this session, we will look at bringing the concepts down to SQL Server. This session will focus on dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, page-level recovery and a thorough understanding of how to troubleshoot a “Suspect” database.

Edwin M. Sarmiento

Speaker Bio:

Edwin M. Sarmiento (MVP for SQL Server) works as a Senior SQL Server DBA/Systems Engineer for The Pythian Group in Ottawa, Canada. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – “To help people grow and develop their full potential as God has planned for them.”.

Refreshments:

Pizza and pop will be provided.

Note: No one will be admitted by building security after 5:55 PM, and the event will start promptly at 6:00 PM.

OttawaSQL.net is a community group of Ottawa area developers and IT professionals.  We share an interest in Microsoft’s data technologies especially:  SQL Server, SharePoint, PerformancePoint, Workflow Foundations, LINQ, ADO.NET and Entity Framework.

September Events for OttawaSQL.net

posted on

Here is a list of training events going on in September for the OttawaSQL.net group

www.OttawaSQL.net

This month we are happy to announce 3 excellent SQL Server training events in Ottawa at the Microsoft office.  Check the RSVP link for event details.

September 17th Evening:
  • Presented by the Ottawa Windows Server User Group
  • Topic: How to protect  SQL Server using Microsoft System Center Data Protection Manager 2007 SP1 (DPM)
  • Speaker: Islam Gomaa
  • Time: 6:00 PM to 8:00 PM
  • RSVP: http://www.clicktoattend.com/?id=141173
September 21st Lunch:
September 23rd Evening:
  • Unleash Management Studio 2.0, Don Kiely
  • SQL Server Efficiencies: Sparse Columns and Filtered Indexes, Don Kiely
  • Speaker: Don Kiely
  • Time: 6:00 PM to 8:30 PM
  • RSVP: http://www.clicktoattend.com/?id=141029

OttawaSQL.net is a community group of Ottawa area developers and IT professionals.  We share an interest in Microsoft’s data technologies especially:  SQL Server, SharePoint, PerformancePoint, Workflow Foundations, LINQ, ADO.NET and Entity Framework.