Resetting the SA (System Administrator) password in SQL Server is crucial from a security perspective. In this article, I will walk you through all the approaches to reset sa password in SQL Server 2019. How To Reset SA Password In SQL Server Let us discuss all the approaches individually. Approach-1 Using SQL Server Management Studio … Read more >>

Databases in Microsoft Sql Server are very crucial to help you store and manage your crucial data. As a developer, you will deal with the very basic task of creating a new database in your SQL server. In this article, I will walk you through all the possible approaches to create a new database in … Read more >>

Recently, I got a requirement to work with a C# application where we were trying to call a stored procedure from that application where we required the connection string of my SQL server database. In this article, I will walk you through multiple ways to retrieve the connection string from SQL Server. How To Get … Read more >>

Recently, I was trying to show queries to my client in an online meeting. Suddenly, my client asked me to please increase the font size as I could not see it properly. So, I followed the below approaches to make the font bigger in SQL Server Management Studio. How To Make Font Bigger In SQL … Read more >>

We can get column descriptions or extended properties in SQL Server using different approaches. In this article, I will walk you through multiple approaches to do this. How To Get Column Description In SQL Server Let us discuss all those approaches individually. Approach-1: Using SQL Server Management Studio (SSMS) To get column description in SQL … Read more >>

As an SQL server developer, it is pretty essential for you to know what SQL server edition you are using?. In this article Let us discuss all the approaches to check SQL Server edition. How To Check SQL Server Edition We will discuss all the possible approaches to check the edition of your SQL server. … Read more >>

In this SQL Server tutorial, we will discuss how to alter view in SQL Server. We will discuss various ways and examples to modify a view. The following are some examples that we are going to discuss. If you have not yet installed SQL Server, first install SQL Server 2019. How To Alter View In SQL Server … Read more >>

I was trying to retrieve the SQL edition using a PowerShell script recently. After executing that query, I got this error. In this article, I will discuss the cause and the solution to this error. Cannot find type [microsoft.sqlserver.management.smo.server] I was executing the below query. After executing the above query, I got the error as … Read more >>