Analyze it

SQL Server 2005 SP3 CTP

wagdyIshac — Sun, 02 Nov 2008 08:59:00 GMT

well, it's not that much. few features for reporting services and notification services. also the db engine

here's the list http://download.microsoft.com/download/0/e/5/0e5697be-028a-4da6-89a7-c18a9a1ac3c7/WhatsNewSQLServer2005SP3.htm

download the CTP here

http://www.microsoft.com/downloads/details.aspx?FamilyID=d22317e1-bc64-4936-a14b-7a632b50a4ca&displaylang=en

PerformancePoint Server SP1 is available now

wagdyIshac — Mon, 29 Sep 2008 10:49:00 GMT

Fianlly the 2008 Support
get the PPS SP1 frm the PPS blog
http://blogs.msdn.com/performancepoint/archive/2008/06/04/sp1-for-performancepoint-server-now-available.aspx

SQL Server 2008 RTM

wagdyIshac — Thu, 07 Aug 2008 06:42:00 GMT

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

Migrating large amount of data with nvarchar(MAX) in SSIS

wagdyIshac — Thu, 10 Jul 2008 09:17:00 GMT

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 migration failed. but converting them to 50 length it worked...!!!

Get list of hte Sevices that runs on the SQL Engine

wagdyIshac — Mon, 23 Jun 2008 05:22:00 GMT

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

RC0 Version of SQL Server 2008 Available

wagdyIshac — Thu, 12 Jun 2008 07:36:00 GMT

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

Top 10 SQL Server Integration Services (SSIS)

wagdyIshac — Sun, 04 May 2008 06:46:00 GMT

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

Truncation VS Deletion

wagdyIshac — Tue, 15 Apr 2008 09:27:00 GMT

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

SQL Server 2008 code name "Katmai" Awaitting CTP2

wagdyIshac — Mon, 02 Jul 2007 07:36:00 GMT

Jun 8th microsoft CTPed SQL Server Katmai, with main feature of Polices and how to enforce polices on databases.

we are waitting for CTP2 will be released this month.