Todd's Blog

Todd's Tips for System Adminstrators

Connect

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.

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.

Windows 7 – Changes to Run As

posted on

David Myers has a great post today on the changes to Windows 7 when using Run As.

For those that don’t know. David and I spent many hours together driving back and forth from the Certification Study Group in Ottawa for a couple of years and we both did our Train the Trainer course for our MCTs together back in 2007. While the certification groups are on a hiatus right now, we still do stuff together through the user groups, OWSUG & .

David has accounts that he uses for SQL Server that he needs to run commands as. With Vista, he had to create batch files for programs that he needed to run as the SQL account. Now with Window 7, he just holds shift when right clicking on the program and now another option shows up, Run As Another User. I never would have noticed this as I have my domain user account that I use for my day to day stuff, and the system will prompt me for the domain admin account to load drivers, apps, etc. I don’t have a need right now to run stuff as different domain user account.

Go check out his blog at DavidEMyers.com and have a look what he’s discovered new in Windows 7.

Great work pointing out that new feature David.