The folks at SQLTeam have done some analysis on different ways of importing text files, you can read the info here; http://weblogs.sqlteam.com/mladenp/articles/10631.aspx http://weblogs.sqlteam.com/mladenp/archive/2006/07/22/10742.aspx And of...

The 3rd update to SQL Server 2005 Books On Line(BOL) is now available here , also the online version is updated. 3 Updates less than a year after RTM, great work by the UE team.

Technorati Profile

As a follow up to Tuesdays post , lets take a look at how this changes with SQL Express. (as always a little history) In MSDE for SQL Server 7/2000 the DTS runtime was included, this included the Package and Pump object models as well as the dtsrun...

I see this question come up in 2 main contexts, one is express users the other is users who thought they knew how to do this in SQL Server 2000 and are now confused in SQL Server 2005. We'll start with SQL Server 2000... In general the starting...

Get it while its hot!

This is not the answer to all occurences of the issue but try the following; Shut down SSMS. Go into IE, select Tools|Internet Options|Advanced If “Check publisher’s certificate revocation” under the security node is checked, then uncheck...

The folks on the BI Practices Team(now merged in with the SQL Server Perf Engineering Team) have spent the last 2 years working on a mondo BI reference implementation called Project Real. Working with data that started out form a real customer, hardware...

The SQL Everywhere guys have started blogging in fine style with 3 good posts today. You can read them here .