June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – UDF – Remove Duplicate Chars From String

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Duplicate Records, SQL Function, SQL Scripts, SQL String
Few days ago, I received following wonderful UDF from one of this blog reader. This UDF is written for specific purpose of removing duplicate chars string from one large string. Virendra Chauhan, author of this UDF is working as DBA in Lutheran Health Network. CREATE FUNCTION dbo.REMOVE_DUPLICATE_INSTR (@datalen_tocheck INT,@string VARCHAR(255))…
Read More

SQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, DBA, Outsourcing Technology, Software Development, SQLAuthority Author Visit
Yesterday I had meeting with few of the leading outsourcing companies in Ahmedabad, India. Regular readers of this blog knows that I am currently in India handling large scale outsourcing assignment. My responsibilities includes managing application development, system architecture and database architecture. The purpose of meeting was to exchange the…
Read More

SQL SERVER – Q and A with Database Administrators

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, DBA, Software Development, SQLAuthority Author Visit
I have been in India for more than a month now, as I am leading a very large outsourcing project. We have conducted few interviews since the project required more Database Administrators and Senior Developers. I am listing few of the questions discussed during all the interviews. The whole event…
Read More

SQL SERVER – Database Interview Questions and Answers Complete List

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Data Warehousing, Database, DBA, Software Development
Update: I have updated this article series and newly updated article series is over here. If you are subscribed to my blog you will know that I receive request to send Database or SQL Server very frequently. Following is list of articles of my questions and answers series. Download SQL…
Read More