SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds

After reading my article SQL SERVER – 2008 – TRIM() Function – User Defined Function, I have received email and comments where user are asking if it is possible to remove trailing spaces, leading spaces, white space, tabs, carriage returns, line feeds etc. I found following script posted by Russ…
Read More

SQLAuthority News – SQL Server 2008 – Microsoft Certifications for 70-432 70-433 70-450 70-452

I have received many emails requesting information about SQL Server certifications examples. Microsoft has released new set of exams for SQL Server 2008 certifications. I am listing them here for quick reference. Exam 70-432 – TS: Microsoft SQL Server 2008, Implementation and Maintenance Installing and Configuring SQL Server 2008 (10…
Read More

SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems

Ahmedabad SQL Server User Group has started organizing a special event, “SQL Hour”, where we visit IT companies and interact with the SQL Server professionals. We had the first meeting this Saturday, 4th October 2008 at Patni Computer Systems, Gandhinangar. This meeting was lead by SQL Server User Group President…
Read More

SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download

I previously wrote article SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which…
Read More