SQL Server

I've read a blog post for Nikhil Kothari , he was talking about Fajax or the fake AJAX which he means the code that you write to simulate the effect of the AJAX but it ain't AJAX, so i liked the idea and i've searched for most of these effects that Read More

We have faced a little problem in here with the reporting services 2005; suddenly it starts to log errors in the event log without no good reason. Here is the error: Error rsReportServerDisabled : The report server cannot decrypt the symmetric key Read More

How many of you wants to run a script on the whole tables in the database and don't want to do this manually???   well I'm one of those people who would like some sort of stored procedures which loops in all tables and apply the same script on Read More

This article is talking about the optimization of the SSIS, I've attended three sessions for Donald Farmer, Principal Program Manager for Microsoft SQL Server Integration Services in Microsoft Redmond,Seattle in the MDC 2007 for the Middle east developers Read More

Today I'll demonstrate a very nice feature that has been added recently in Microsoft SQL Server 2005 which is SQL CLR Integration. Well many will ask what is the SQL CLR , It’s the possibility to deploy C# or VB.NET code that is used within the SQL Read More