Todd's Blog

Todd's Tips for System Adminstrators

Connect

User Group Event:SQL Server 2008 R2 Reporting Services and Self-Service Analytics

by

Session 1:  Introduction to SQL Server 2008 R2 Reporting Services and SharePoint 2010 Integration

David E. Myers

Speaker: David E. Myers

Ever since business applications were introduced, there was a need for great data reporting tools.  With the release of SQL Server Reporting Services 2008 R2, Microsoft has made a stronger case than ever for investing in their reporting solution.  In this session David will provide an overview of SQL Server 2008 R2 Reporting Services with a focus on the key value proposition, core architecture, development tools, and integration with SharePoint 2010. [Read more…]

Deployment Deep Dive on Windows 7

by

Are you running Windows XP?  Are you feeling the pressure of creating a deployment plan? Have no fear!  Leveraging learning’s from two Windows 7 early adopters this session will give you the skills you need to proceed with your own deployment.  The session will focus on free Windows 7 deployment planning and deployment tools that customize operating system packages and automate deployment planning and network deployments seamlessly. We will dive right into:

  • How to use the Microsoft Assessment and Planning (MAP) tool to identify your current hardware and application inventory.
  • How to use the Windows Automated Install Kit (WAIK) to build a customized image for your organization.
  • How to use the Microsoft Deployment Toolkit (MDT) to build, deploy and maintain Windows installation images.
  • How to migrate the end users profile from their current installation to the Windows 7 installation using the User State Migration Toolkit (USMT).
  • How to integrate MDT and Windows Deployment Services (WDS) to perform Lite Touch installations of Windows 7.

Finally we will look at how we can leverage the various tools to solve any application compatibility issues you might encounter.  We will look at how you can overcome common obstacles using the Application Compatibility Toolkit (ACT), or larger obstacles using Windows XP Mode and Microsoft Enterprise Desktop Virtualization (MED-V) and even how you can leverage Application Virtualization (App-V) to streamline application deployment and ensure all your applications work!

Please note: there is no cost to attend this event.

Speakers:

Todd-Headshot
Todd Lamothe

Todd is a Systems Administrator for the County of Lennox & Addington, Information Services Department. Supporting the Information Technology needs of the Libraries and Museum throughout their 12 points of service, he is responsible for managing and maintaining the entire IT infrastructure from server to desktops.

With over 10 years’ experience, Todd has a vast depth of knowledge with Microsoft technologies. Todd is a Windows Desktop Experience MVP, a Microsoft Certified Trainer and is involved in the IT community in both Kingston and Ottawa.

David-Headshot

David E. Myers

David is an IT professional and developer at the Upper Canada District School Board (Brockville, ON).  He primarily works with SQL Server, SharePoint and Windows Client / Server infrastructure, but like many Canadian IT professionals he wears many hats.  As a SQL Server MVP and a member of Microsoft’s Springboard Technical Experts Panel (STEP) he is constantly looking to connect with people that share his passion for technology.  In his spare time David works as a contract Microsoft Certified Trainer in the Kingston and Ottawa areas.

Location:
Kingston Frontenac Public Library
Calvin Park Branch – Community Room
88 Wright Cres
Kingston, Ontario K7L 4T9

Agenda:
6:00 p.m.  Event registration
8:20 p.m.  Q & A

8:30 p.m.  Door Prizes

Registration:
http://kitpro.eventbrite.com

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

OttawaSQL.net December Event: SQL Server Linked Servers and Failover Clusters

by

www.OttawaSQL.net

December 3rd Evening Event

Session 1: Setting Up and Using SQL Server Linked Servers, Jean Sigouin

Session 2: DemoFest – SQL Server 2008 Failover Cluster on Windows Server 2008, Edwin Sarmiento

Date: Thursday, December 3rd, 2009

Time: 6:00 PM to 8:30 PM

Venue: Microsoft Ottawa Office

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

Event Sponsors:

dreamdigital.comopulentasp.com

Pizza and pop will be provided by our event sponsors Dream Digital ( dreamdigital.com ) and Opulent ASP Development Inc. ( OpulentASP.com )

Session 1: Setting Up and Using SQL Server Linked Servers, Jean Sigouin

Having access to data, wherever it might be is critical for business.  In a world where data is stored and distributed onto multiple database servers and multiple server platforms, it’s important to have the tools to bring it all together in a seamless, integrated point of access.  The goal of this session is to show the DBA how to use SQL Server’s “Linked Server” capabilities to build bridges between a SQL Server instance and separate SQL Servers, Oracle, Access, Excel and pretty much any other data source out there.  You will see how to retrieve, combine and modify data from a linked SQL Server.  Techniques to abstract linked server objects to improve usability and simplify queries will also be covered.

Jean Sigouin

Speaker Bio:

Jean Sigouin began his career as a software and database designer at an aerospace company then continued at a biomedical high-tech manufacturing company.  Jean has been working in IT for 20 years as a DBA, software architect, business analyst, development team manager and developer.  He has been a SQL Server consultant for the last 2 years.  Jean has been administering SQL Servers and developing databases for the last 15 years.  Jean has expertise in designing large databases tuned for highly transactional OLTP database systems, SSIS, SSRS, SSAS, T SQL coding, database tuning & optimization, replication, administration and disaster recovery.

Session 2: DemoFest – SQL Server 2008 Failover Cluster on Windows Server 2008, Edwin Sarmiento

This session is all about demos – providing step-by-step instructions on how to install SQL Server 2008 Failover Cluster instance on a Windows Server 2008 cluster.

Edwin 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.”.

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.