June 2007 - Posts
Michele Leroux Bustamante, MSDN Regional Director for San Diego, and WCF extraordinaire is giving a series of Webcasts on WCF. If you haven't worked with WCF before or you are looking to pick up some great tips this will be a great Webcast series for you to tune into.
You can get more information on the series along with links to register for all sessions here:
http://www.dasblonde.net/2007/06/24/WCFWebcastSeries.aspx
You can also catch her this weekend at the San Diego Code Camp talking about WCF and CardSpace.
Developers, Administrators, Architects, and IT people of all flavors across Southern California will be converging on the UCSD Extension Campus in La Jolla this weekend for the San Diego Code Camp. This is the second Code Camp for San Diego and fourth for the Southern California region.
The San Diego Code Camp has a great mixture of sessions covering multiple area of technology. The event is always a great place to pick up some new knowledge or refresh some old ones while being able to interact and get to know your fellow developers. And to help you interact with your fellow developers, the San Diego Code Camp is setting the bar high when it comes to Geek Dinners with not only great food, but also great entertainment with two rock bands..
Oh yeah, and it's all FREE. What more can you ask for?
Go to the Code Camp Website and make sure that you are registered to attend.
So I just had to get SQL Server 2008 installed and get it up and running.
I had a Windows XP SP2 Base Image so I figured I would start with that since I am going to be doing mostly development with it. At some point I will probably install a version in a Server 2003 VPC and then just connect to that. Unfortunately the Base Image was a little out of date so I had to spend a few rounds with Windows Update to get everything patched and ready. Be sure to look through the Install Requirements located here: http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=6835. (Note: You have to be registered with Microsoft Connect for the CTP for this Download to Work. You can do that HERE.)
- Windows Update installed the following which are required
- .Net Framework 2.0
- Internet Explorer 7
- Installed IIS and setup IIS to use ASP.Net 2.0 as the default.
- Backup VHD
- First attempt at running Katmai Install (Installing from the ISO Image)
- System Configuration Checks are all green - Success!
- Uncheck the Samples and Books Online. Not really clear, but based on the Read Me it seemed like it was best to install these separately.
- Take the rest of the defaults and away we go.
- And everything is installed with no errors.
- Install Books Online
- Install Sample Databases from Code Plex. Link (Click on the SQL Server Katmai Link in the Upper Right)
I chose the AdventureWorksDBScripts.msi to install the Databases and the Samples. - The MSI only unpacks the scripts so you will need to run the scripts just like you did when you reinstalled in 2005.
- Find the instawdb.sql file and open in SQL Server Management Studio. The directory is:
C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks OLTP\ - Do a search for "set @data_path"
- You should find a line with the following "SET @data_path = @sql_path + 'AWDB\';"
- A few lines below that you will find a line that is commented like:
SET @data_path = 'C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP\';
Uncomment that line and change the "90" to "100" - Once the script is finished, refresh your databases in the Object Explorer and Voila! - Adventure Works
- Run your first query in SQL Server 2008 - Katmai!
Overall, the setup went very smooth. In fact, I spent most of the patching my VPC image before installing. I hope this helps someone work through the steps of getting SQL Server 2008 up and running. My experience was very good (Way to go Setup Team) so I hope you have the same seamless experience. I welcome the feedback if for some reason I missed a step or you have any questions on my steps. Just post a comment.
Some tasks for later installs are to install the Adventure Works Data Warehouse Tables and install Team Suite with the latest Team Data bits on there. Then I will really be able to have some fun exploring the new features in this release.
For all you Database lovers out there like myself Monday was a big day as the covers were pulled back on SQL Server 2008 and the first public CTP was made available. If you are looking for some of the links here are a bunch
CTP Downloads including Documentation, Whitepapers, and Webcasts
https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
Katmai MSDN Forums
http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=428&SiteID=1
SQL Server Future Version Product Page (Some good videos here)
http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx
Give your Feedback on Katmai through Connect
https://connect.microsoft.com/SQLServer/Feedback
Upcoming Chats and Webcasts (via Euan Garden's Blog)
Chats: http://www.microsoft.com/technet/community/chats/default.mspx
Webcasts: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5553
I am sure there will be much more coming out in the coming weeks. I wish I could be there to get all the information first hand, but I guess I will have to settle for the Webcasts and articles coming out. It's going to be an exciting time to be a SQL Server Fan.
I So this post is a little long in coming, but better late than never I guess. I had a great time going up to Portland to speak and attend the Portland Code Camp. There was a bunch of great things about the Code Camp, but I wanted to highlight some of them:
- Great Leadership Team - Jason Mauer and the rest of the team up there put together a great lineup of sessions and speakers.
- Awesome Attendees - There was a great group of people that I got to meet during the sessions, lunch, and the Geek Dinner
- Very Nice Facilities - The Code Camp was held on the campus of Washington State University in Vancouver. The campus was absolutely beautiful and the facilities were fantastic both as an attendee as a speaker. A big thanks to the University for being a great supporter of the Code Camp.
- Geek Dinner - We had a great time on Saturday night at The Kennedy School. It was quite unique to be drinking at a former grade school. They had good food and drink (just avoid the Ruby beer) and the company for the evening was great.
I had a great crowd for the both the T-SQL Talk and the SQL CLR were both great and we had good discussions in each of the sessions. It was good to see a lot of interest in SQL Server and also the other great SQL Server sessions that were at the Code Camp. I have uploaded the slides and code samples from both of my talks and you can download them from HERE.
I would like to give a big round of applause to everyone involved in organizing the Portland Code Camp and also to the great attendees. Makes me even more excited for San Diego Code Camp!