Todd's Blog

Todd's Tips for System Adminstrators

Connect

Setting the Time Source for the Domain on Windows Server 2008

posted on

I upgraded my domain controllers to Windows Server 2008 and am now in the process of decommissioning the old servers. Since moving the FSMO roles over to the new server, the new server started warning me that the time source was not set on this machine. Okay, I know in Windows Server 2003 I had to make some registry settings, but surely to goodness Microsoft has since corrected this in Windows Server 2008.

I hit the Internet and did a search and found a good source on Microsoft Technet on this very topic.

http://technet2.microsoft.com/windowsserver2008/en/library/92a73b00-12b7-49d0-b6be-007e626f387d1033.mspx?mfr=true

If you transfer or seize the PDC emulator role to another server, you will need to repeat this on the machine you move the PDC Emulator role to. Here are the steps that I performed on the server holding the PDC emulator role.

  1. At the elevated command prompt enter the command: w32tm /stripchart /computer:time.nrc.ca /samples:3 /dataonly 
  2. Ensure that UDP traffic on Port 123 is allowed through the firewall. 
  3. At the elevated command prompt enter the command: w32tm /config /manualpeerlist:time.nrc.ca /syncfromflags:manual /reliable:yes /update

 

What this does is set my PDC emulator to use the Canadian National Research Council’s NTP server which is a stratum-2 server. For a list of public NTP servers you can use, the NTP Public Services Project has a good list of public NTP servers.

Upcoming OttawaSQL.net Event – SQLTEACH would like to give you a FREE registration to SQLTEACH 2008 in Toronto!

posted on

Here is an banner for the upcoming OttawaSQL.net user group meeting on April 24th. It is the first event by this newly formed group and we are very fortunate to have SQLTEACH offer a free registration to a user group member who steps up and shares some knowledge. Check out banner below to get all the details.

image

Free Evening Event @ Microsoft Ottawa

Thursday, April 24th  5:30 – 8:30 PM

Business Intelligence Foundations & ETL Architecture

with SQL Server Integration Services

Session 1:  BI Foundations with SQL Server Integration Services, Christian Cote

BI solutions are all about providing the right information, to the right people, at the right time.  SSIS is a powerful tool designed to address the challenge of unlocking the silos of data that exist within most organizations.  Christian will introduce BI concepts, from data modeling to data warehouse implementation and will provide an overview of SQL Server Integration Services as an ETL toolkit.

Session 2:  Architecting an ETL Framework with SSIS, Christian Cote

Over 70% of the effort in a BI project implementation is spent on the ETL programming tasks.  Christian will demonstrate how a good ETL framework is essential in any large BI project; share ETL and SSIS best practices; and provide insight into an ETL framework implementation that he architected with SSIS.

image

Speaker Profile:  Christian Cote has spent the last 9 years implementing BI and ETL projects.  He has used a variety ETL methods ranging from applying low level coding techniques to deploying high end ETL frameworks and has worked with a variety of RDBMS products including Oracle and Microsoft SQL Server.  Christian is currently working on his fourth ETL implementation using SQL Server 2005 Integration Services.  Most recently he was a highly acclaimed guest speaker at Ottawa Code Camp 2008!

SQLTEACH would like to give you a FREE registration to SQLTEACH 2008 in Toronto!

clip_image002

Would you like to attend the largest Canadian SQL conference for free?

SQLTEACH is sponsoring a contest for our April event.  You could win a free conference pass to SQLTEACH 2008 Toronto, simply by sharing some of your SQL Server knowledge!

Present for 10 minutes at our April 24th event, on ANY SQL Server topic.

This could be tips and tricks, little known features, TSQL techniques or even great tools or utilities for SQL Server.  The audience will vote for their favourite presentation and the winner will get a free registration to SQLTEACH.

Send your presentation idea by email to: [email protected]  before

April 21st, 2008 for your chance to participate in the contest.  Space is limited!

REGISTRATION:

LOCATION:

RSVP: Event Registration

Registration:  5:30 PM to 5:45 PM

Refreshments: Pizza and Pop

Microsoft Ottawa, World Exchange Plaza

100 Queen Street, Suite 500, Ottawa

EVENT SPONSOR:

EVENT PARTNERS:

image

image image

User Groups in Ottawa

posted on

I cut and pasted this from the OWSUG blog. Enjoy

   

Ottawa IT Groups

Did you know that? 

  • More than a thousand of your colleagues throughout Ottawa and the surrounding area belong to one or more of the Local IT Pro Groups listed below! 
  • All Ottawa IT Pro Groups are not-for-profit organizations that focus on all aspects of technology from software to hardware. 
  • Each IT Pro group is a group of  peers, who meet on a monthly basis to learn and discuss new and existing technologies with industry leaders.

Why should YOU join IT Pro group?

  • We are committed to bringing you seminars and lessons on topics of interest that our members request; 
  • We offer special programs such as study groups and more to come; 
  • By helping our efforts you will be making a difference in the community; and 
  • It’s absolutely free so WHY NOT!?

clip_image002 

  • The Ottawa Windows Server User Group holds monthly meeting on various topics and has an associated study group 
  • To find out more visit www.owsug.ca or contact [email protected].

clip_image004 

  • OttawaSQL.net is a group of Ottawa area IT professionals that share an interest in exploring the data perspective of Microsoft business solutions, products and technologies. 
  • The technical focus of the group is on Microsoft SQL Server but also includes: SharePoint Server, Performance Point Server, Windows Workflow Foundations, LINQ and ADO.NET and more! 
  • To find out more visit www.OttawaSQL.net .

clip_image006 

  • We are a community of developers in Canada’s Ottawa/Gatineau region with a keen interest in Microsoft’s .NET development platform. 
  • To find out more visit www.ottawacommunity.net .

Up Coming Events: 

April 22nd, 2008 (Lunchtime) 

ODNC Lunch & Learn: Effective N-Layering in ASP.NET 

This presentation will focus on tools and techniques associated with the rapid development of ASP.NET applications. It will begin by introducing the concept of N-Layering as explained by Martin Fowler in his book “Patterns of Enterprise Application Architecture”. It will then demonstrate the creation of an N-Layered ASP.Net application with specific focus on 3 real-world scenarios; 

1) ASP to ASP.NET migration where the client does not want the back end (Database) to change 

2) ASP.NET Spaghetti Code refactoring using the existing stored procedures 

3) ASP.NET’s effective use of the ObjectDataSource or LINQ with the Microsoft Entity Framework 

You can register for this event by sending an email to [email protected]. 

April 24th, 2008

OttawaSQL.net and ODNC Present
Topic 1: “Business Intelligence Foundations with SQL Server
Integration Services” Presented by Christian Cote
Topic 2: "Architecting an ETL Framework with SQL Server Integration
Services" Presented by Christian Cote
You can register for this event by sending an email to [email protected]. 

May 29th, 2008

OttawaSQL.net and OWSUG Present
Topic 1: "SQL Server 2008 & Windows Server 2008 High Availability
Technologies" Presented by David E. Myers and Todd Lamothe
Topic 2: "SQL Server 2008 Spatial Data & Microsoft Virtual Earth"
Presented by Lynda Rab and Steve Syfuhs 

For more information, please contact [email protected] .