Thursday, November 25, 2010
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:
However I know that Microsoft Silverlight 4.0 tools for Visual Studio is already installed. I do not know why this pops-up again.
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
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
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
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)."
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
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
Trade over 11000 stocks On 23 world exchanges
Powerful stock screener
Diversify risk Management etc.
Perhaps early next year a trading platform on the cloud!!!
Friday, November 05, 2010
Summary of what is offered:
Microsoft's star product Microsoft Office gets launched to the cloud offering the following services:
- Office Professional Plus
- Exchange Online
- Sharepoint Online
- Lync Online
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
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: