Install SQL Server 2016 Sample Database WideWorldImporters – SQL in Sixty Seconds #081

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.

Read More

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.

Read More

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, however the biggest hesitance is the fear of unknown. Lots of people do not try out new software because they are worried what would happen if the installation does not go through or they are not familiar with the new settings and installer. In this video I have attempted to install SQL Server 2016 Developer’s edition with all the options turned on. I wanted to make sure that I create a simple walk through demonstration which one can watch it and install SQL Server.

Read More

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.

Read More

SQL SERVER – Fixing Backup Error – Operating system error 5(Access is denied.) – SQL in Sixty Seconds #077

This error has to be one of the most famous error. I have installed SQL Server quite a many times, but I keep on getting this error once in a while. This is also one of the most searched error online. I have previously blogged about this but today, I planned to create a small video on the same subject. In this video, I demonstrate how one can resolve the permissions issue with this error. Let us learn about fixing a backup error. 

Read More
Menu