It has been a long time since I have asked, puzzled on this blog so let us have fun time together with ISNUMERIC function. If you get the correct answer to this question, I will give you one month free subscription to Pluralsight.
“What is the difference between SQL Login and SQL User in SQL Server?”
When we have to move a database from one server to another server or when we have to move a database from one file to another file, we commonly use Database Attach or Detach process. I have been doing this for quite a while as well. Recently, when I was visiting an organization I found that in this organization lots of developers are still using an older version of the code to attach the database. I quickly pointed that out to them the new method to attach the database, however it was really interesting to find out that they really did not know that sp_attach_db is now a deprecated method to attach the database. This really made me to do today’s SQL in Sixty Seconds. I demonstrate in this SQL in Sixty Seconds how to attach or detach the database using a new method of attaching database. Let us learn about Attach or Detach Database.
SQL in Sixty Second series has been going on for over a year and we have over 50 videos. Here is one idea. I am planning to do a series on one topic in SQL in Sixty Seconds. I would like to gather your feedback about what should I create this series on.