Microsoft and Temenos

Microsoft has penetrated in banking sector and joined hands with the largest core banking software called Temenos, and tested its availability on SQL Server 2008 R2 so now you can run core banking software on SQL Server. Microsoft has tested theT24 environment with windows server with SQL Server 2008 R2 and done successfully this testing using 25 million accounts with 15 million customers over 2000 branches.
Microsoft team test results:
Task                     Average     SQL-T24
Funds transfers     500,000     697,920
Security trades     240,000     323,534

link

A development competition by The World Bank

We’re challenging the public to create innovative software applications that move us a step closer toward solving some of the world’s most pressing problems.

details

Middle East SharePoint Conference 2010

Middle East SharePoint Conference 2010 will be the conference to learn more about Microsoft® SharePoint® 2010, the business collaboration platform for the enterprise and the internet. Learn how to apply the latest best practices for building and deploying solutions on the platform and find out how customers and partners are embracing cloud-based services to create value for their organizations.

details

Windows 7 Launch Party in Bahrain

Keeping our fingers crossed would be shortly announcing a Windows 7 Launch House Party soon in Manama, Bahrain.

Registrations would be opening shortly.

Get Ready for the next best OS from Microsoft.

Windows 7 Launch Party

Thursday, October 22 — Thursday, October 29, 2009

Server: Msg 446, Level 16, State 9 Cannot resolve collation conflict for equal to operation

Collation precedence conflict in SQL Server 2000

The collation precedence rules apply only to the character string data types, char, varchar, text, nchar, nvarchar, and ntext. Objects with other data types do not participate in collation evaluations.
link to article on msdn
A simple example is as follows

create table #TempRO
(
Id  int Identity (1,1),
App_No     NVarchar (100)
)
– insert some values in this table
Select *
from #TempRO T
Inner join App AO
On T.App_No = AO.App_No

We are having the App table using a different collation then the default that is “Arabic_CI_AS”

So the above select will give the following collation error, to remove it we just add the following statement while defining the temp table

create table #TempRO
(
Id  int Identity (1,1),
App_No     NVarchar (100)    collate Arabic_CI_AS
)

This not only happens in temp tables but also in the normal tables or at times if we are comparing columns so its better to use sp_help TableName or the syscolumns to find the collation of the two.

Happy Collating

Microsoft Enterprise Service Bus (EBS)

A glance at the core BizTalk system components used by the Microsoft ESB Guidance.

Microsoft Enterprise Service Bus (EBS)

 

Quick Links:

                    MSDN site: http://msdn.microsoft.com/esb

                    Community Extensions: http://codeplex.com/esb

Internet Explorer 8 RC1 is available.

Internet Explorer 8 RC1 will be available in 25 languages including: Arabic, Chinese (Traditional, Simplified and Hong Kong), Czech, Danish, Dutch, English, Finnish, French, German, Greek, Hebrew, Hungarian, Italian, Japanese, Korean, Norwegian, Portuguese (Brazil and Portugal), Polish, Russian, Spanish, Turkish and Swedish.

Yes you can download it from the following link.

http://www.microsoft.com/windows/Internet-explorer/beta/default.aspx

Well it’s been a long time Microsoft has been investing in Internet Explorer, so some major milestones have been achieved in this release as well. So the RC1 Release of Internet Explorer includes improvements to performance, stability and compatibility.  With this build, there are also enhancements to the fit and finish of the user interface, additional investment in CSS 2.1 and security and privacy updates to help address today’s evolving threat landscape.

Display My Computer Icon on the Desktop in Windows 7

Well its been a long time since i have written and shared any new tips and tricks with my fellow geeks.
But here I am with the basic really easy post on Windows 7. Well this new version of windows has really inspired me and I would like to keep writing on the new features available as I go on exploring them.

The easiest way is to right click on your desktop-> Personalize -> Change Desktop Icons  and here you land on the following screen.

Walla! You have your My Computer on the desktop.

Login failed error: (Msg 18456) SQL Server 2005 Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

While I was migrating my database server from SQL 2000 to SQL Server 2005 I came across this error as the production and development environment were not quite identical.

Well the first thing to note in this error is non descriptive, preventing information disclosure to unauthenticated clients.

To determine the true reason for the failure, the administrator can look in the server’s error log where a corresponding entry will be written.  An example of an entry is:

2006-02-27 00:02:00.34 Logon     Error: 18456, Severity: 14, State: 8.

2006-02-27 00:02:00.34 Logon     Login failed for user ‘<user name>’. [CLIENT: <ip address>]

A great article with the complete description of this error and states is written by Il-Sung Lee here: http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Happy working with your linked servers.

Adding reference to Project in Visual Studio 2005

In your Visual Studio IDE go to the projects (at the top) -> add references -> com (tab) -> add the Microsoft Excel library installed.

 

Or you can use the project explorer.

Right click on the references-> add references -> com (tab) -> add the library.

 

Please refer to the image below.

 

Then simply what you need to do is Import the Excel.

Imports Microsoft.Office.Interop.Excel for VB

using Microsoft.Office.Interop;              for C#

 

The “Microsoft Excel X Object Library” where X will depend on whatever version of Excel you have in the computer.
So the X depends on which version of Excel is installed on your machine.