User Groups | Todd's Blog

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

posted on November 3, 2009

November 12^th Evening Event:

Increase Performance of your SQL Server Applications –

Performance Tuning for Developers and DBAs, Michelle Gutzait

Speaker: Michelle Gutzait

Date: Thursday, November 12^th, 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.

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.

Windows 7 STEP Event in Ottawa

posted on October 25, 2009

Thursday of last week (October 22), David Myers and myself presented the [wpseo]Windows 7[/wpseo] STEP event in Ottawa. It was a full house and one of our larger, if not largest crowd at the OWSUG to date.

As part of the presentation David covered [wpseo]Branch Cache[/wpseo], [wpseo]Direct Access[/wpseo], [wpseo]Bitlocker[/wpseo] to go among other things. I covered the deployment side of things which included[wpseo] Windows Deployment Services[/wpseo], [wpseo]Application Compatibility[/wpseo] and the [wpseo]User State Migration Tool 4.0[/wpseo]. I also helped David out with the [wpseo]Problem Step Recorder[/wpseo] by recording a problem I was having with Calculator.

If you want more information about things we presented on, check out the Springboard site at Microsoft.

Here is a shot of the crowd from the event. Brad took this from his cell phone.

The OWSUG page if the event is located at http://owsug.ca/blogs/brad/archive/2009/10/22/Today_1920_s-Windows-7-Meeting-Rocked-the-House_2100_-AND-Windows-7-Study-group-interest.aspx

October 15th Evening SQL Server DBA Event: Disaster Recovery

posted on October 14, 2009

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

Speaker: Edwin M. Sarmiento, MVP for SQL Server

Date: Thursday, October 15^th, 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.

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.