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
Posted in Architecture, Microsoft, SQL, Temenos | Leave a Comment »
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.
![]()
Posted in Community News, Personal Experience | Leave a Comment »
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.
Posted in Microsoft, SharePoint | Leave a Comment »
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
Posted in Community News, Microsoft, Windows 7 | Tagged Bahrain, Windows 7, Windows 7 Launch Party | 1 Comment »
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
Posted in SQL, T-SQL, Tips and Tricks | Leave a Comment »
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
Posted in Architecture, MSDN | Tagged Biztalk, EBS, Microsoft, Microsoft Enterprise Service Bus | Leave a Comment »
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.
Posted in Internet Explorer | Tagged IE, IE 8, Internet Explorer, Internet Explorer 8 RC1 | 3 Comments »
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.

Posted in Windows 7 | Tagged Tips and Tricks, Windows 7 | 6 Comments »
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.
Posted in SQL Server 2005 | Tagged SQL Server 2005, SQL Server 2005 Migration, SQL Server Tips and Tricks | 2 Comments »
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.
Posted in .NET, Tips and Tricks | Tagged .NET, Add new tag, Excel, Visual Studio .NET IDE | 8 Comments »



