Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Knowing the Source Application Using APP_NAME() Function

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function
APP_NAME() function in SQL Server returns the application name of the current session in which it is called. When you execute the following code SELECT APP_NAME() AS application_name You get the following result application_name ———————————————- Microsoft SQL Server Management Studio – Query This function can be effectively used to audit…
Read More

SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085

Pinal Dave
SQL
C Sharp, Notes from the Field, SQL Function, SQL Scripts, SQL Server

This is an 85th episode of Notes from the Field series. SSMS is my favorite IDE. I work with many different databases and different IDE. However, I get extreme comfort when I am working with SSMS. Though I like SSMS does not mean it is the best tool and it can accomplish all the tasks when I want it to do. Here is one of the task – converting file results to comma delimited result. However, my friend Kevin came in the rescue. He helped me out in this situation.

Read More

Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
If you ask me – there are certain questions not appropriate for an interview as they are often very subjective. There are some questions, which really do not help to identify if the candidate has the necessary skills or not. Here is one such question, if you ask me in the…
Read More