Microsoft SQL Server Tutorials
In this SQL Server tutorial, you will learn how to check database size in SQL Server using query. You will understand the stored procedure in SQL Server that contains information about the databases and how to check the size of databases. Also, you will understand about view files in SQL Server to retrieve the database … Read more
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 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
As a database developer, I worked in SQL Query, and I was required to convert integers into fixed-length strings in SQL Server. After multiple research studies, I found a simple and standard way of converting. In this SQL Server tutorial, you will learn how to convert int to fixed length string in SQL Server. You … Read more
In this SQL Server tutorial, you will learn about SQL Server convert int to string padding where you will introduced to the concept of padding. After that, you will understand the LEFT(), RIGHT(), CONVERT(), and REPLICATE() functions that you can use these functions in combination to apply the left and right padding to the string. … 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 about SQL Server convert int to string with commas. I will show you how to use the CONVERT(), FORMAT(), and CAST() functions to convert integers to strings and format those strings with commas in SQL Server. SQL Server Convert Int to String with Commas There are two … Read more
In this SQL Server tutorial, you will learn how to convert int to string with leading zero in SQL Server. Where you will understand how to convert the given integer value into a string with a number of zeros at the beginning of that string. After that, I will explain how to use the functions … Read more
In this SQL Server tutorial, you will learn how to find database name in SQL Server using query. You will see about two methods that you can use to find the name of the database. Then, you will understand the situation where you can employ those methods. Find Database Name in SQL Server Using Query … 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