The wait is over. SQL Server 2008 has been released and is ready to deliverTechNet Plus subscribers can find RTM versions now available for download. ...

For many end-users, communications take place in disparate, disconnected silos. For voice communications, you turn to the desktop or mobile phone. For e-mail and IM, you turn to your PC. With the multitude of applications and tools from which to communicate,...

Be aware when you deal with the nvarchar(MAX) as a source data for the SSIS OLE data Source as in the large number of data the temp files couldn't be generated so the migration fails. i had a case with 48 columns nvarchar(MAX) with 45000 rows and the...

instead of profiling if you want to know just the services that runs currently on the Engine. choose the database master and run in the query editor " exec sp_who" this will list for you all the running activities with it's status on the server now ...

Finally,The SQL Server 2008 is RC0 but available so far only on the MSDN and technet subscribershttp://reddevnews.com/news/article.aspx?editorialsid=9946...

Top Tips for Efficient Queries   ·        When using AND, put the condition least likely to be true first. The database system evaluates conditions from left to right, subject to operator precedence. If you...

I faced this problem during working and I found that I have two approaches to acheive this :   either I ask the 3rd party developer to assign strong name to the dll or you do the following:   you should use Ildasm.exe tool to dissamble the...

Several enhancements have been added to ASP.NET with the release of Beta versions of Visual Studio 2008 SP1 and .NET 3.5 SP1... One of the good enhancements has to be the Script Combination ability where you will be able to select the number of...

One of the current SharePoint problems is that it doesn't include AJAX support by default, but there is a way to configure AJAX to work in your SharePoint, and that is why I'm writing this post.You have to make some steps to configure it:Open your sharepoint...

well, SSIS is the most critical stage in developing a Business Intelligence Project. so tips is always important. have a look on this http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1282913,00.html...

  Today, I’ll talk about how to develop Schemas using BizTalk, if you don’t know what a schema is, kindly use this link.   As a prerequisite, you must install the following software in order to develop BizTalk Applications: ·        ...

In the previous posts, I talked about BizTalk Server Architecture after a brief introduction. Today, I’ll talk about BizTalk artifacts covering the following points, ·         Schemas ·        ...

IF you have a MOSS list that contains a lot of data including UserID's.  These ID's are stored in the Users table in SQL because the site is working by Forms authentication provider.we need to display a specific result from this list in a...

One of the famous server errors that you may get is Request time out. This error is normal for developers .The causes usually are a process that takes a very long time "lengthy operation" or a connection to a DB that is disconnected or a server...

SYMPTOMS loadTOCNode(1, 'symptoms'); After you install Windows SharePoint Services 3.0 Service Pack 1 (SP1), a declarative workflow does not start automatically in the following products: • Windows SharePoint Services 3.0 • Microsoft...

You can get RSS feed from a content query web part, just be selecting the Enable feed check box.It looks very easy to use, but the problem here is that RSS in the content query web part is not working fine.If you have more than one RSS in the site, you...

when you try to empty the whole table especialy in SSIS  DON'T use delete from [Table] cause it takes time untill the query runs and delete the whole table instead use Truncate table [table] cause truncation empty the table at once...

In my previous post, we talked about some basic BizTalk concepts. In this post, we’ll talk about more of these concepts. Before drilling into details about the BizTalk Server Architecture, let’s talk bit about a design pattern called Pub/Sub....

Introduction ASP.NET 3.5 Extensions Preview is now gaining more attention and a lot of articles are being submitted in order to discuss different enhancements and new additions to the ASP.NET API. One of the very good enhancements has to be with the...

 Hello again, It crossed my mind a couple of weeks ago to share some BizTalk knowledge with you guys, reason being it takes a lot of brains for any BizTalk developer to find information on the internet about how to develop BizTalk applications...

I’ve just received the bellow mail from Microsoft today Dear Shady Khorshed,  Congratulations! We are pleased to present you with the 2008 Microsoft® MVP Award! The MVP Award is our way to say thank you for promoting the spirit of community and...

SQL Server Reporting Services cannot use the Default Web site because it has an identifier that the SQL Server Reporting Services setup cannot handle. You can either reinstall IIS to have IIS create the Default Web site, or modify the IIS metabase by...

This video demonstrates the new ADO.NET entity designer, as you will see it is now possible to visually map the insert, update, and delete stored procedures for entity types. Additionally, support for function imports allows the mapping of query stored...

Microsoft EDCEDC 2008 is the biggest Developers Conference of the year in Egypt, and is a critical event for any developer who wants to see the newest as well as the next-generation technology. EDC is full of sessions and activities that help you to learn...

Here you go...