Using SSMS to create/restore split backups

I was going through SQL Server MSDN blogs and found an interesting blog post related to Split file Backups. I thought it is worth sharing it with everyone. This option can be really handy for the SQL developers who work on database projects. Every time we face some issue in production or we want to test our…

Using Where and Having Clauses

It has been some time since I have posted my last article let us kick-start with the next one… Generally there is little confusion in using the Where and Having Clauses. Let us understand with the help of this article Where Clause:        Where clause specifies the filter condition for the table. It is optional to use the…

Connecting to SQL Server using Command Prompt

 I was going through the videos in VirtualTech days, I found that there are some interesting tips given by the speaker Vinod Kumar. I thought  of sharing some of the tips in coming days so that it might be helpful for others as well.   Following are some of the options that are available to connect to SQL…