Welcome to EMC Consulting Blogs

Lately I’ve been working on a SQL2000 project and its afforded me the opportunity to get re-aquainted with the granddaddy of SQL Server query tools – Query Analyzer. For those that don’t know, Query Analyzer (QA) was the query tool provided with SQL Server up until SQL Server 2000; in SQL Server 2005 it was superceded by SQL Server Management ...

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?) ...

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 ...