I am getting ready to do bunch of presentations this weekend and I realized half my computers were running the rc of Sql 2008

So I decided to got to the site and downloaded and selected to install SQL Exrpress 2008.

Went to look for SQL Server Express Management Studio Express 2008 annnnnd nothing!

Few search engine searches later and no clear direction found this on SQL Express home page:

You can manually download and install any edition of SQL Server 2008 directly from the Microsoft Download Center:

• SQL Server 2008 Express
• SQL Server 2008 Express with Tools
• SQL Server 2008 Express with Advanced Services

Which edition of SQL Server 2008 Express is right for you?

SQL Server 2008 Express is available in the following 3 editions (each is available from the Install Wizard):

• SQL Server 2008 Express
  • SQL Server database engine - create, store, update and retrieve your data
• SQL Server 2008 Express with Tools
  • SQL Server database engine - create, store, update and retrieve your data
  • SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
• SQL Server 2008 Express with Advanced Services
  • SQL Server database engine - create, store, update and retrieve your data
  • SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
  • Full-text Search - powerful, high-speed engine for searching text-intensive data
  • Reporting Services - integrated report creation and design environment to create reports

So make sure you download the SQL Server 2008 Express with ToolsSql

Though I save some people some time.

One last thing:

Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
Step 2 Download and install Windows Installer 4.5.
Step 3 Download and install Windows PowerShell 1.0.

I love data...It holds so many interesting secrets just waiting to be mined out and taken advantage of. If you haven't looked into space before the time is now and its never been easier.

Start to read Lynn Langit's Blog She is the BI Queen, and posts solid information that you will need like this great post on  BI.

http://blogs.msdn.com/socaldevgal/archive/2008/08/27/sql-server-2008-data-mining-in-the-cloud.aspx

Her book a great place to start as well

http://www.amazon.com/Foundations-Server-2005-Business-Intelligence/dp/1590598342

Enjoy!

Spatial it taking root.. Well more like people are starting to realize that spatial rocks and that all data takes on new meaning once you take in its spatial aspect. Representing your data is like seeing your 3D after viewing the world in the 2D for your entire life. Some may say that this is exaggerating but wait until your data tells a 3D story.

So Lets start to dig into spatial.

3D vs 2D

The world is three dimensional object yet most of things we use to view are in 2d. For instance a paper map or a computer screen. Luckily for us we have Virtual Earth and SQL Spatial which takes in both 3D(geography) and 2D(geometry) shapes and types and displays in them in ways that we can visualize them both.

A great visualization from Hanes that shoes the 2D vs 3D visualization

Coordinate System

The next thing that never keep in mind is the coordinate system. I never am always amazed at the amounts of different coordinate systems that are out there. I have worked with at least 5 different coordinate systems and there are some that are so complex and so ridiculous that i never seem to start laughing.

For these articles we are going to be using the "WGS84 coordinate system have to consider an ellipsoidal shape of the earth and they can be described as either Cartesian coordinates or through latitude and longitude. Latitudes can have values between +90 and -90 degrees where 0 is at the equator and longitudes can have values between +180 and -180 degrees where 0 has been defined as a place in the Royal Observatory in Greenwich / United Kingdom. As mentioned earlier Virtual Earth in 2D-mode can only work between +85 and -85 degrees because of the Mercator projection."

So now that we have our basic understanding of 2d vs 3d maps we have or coordinate system lets dig into the SQL spatial

I am presenting at FREE day-long event at the Microsoft Irvine,CA office all around SQL Server 2008.  There will content for both Developers and for ITPros.  If you are interested in attending, please register at www.firestarterevents.com

My presentation will be a two part one on virtual earth and the sql server 2008 geo spatail types. Its going to rock!

I  have been burned by jumping into betas and CTP's before, but I am having major problems with not being on top of the geo-spatial data types in SQL server plus I think I might be doing a doing a presentation on this soon. So i took the plunge.

First Step install the thing..   You can download it here
http://download.microsoft.com/download/3/1/5/315b8683-3765-4426-96ec-179360abb82f/Download_Instructions_ENU.htm

Well that's really more of a download page, but you'll get the idea once you get there. I am running a 32 bit version of vista so it x86 version for me.

It rather big so it took me about 20 minutes to download at my office.

The next couple of shots are my installation.

Step 1) Installation Center

The installation Center? This totally new.  I am guessing this is due to the fact that its a CTP..But in a way i like it.

Step 2) Feature Selection

Yeah I don't need the replication settings. But the rest is like being in a candy shop..Mmm BI Studio...That sounds tasty..

Step 3) Instance Configuration

MSMSQL 0 Wow just when I thought I was getting good with 9.2.3042.00... I am all about the default on this one. I know I am going to uninstall this in a matter of a month when they release the RTM.

Man that was such a great build way better then 9.2.3041.00..

4) Ok this party was a bit tricky...My thoughts on this are this. I am installing this on my laptop. On one hand i want to have it all so I can get all the goodies at the same time I don't want my laptop to take a hour to start up so I disabled all but the browser and the Engine. Why on my laptop? Well I need to presentation on this i am going to need it. I tried all the service accounts use the sa account .. Yes i know this is not the good, but at this point I am just trying to get this up. It didn’t really work anyway's. So then i just set the username to nt Authority and it seemed  to take it all. Something about this is fishy.

5) Database Engine Configuration

Pretty Standard Stuff here

6)  Analysis Services Configuration

Pretty Standard stuff i am just setting up real basic permissions here.

7) Reporting Services

I really need to get more into this.. Its about 4th on my list to do a deep dive.

8)   Errors and reporting....

Something about anonymous never really feels anonymous...Just kidding i checked it before i continued. Its a CTP they need all the help the can get to make the product awesome.

9) Sweet Lets do it...

10)  Install Away

About 45 minutes or so later...I looked over and it was done.. You have to restart but all in all it was pretty painless...

The Only New Screen that i wasn't comfortable with was the server configuration screen. I have a feeling that is going to come back to bite me.

What's New...more to come but i wanted to see what was up with the BI Set

Business Intelligence

Clicking on the Business Intelligence Dev Brought up Visual Studio....

But Inside my favorite IDE was this little edition

T

This of course Makes sense.

Object Explorer

I am already loving the built in Intellisence its awesome. Minus the case sensitive part. i am going to have to turn that off.

You can see all the new stuff in here...Loving the resource Governor already..Now if only i could govern my resources more tightly..I can see it now..Sorry baby your limited to 20% of the clock cycles..I would give more but my main job is keeping me busy right now..lol

Well that's it for now..