Thursday, November 25, 2010

Denali gets installed on Windows 7 but...

I have VS 2008 SP3 and Microsoft Visual Studio 2010 Express on my machines as well as a number of SQL Servers including 2008, 2008 R2, and Express.

After installing Denali the integration services does not work. There are three types of templates for using SSIS with Visual Studio 2008 and none of them work. Looks like when you install Denali on a machine with SQL Server 2008 or 2008 R2, the integration services package cannot be created as the program becomes inoperative as the earlier version is not supported anymore. The option therefore is to place the program on a virtual machine.

Review the error messages for the three templates for creating a package or use SSIS import template:

With Integration Services Package :

With SSIS Project Wizard: Whatever it means?

With Integration Services Import Project wizard:

Strange things with Microsoft LightSwitch

This is the second time this happened. I try to create a Microsoft LightSwitch project and this warning pops-up.

However I know that Microsoft Silverlight 4.0 tools for Visual Studio is already installed. I do not know why this pops-up again.
 To get along with what I am doing I download and install again (this takes more than 30 to 40 minutes). The LightSwitch starts working again. This is queer.

After downloading and installing the downloaded file I tried to create a project with the same name I had used earlier. The program says it already has a program by that name. I think the first warning is not very well placed in the Beta program. You may discard it without any penalty.

Wednesday, November 24, 2010

Denali installs easily on Windows 7 Ultimate

Denali is the code name for the next version of SQL Server -SQL Server 2011 which is in CTP 1. I added a post about it a  few days ago in this blog.

You can download it from here:

You run the setup.exe in the folder where you unpack the contents of the download.

I have Windows 7 Ultimate on an Aspire 4810TZ-4011 notebook which also has a number of SQL Servers both Enterprise evaluation as well as SQL Server Express.

This time I installed a named instance Hodentek3\Alaska and after starting the install I went to bed and in the morning I saw success staring out of my notebook. No problem at all.

Here are some screen shots,

Monday, November 22, 2010

Houston based SQL Azure DB Manager on Windows Azure

In my previous post on Houston I had mentioned how easily Houston manages SQL Azure with its coool looking web interface providing capabilities not present in SSMS. Microsoft has taken Houston to integrate SQL Azure Services with the Windows Azure with a brand new interface. The SQL Server instance management got so much easier with this nice addition.

The new Silverlight based, Wizard driven portal integrates all of Windows Azure giving you a new database manager (cloud hoisted 'Houston'). This should be available soon.

For details listen to the Tech Ed Europe 2010 video by David Robinson here.
COS222 - What’s New in Microsoft SQL Azure

Wednesday, November 10, 2010

Microsoft Trading Platform M4 Silverlight Edition is ready to download

It's not evaluation software but real stuff requiring real cash like ~$7000.00

Find details at Modulus here.

It's a platform agnostic  browser app with the look and feel of a desktop app.

This info from Modulus noted here:

"M4 SL is affordably priced at $6,799 for use on one domain. This price includes C# source code, a license for StockChartX WPF and StockChartX SL, free setup via Remote Desktop, 6 months of email technical support and one year of source code updates (renewable on an annual basis)."

Test drive Denali (SQL Server 2011) with pervasive insight

This version 11.0.1103.9 of SQL Server 2011 CTP1 was published recently 11/8/2010

Get this CTP1 version of SQL Server 2011 code named 'DENALI' from here.

File name for x86 is SQLFULL_x86ENU.exe (1296.9 MB)

An ISO and an exe file for x64 are also available from the same link.

As advertised highlights:

Enhanced mission-critical platform
Developer and IT Productivity
Pervasive insight

Supported Operating Systems are:
Windows 7;Windows Server 2008 R2;Windows Server 2008 Service Pack 2;Windows Vista Service Pack 2

Hardware for x32:

Intel or compatible 1.0 GHZ processor, ~1GB RAM and ~2.2GB Hard disk OK

Tuesday, November 09, 2010

Microsoft Trading Platform on your desktop

Microsoft is partnering with Saxo Bank of Denmark to offer a trading platform according to Financial Times (FT) launching tomorrow. I hope this investment bank known for its success in internet brokerage (according to WikipediA) provides the proverbial Midas Touch to Microsoft's various products and thereby its share holders (disclaimer: I don't own MSFT stocks).


Trade over 11000 stocks On 23 world exchanges
Fundamental Analysis
Powerful stock screener
Diversify  risk Management etc.

Perhaps early next year a trading platform on the cloud!!!

Friday, November 05, 2010

Office 365 coming to a cloud near you

Microsoft's star product Microsoft Office gets launched to the cloud soon as Office 365.

Summary of what is offered:

Microsoft's star product Microsoft Office gets launched to the cloud offering the following services:
  • Office Professional Plus
 Accessible from all hardware platforms-PC, Phone and Browser
  • Exchange Online
 All your emails, calendar and contacts with anti-virus and anti-spam features
  • Sharepoint Online
 All sharing between colleagues, partners and customers
  • Lync Online
 Instant messaging, video conferencing, online meeting etc.

Key benefits of Office 365 (according to MSFT):

  • 24/7 IT-Level Phone support
  • Get up and run faster with migration tools
  • Server patching, updating all gone
  • Variable pricing to fit your pocket

Thursday, November 04, 2010

Now you have SQL Azure Reporting Services in the Cloud

At the PDC on October 28th Microsoft announced two new features for SQL Azure Reporting CTP and SQL Azure Data Sync CTP2.
You can embed cloud based reports using SQL Azure Data. You use the familiar SSRS to author reports and use it on-site or, up on the cloud (you can have your cake and eat it too!).
SQL Azure Sync CTP2 enables synchronization between on-premises SQL Server and SQL Azure. Now you have it both ways.
If you are new to SSRS I strongly recommend my book,
If you are new to SQL Azure you can order my book from here,
Do you want to have your own free copy? Follow this link here: Protection Status