Tuesday, August 31, 2010

Hook up with SQL Azure using Microsoft LightSwitch

Jump start on Microsoft's latest RAD developmental tool - the Microsoft LightSwitch.It is still in Beta but looks very cool. You have data sources and screens. Hook them up and you are done. It has screens that are representative of most of the likely usage scenarios such as searching, point to parent and all the children show up, edit data, etc. You hardly need to write code for most of the common business use. In case you want to write code, you could. There are lot of events to which you can hook up code. I used VS 2010 Express and some coding is limited but I understand with a better VS versio you can do a lot more.
Before you do the big things get a head start knowing about this interface. Read this article and jump start on LightSwitch.
Start here and if you have a problem send me an email

Sunday, August 29, 2010

Importing Geospatial data from MS Excel 2010 to SQL Server 2008 R2

Capturing geo-spatial data from web pages is something that Excel can do very well and processing of geo-spatial data is a new capability that became available in SQL Server 2008 R2. With Bing and Maps new applications are possible.
Getting data from MS Excel to SQL server 2008 R2 is very easy with the Export and Import wizard.
This article shows how you would bring in geo-spatial data from an MS Excel 2010 Spread Sheet file to a database table in SQL Server. As SQL Server 2008 R2 supports geo-spatial data it is very easy to process it on the SQL Server. SQL Server Import and Export Wizard is used.
 
The SSWUG article can be viewed free by registering as a guest and well sign up as well and get the full benefits.

While you are visiting SSWUG read this other article on Geo-Spatial data :

Saturday, August 7, 2010

Installing AdventureWorks Sample Databases

AdventureWorks  is one of the common sample databases used in Microsoft Database related programming or, in Visual Studio applications. What started off as a single database has grown into a big family and together with this, the installation procedure has undergone a lot of changes. The days of attaching and detaching sample database files are gone. The WinZip installer kicks off the installation.

Recently I wanted to work with PHP training kit which required a SQL Server 2008 Express with a AdventureWorks database. The download link on the Configuration Wizard-PHP on Windows Training kit took me to a dead end (Trust me this happens a lot with Microsoft documentation). Finally, I thought just that any AdventureWorks would do and downloaded the AdventureWorks2008R2_RTM.exe (82.3 MB ) from CodePlex site and installed it on the brand new SQL Express 2008 (SQLEXPRADV_x86.enu.exe). Although it did not provide the right (Which, I don't know what? As yet) AdventureWorks, I could see how the installation procedure has changed.

The installation took 35 minutes. It took 100% of the CPU and 76% of physical memory during installation and installed a bunch of AdventureWorks databases for all kinds of end users. Here are some screen shots of the installation.






















Look at all the AdventureWorks databases in this image.