Microsoft Tech-Ed 2008 (Day 3)

Posted: November 6, 2008 in Computer and Internet

First session of today was Diagnosing Errors and Performance problems using SQL Extended Events. Extended Events is started with to sql.exe process on SQL Server 2008, it’s a light weight event engine that can be used for troubleshooting. It seems rather complex but there is a tool available to help you with that. The tool is called Extended Event Manager, more information about this tool can be found here. A useful note a the speaker was that you should make sure that when you let SQL-server create a log file from Extended Events, make sure that the SQL-service account has access to that folder.

2nd session today was Going Cold Turkey on the GUI: Server Core Setup Step-by-Step by Mark Minasi. This was until now the best speaker I saw on Tech-Ed 2008. Very technical and very entertaining. Be sure to check out his blogs and his website.
In this session a Server Core 2008 was fully setup from the command line without using ANY GUI-tools to a Domain controller, DHCP-server, DNS-server and yes you’re reading this correctly, a WINS-server :p. Lots of settings that you would usually set via the GUI can be done in the registry which is available in Windows Server Core (like notepad). Another GUI interface that is possible is to set the time zone of your server, but that’s it.
A great tip in this session was that when you have not set your screen resolution correctly in the registry and your screen goes black, you can start from the Windows Server installation DVD on go the recovery console were you can start the regedit and set new values for the screen resolution. Another option is to use BCD editor to change the startup parameter us Windows and set the /vga parameter so you can reset the screen resolution. BCD is the replacement of boot.ini in Windows Server 2008 and Windows Vista.
The best remote management feature today for Windows Servers is winrm. In time this will probably replace the RPC protocol. It goes over port 80 and no it doesn’t conflict with your webserver port 80. You’ll need to configure winrm on the server and the management station to be able to talk to each other because it isn’t set active by default, but it’s there to use. The listener for winrm can be set active via group policy.

For the remains of the day I spent the rest of the time on hands on lab on Operations Manager 2007 SP1. I’am beginning to get a fan of this product and therefore using these hands on lab to develop my skills on the product. If you stuck there is always a Microsoft Trainer nearby to help you out.

This evening there is a Country drink organized nearby the conference center, so I’ll hook up with some peers for sure :-).


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s