SQL Tips and Tricks Archives - Page 444 of 536 - SQL Authority with Pinal Dave

SQL SERVER – 2008 – TRIM() Function – User Defined Function

October 9, 2008

I just received following question in email by James Louren. “How come SQL Server 2000, 2005 does not have function TRIM()? Is there any way to get similar results. What about SQL Server 2008?” James has asked very interesting question. I have previously wrote about SQL SERVER – TRIM() Function…

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

October 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, Microsoft Certifications, Software Development

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…

SQL SERVER – 2008 – High Resolution Wallpaper and Screen Saver

October 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Download, SQL Humor

Recently I came across two very interesting ‘objects’ of SQL Server 2008. SQL Server 2008 High Resolution Wallpaper SQL Server 2008 Screen Saver Click Here to Download Reference : Pinal Dave (https://blog.sqlauthority.com)

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

October 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MVP, SQL User Group, SQLAuthority Author Visit

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…

SQLAuthority News – Upgrade SQL Server With SA Renamed – Rebuild System Databases – SQL Server 2008

October 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database

I recently came across two interesting blog post by PSS SQL Server Engineers. They have written two interesting SQL Server 2008 related post and it can be very helpful to those who come across the issues mentioned in them. How to Rebuild System Databases in SQL Server 2008 Rarely but…

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

October 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Software Development, SQL Download, SQL Utility

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…

SQLAuthority News – Cumulative update package 1 for SQL Server 2008

October 4, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download, SQL Service Pack

Cumulative update package 1 for SQL Server 2008 is released. Click on link : http://support.microsoft.com/kb/956717/en-us Update : I have received few emails where developer did not find where to click on the support page to download the update package. Following image describes the link which is on very top of…