Whenever I am suggesting something which changes how database works or the existing status of the database, my suggestion along with it is to take the database backup before making such changes. If the changes are in configurations, that can be easily revert but if the changes are such that it will impact the data, I always suggest to take backup. The nature of this blog is such that we have readership from readers with different expertise, some are experts and some are novice.
SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video
Developers often face situations when they find their column have duplicate records and they want to delete it. A good developer will never delete any data without observing it and making sure that what is being deleted is the absolutely fine to delete. Before deleting duplicate data, one should select…
Read MoreSQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video
Concatenating  string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see…
Read More
SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies
Let us learn in this blog about sys.sql_expression_dependencies.
A very common question which I often receive are:
How do I find all the tables used in a particular stored procedure?
How do I know which stored procedures are using a particular table?
SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video
Every developer once in a while facing an unfortunate situation where they have not yet saved the work and their SQL Server Management Studio crashes. Well, you can minimize the loss by optimizing auto recovery settings. In this video we can see how to set the auto recovery settings.
SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012
Yesterday we had very first SQL Bangalore User Group meeting and I was asked following question right after the session. This question is about to Find Weekend and Weekdays from Datetime in SQL Server 2012.
SQL SERVER – Display Datetime in Specific Format – SQL in Sixty Seconds #033 – Video
The need of developer changes as geographic location changes. In SQL Server there are various functions to aid this requirement. There is function CAST, which developers have been using for a long time as well function CONVERT which is a more enhanced version of CAST. In the latest version of SQL Server 2012 a new function FORMAT is introduced as well to display datetime in specific format.