Bijay Kumar Sahoo

After working for more than 15 years in the Software field, especially in Microsoft technologies, I have decided to share my expert knowledge of SQL Server. Check out all the SQL Server and related database tutorials I have shared here. Most of the readers are from countries like the United States of America, the United Kingdom, New Zealand, Australia, Canada, etc. I am also a Microsoft MVP. Check out more here.

How to Install SQL Server Management Studio?

by
Install SQL Server Management Studio Opening

In this SQL Server tutorial, you will learn to install SQL Server Management Studio for managing and maintaining the SQL Server databases. Here you will understand the step-by-step process to install the SSMS and also how to connect to the SQL Server instance in SSMS. Finally, you will be introduced to the nodes and their … Read more

How to Create Database If Not Exists in SQL Server?

by
Create Database If Not Exists in SQL Server

In this SQL Server tutorial, you will understand how to create database if not exists in SQL Server. You will learn about manual methods that you can use to check the existence of any database before creating a new one. Create Database If Not Exists in SQL Server To create Database if not exists in … Read more

How To Find Database Owner in SQL Server?

by
Change Database Owner in SQL Server

In this SQL Server tutorial, you will learn how to find database owner in SQL Server. You will understand the method you use to view the owner of the database in SQL Server. You learn how to find the database owner using SSMS and Query in your command line. Find Database Owner in SQL Server … Read more

How to Change Database Owner in SQL Server?

by
Change Database Owner in SQL Server

In this SQL Server tutorial, you will learn how to change database owner in SQL Server. Where you will learn about ‘What are reasons behind changing the ownership of database?’. Then, you will understand how to use SSMS to change ownership of the database in SQL Server. At the end, you will learn about the … Read more

How to Get Connection String in SQL Server Management Studio?

by
Get Connection String in SSMS Connection Properties

In this SQL Server tutorial, you will learn how to get connection string in SQL Server Management Studio. Where you will understand connection properties and their meaning. After that, you will understand how to view the connection properties details in SQL Server Management Studio. Finally, you will understand the connection string syntax that you can … Read more

How to Create a Database in SQL Server Using Command Line?

by
Create a Database in SQL Server Using Command Line

In this SQL Server tutorial, you will understand how to create a database in SQL Server using command line. I will show you a step-by-step process from connecting to the SQL Server instance using the SQLCMD utility to creating a new database. Also, you will understand the error that appears when you create a database … Read more

How to Create a Database in SQL Server Using Query?

by
Create a Database in SQL Server Using Query

In this SQL Server tutorial, I will show you how to create a database in SQL server using query. You will understand the syntax to create a database in SQL Server. Also, you will learn about where to execute SQL Query on SQL Server Management Studio. Finally, you will create a database with examples. Create … Read more

How to Create a Database in SQL Server Management Studio?

by
Create Database in SQL Server Management Studio

In this SQL Server tutorial, you will learn how to create a database in SQL Server Management Studio. The SQL Server Management Studio is a tool or integrated environment provided by Microsoft to manage and work with SQL Server databases. So, in this tutorial, I will show how to create a database using SQL Server … Read more