I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the new features there is always need for a new Sample Database which contains all the necessary data and schema to demonstrate new features of the SQL Server. The SQL Server team has recently released a new sample database WideWorldImporters which can be used to demonstrate new features of the SQL Server.
Install SQL Server Management Studio 2016 – SQL in Sixty Seconds #080
Earlier this week, I have published a blog post where I explained how to install SQL Server 2016. One of the most asked questions was Where is SQL Server Management Studio 2016? I totally understand why this particular question is being asked often. I have decided to create a video explaining the how to install SSMS 2016.
SQL SERVER 2016 – Learn Installation of SQL Server 2016 in 2 Minutes Video
Every time when new SQL Server version arrives, lots of people want to install it. Let us learn installation of SQL Server 2016 today.
SQL SERVER – Identify and Filter In-Memory Optimized Tables – SQL in Sixty Seconds #079
Earlier I had written a blog about SQL SERVER – Beginning In-Memory OLTP with Sample Example which covers the basics of working with In-Memory OLTP. Though that post gets you started, one of my colleague asked me if there was an easier way to identify In-Memory Tables when working with SQL Server Management Studio. As a follow up I wrote another blog post over here where I demonstrate the same with images and query over here: SQL SERVER – Filter In-Memory OLTP Tables in SSMS. In this blog post we will learn about – Identify and Filter In-Memory Optimized Tables.
SQL SERVER – Puzzle – ISNUMERIC and Unexpected Results – SQL in Sixty Seconds #076
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.
SQL SERVER – Difference Between SQL Login and SQL User – SQL in Sixty Seconds #070
“What is the difference between SQL Login and SQL User in SQL Server?”
SQL SERVER – Attach or Detach Database – SQL in Sixty Seconds #068
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.