blogs.conchango.com

There's some good news filtering into my inbox today about SQL Server bugs that have been fixed in the upcoming CTP (i.e. CTP6).Title: SSIS: Raw files throw an error at 4GB Description: It is not possible to load more than 4GB of data into a raw file. Status: Resolved (Fixed) Link: ...

Hallelujah. Finally SQL Server Management Studio has caught up with the rest of the world and started offering intellisense within SQL Server Management Studio. Here's some screen shots:   CTRL-J brings up a list of all available objects for a FROM clause   Specifying part of a fully-qualified name (which you all use, right?) ...

Spotted in pre-CTP5. Right-click on a table and see 2 new options:Select Top 1000 RowsEdit Top 200 Rows As I say, very simple. But for large tables those will be very handy. Can you think of any other small bug significant improvements that you'd like to see made to SQL Server Management Studio? Buck Woody wants to hear about ...

Recently I was lucky enough to be given, by SQL Server Central, a free copy of Redgate SQL Prompt 3 which is a tool that provides the equivalent of Visual Studio Intellisense for SQL Server Management Studio. Since then I've been evaluating it and thought I'd write a mini-review here. Its actually quite well timed because ...