June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, SQL Server Management Studio, SQL Server Security, SQL Utility
This is one very interesting issue which I have started to follow recently. Just like any other organization my company has many servers. Some are production and some are development. It is very much necessary that query which are written for developer environment does not run for production environment accidentally.…
Read More

SQL SERVER – Interesting Interview Questions – Revisited

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks
Best Practices, Software Development, SQL Scripts
I really enjoyed users participation in my previous question. Read SQL SERVER – Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users…
Read More

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks
Best Practices, SQL Scripts
Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer. Read Original Interview Question and Puzzle. Question: Select all the person from table PersonColor who…
Read More