Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Resolve Cannot Resolve Collation Conflict Error – SQL in Sixty Seconds #047

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
One of the most common errors database developer’s receives when they start working with database where there are different collation used. Collation is a very important concept but it is often ignored. First use the method displayed in this video to resolve your error and right away put your efforts…
Read More

SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
Earlier I have blogged about the same subject and in very short time I received lots of good comments about this blog post as well lots of email from users who faced issues to make this work. Thought, the instructions are very simple in the blog post, every user read…
Read More

SQL SERVER – Cycle Clipboard Ring in SSMS – SQL in Sixty Seconds #045 – Video

Pinal Dave
SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio

Copy and Paste! In other words – CTRL + C and CTRL + V – these two are our famous shortcuts for this new age. Remember copy paste is not a bad thing, but plagiarism is for sure. I rely on a lot of Copy Paste when I am doing development. There are so many templates, code or name of the objects (tables, stored procedure) etc., which we need when we are doing development. If we keep on typing those names, there are chances of making human error which can lead to further problems. Let us learn about the Cycle Clipboard Ring in this blog post.

Read More

SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
What do consultants do when they come across any new instance of SQL Server? Well, their very first question is what version of SQL Server is it? The reason is simple – SQL Server is a very vast product and each version of the product have new features released and…
Read More