Analyze it

SQL Server 2005 SP3 CTP

2008-11-02T08:59:00Z

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

2008-09-29T10:49:00Z

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

2008-08-07T06:42:00Z

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

2008-07-10T09:17:00Z

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

2008-06-23T05:22:00Z

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

2008-06-12T07:36:00Z

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)

2008-05-04T06:46:00Z

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

2008-04-15T09:27:00Z

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

2007-07-02T07:36:00Z

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.