In this SQL Server tutorial, you will learn how to check database log file size in SQL Server using query. First, you will understand ‘What is a database log file in an SQL Server instance?’. Then you will understand about two view files sys.database_file and sys.master_files to retrieve the log file and its size. Check … Read more
In this SQL Server tutorial, you will learn to find database name in SQL Server Management Studio. You will understand how to find the name of the database through Object Explorer in SSMS. After that, you will learn through examples how to find the name of a database using a query in SSMS. Find Database … Read more
In this SQL Server tutorial, you will learn how to get server name in SQ Server using query. In this tutorial, you will understand two configuration functions in SQL Server which help in finding the name of the SQL Server. Get Server Name in SQL Server using Query To get server name in SQ Server … Read more
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
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
In this SQL Server tutorial, you will learn how to install SQL Server 2022 Express Edition step by step on your computer. You understand the step-by-step process to install SQL Server 2022 Express Edition. You will see how to select the specific feature for SQL Server. Also, how to configure the SQL Server instance and … Read more
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
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
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
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