Todd's Blog

Todd's Tips for System Adminstrators

Connect

OttawaSQL.net User Group Event – Thursday February 12th, 2009

posted on

clip_image001[4] 

Thursday, February 12th 5:45 – 8:30 PM

Free Evening Event @ Microsoft Ottawa

 

Feature Session: You can do *that* with Entity Framework?, Julie Lerman

OttawaSQL.net in partnership with the Ottawa .NET Community is proud to announce Julie Lerman’s session on the ADO.NET Entity Framework.

The ADO.NET Entity Framework is Microsoft’s new data access technology that can change the way you perceive and work with your application’s data. Julie will present a very high level overview for newbies then dive into some of the not quite so obvious things that can be done with Entity Framework such as adding business logic to entity classes, writing generic (reusable) code, taking advantage of Entity SQL and working directly with foreign key values.

Speaker: Julie Lerman, The Data Farm

clip_image003[4] 

Julie Lerman

Julie Lerman is an independent consultant and .NET Mentor who has been designing and writing software applications for over 20 years. Julie is well known in the .NET community as a Microsoft MVP, ASPInsider and INETA Speaker. Julie lives in Vermont where she runs the Vermont.NET User Group.

clip_image005[4]

Julie is the author of O’Reilly’s “Programming Entity Framework” (available for pre-order at Amazon.ca). You can read Julie’s blog at www.thedatafarm.com/blog. She is a prolific blogger, a frequent presenter at technical conferences around the world and author of articles in well-known technical publications.

Product Showcase: RedGate Software’s SQL Refactor, David E. Myers

clip_image006[4]

SQL Refactor is an excellent choice for any SQL developer’s tool kit. David will demonstrate the ‘Layout SQL’ feature that increases productivity by formatting T-SQL code quickly and consistently across the development team. He will also show the capability for applying changes to database objects while effortlessly keeping dependant objects in sync.

Speaker: David E. Myers, Upper Canada District School Board

David is a DBA and SQL Developer and is the OttawaSQL.net Executive Director for 2008. He primarily works with SQL Server but is increasingly working with the SharePoint Business Data Catalog and Microsoft BI technologies. David recently presented at Tech Days Canada 2008 in Montreal and Ottawa.

 

clip_image008[4]

David E. Myers

 

Location:

Microsoft Ottawa, World Exchange Plaza

100 Queen Street, Suite 500, Ottawa

 

Registration:

 

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

Arrival:  5:30 PM to 5:45 PM

Product Showcase: 5:45 PM to 6:00 PM

Feature Session:  6:00 PM to 8:30 PM

Refreshments: Pizza and Pop

 

Event Sponsors:

clip_image009[4]

clip_image010[4]

SQLTeach Special Event: BI Boot Camp, March 9th to 10th in Ottawa!!!

Use our group’s rebate code OT00SQLNET to register and save $100 off the $999 registration!

Business Intelligence is one of the topmost IT priorities and is increasingly pervasive within organizations large and small. Business Intelligence touches many aspects of our daily lives, from enhancing our online and retail shopping experience to the healthcare we receive. BI also impacts the quality of decisions that business leaders make.

The 2 day (March 9-10, 2009) boot camp has been designed to give you a head start in Business Intelligence practice. You will acquire fundamental knowledge of Business Intelligence and dimensional modeling along with understanding on how to use the various Microsoft technologies to implement a BI solution.

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.

January 22 – SQL Server 101 for the IT Pro & SQL Server Chalk Talk

posted on

Note this was the event planned for December 11, 2008.

Topic: SQL Server 101 for the IT Pro & SQL Server Chalk Talk

SQL What?!?  What every IT Pro needs to know about SQL Server

More and more products require a SQL Server database.  Are you an IT Pro installing SQL Server but not sure how to support it?  Do you work at a place where you are the IT department?  Well this event is for you!

The OWSUG and OttawaSQL.net user groups are teaming up to bring you a special session dedicated to SQL Server for the non-DBAs.

We will cover important topics that are often overlooked until it is too late, and talk about ways to simplify SQL Server administration.

Topics include:

· Backup and Restore

· Checking for data corruption

· Creating Maintenance plans

· Sending alerts

· Setting up email for notifications

· Security Basics

· Tips and Tricks, and time saving tools

… and much more!

After the presentations we will have a panel of local DBAs, SQL Server veterans and Microsoft MVPs ready to answer your questions in an informal SQL Server Chalk Talk

Product Showcase (15 minutes):   SQL Response – Red Gate Software, David E. Myers

clip_image001

No flashing lights. No repetitive emails. No complicated configuration required. Only the intelligent alerts and diagnostic data you need to resolve problems on your SQL Servers sooner. All from a single, intuitive interface.  SQL Response monitors the health and activity of your SQL Servers, so you can work proactively to resolve the problems that matter most. See how no-nonsense monitoring from Red Gate’s new SQL Response™ can help you make the most of your office hours.

Location:


Microsoft Canada Co.
100 Queen Street Suite 500
Ottawa, Ontario
K1P 1J9

Date: December 11th, 2008

Agenda:

5:00 p.m.  Event registration
5:30 p.m.  Presentation
7:30 p.m.  Q & A
8:00 p.m.  Door Prizes

Notes: Pizza and Pop will be served, Please RSVP to help us order enough of both.

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

Upcoming December IT Events in Ottawa on December 10th and 11th

posted on

December 10th, 2008 5:30 PM to 8:30 PM:  Ottawa .NET Community Presents – Layered Architecture: Beyond Object Programming

Designing and implementing a layered architecture is no easy feat and getting it right takes a lot of practical experience. On Wednesday December 10th, Mario Cardinal will be coming in from Montreal to share his architectural expertise with us on this subject. This presentation will be of particular interest to intermediate and senior developers that want to hone their architectural skills. We welcome you to join us for this evening event and partake in the presentation. To register, simply send an email request to [email protected]. We look forward to seeing you soon.

December 11th, 2008 5:00 PM to 8:00 PM:  OWSUG and OttawaSQL.net Presents – SQL Server 101 for the IT Pro & SQL Server Chalk Talk

SQL What?!?  What every IT Pro needs to know about SQL Server

More and more products require a SQL Server database.  Are you an IT Pro installing SQL Server but not sure how to support it?  Do you work at a place where you are the IT department?  Well this event is for you!

The OWSUG and OttawaSQL.net user groups are teaming up to bring you a special session dedicated to SQL Server for the non-DBAs.  We will cover important topics that are often overlooked until it is too late, and talk about ways to simplify SQL Server administration.

Topics include:

  • Backup and Restore
  • Checking for data corruption
  • Creating Maintenance plans
  • Sending alerts
  • Setting up email for notifications
  • Security Basics
  • Tips and Tricks, and time saving tools

… and much more!

After the presentations we will have a panel of local DBAs, SQL Server veterans and Microsoft MVPs ready to answer your questions in an informal SQL Server Chalk Talk

Registration: http://www.clicktoattend.com/?id=133776