Sunday, October 22, 2017

SQL Server Installation All Videos on Single Page


SQL Server 2012 Installation





How to Install SQL Server 2016 Technical Preview

How to download and Install SQL Server 2017 in Linux

How to download and Install SQL Server 2016 Technical Preview


SQL Server 2016 Technical Preview Installation

This video is about How to install SQL Server 2016 Technical Preview in your machine.
What we are going to do in this video
1. Download SQL Server 2016
2. Install SQL Server 2016

How to download and install SQL Server 2017 in Linux ?

How to create database table in SQL Server 2014



SQL Server 2014 Create Table Part 1

This video is another tutorial part on SQL Server 2014 CREATE TABLE Statement. It helps you to understand how to create a simple Database Table in SQL Server 2014.
Following topics are covered as a part of this video

1. Create Simple Database Table
2. IDENTITY Columns
3. NULL and NOT NULL Constraints for Table Columns

How to install SQL Server 2012 in WIndows 10


This video helps you to download and install Microsoft SQL Server 2012 in Microsoft Windows 10.

You may also like

How to download and install SQL Server 2017 in Linux ?

Friday, October 13, 2017

How to install SQL Server 2017 in Linux


From year 2016 SQL Server is also available for Linux. Above video is complete end to end guide to install SQL Server in Ubuntu 17.04. We are using a VM installed in virtual box with 5 GB Ram and 63 GB hard disk to install SQL Server 2017 RC. During the installation process we also learned about how to download and install SQL Server 2017 in Ubuntu using terminal commands. After installation we configure SQL Server 2017. Finally we install SQL Server Data tools SQLCMD to execute T-SQL Commands using terminal for SQL Server 2017 database operations.

If you want to copy the Terminal commands please visit: https://vlemonn.com/blog/sql-server/install-sql-server-2017-in-ubuntu-17.04/

If you like our efforts please support us
PayPal: https://www.paypal.me/vlemonn
Patreon: https://www.patreon.com/vlemonn

Next in our todo for SQL Server 2017 in Linux environment
1. Configure SQL Server 2017 in Ubuntu Linux for remote connection
2.  GUI Editor in Ubuntu 17.04 for SQL Server 2017.

Monday, December 8, 2014

How to remove duplucate records from databade table

How to remove duplicate records from database table -SQL Server

This video is about how to remove duplicate records from database table. If you want to read more about this you can check this article. The list of interview questions are available here.


Video on how to remove duplicate records from database table in SQL Server. Applicable for  SQL Server 2005, 2008, 2012, 2014.

 

You can also watch video on How to check SQL Server version ?
If you like this video don't forgot to subscribe and share with your friends.
Here us my Youtube channel.

Monday, December 1, 2014

SQL Server 2014 Tutorial Index

SQL Server Tutorial Index

  1. Introduction : SQL Server 2014 Free Tutorial Introduction.
    1. Prerequisite : Things required if you want to perform exercise on SQL Server.
    2. Install SQL Server : A Guide to follow for SQL Server 2014 Installation.
    3. Attach Sample Database : Attach sample database for practicing.

    Note: We are updating this based on contents available.