July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts
This is the 51th episode of SQL in Sixty Seconds Video and we will see in this episode how to RESEED identity of the table column. Identity column is every increasing (or decreasing) value based on the interval specified in its property. In today’s SQL in Sixty Seconds video we…
Read More

SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, sqlcmd
This journey of SQL in Sixty Seconds we started almost a year ago and today we are at very interesting milestone where I am recording 50th episode. Thought I wanted to keep the length of each video to sixty seconds, sometimes it went up by a few seconds. Due to this we are also at very…
Read More

SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio, sqlcmd
One of the most annoying thing which I have personally come across is drop down list of Server Lists on Connect dialog in SQL Server Management Studio. Here are two of the cases when I want to delete something from SSMS Connect Screen: 1) Incorrect server name typed 2) Server…
Read More

SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048

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

The sqlcmd utility is a command-line utility for ad hoc, interactive execution of Transact-SQL statements and scripts and for automating Transact-SQL scripting tasks. Often a developer believes that sqlcmd works with only command prompt, however that is not true. sqlcmd can also work with SQL Server Management Studio. There are lots of cool tricks we can do with sqlcmd while we are using it along with T-SQL.

Read More

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