When someone modifies or alters a stored procedure, the information is stored in logs. By accessing the logs you can know who modified the stored procedure and when. How to find who modified a stored procedure in SQL Server To find who modified a stored procedure in SQL Server, follow the below approaches. But before … Read more >>
Recently, I got the requirement to get the month name from a specified date in SQL server. This article will discuss multiple approaches to achieve this functionality. How To Get Month Name From Date In SQL Server Let us discuss all the approaches individually. Approach-1 Using DATENAME() We can use the DATENAME() in an SQL … 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 >>
Recently, I got the requirement to get the table row count for some of the tables in my SQL Server database. In this article, I will walk you through all the possible approaches to get table row count in SQL Server. How To Get Table Row Count In SQL Server Let us discuss all the … 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 >>
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 >>
As an SQL DBA or even an SQL developer, it is crucial to know how to check what version of SQL Server is running. In this article, I will walk you through all the approaches to achieving this. How To See What Version Of SQL Server Is Running Let us discuss each approach individually. Approach-1: … Read more >>
I recently had to back up one critical table for a major maintenance activity for my SQL server database. I have identified a few simple approaches to do this. In this article, I will walk you through all those approaches to backup a table in an SQL Server. How To Backup A Table In SQL … 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 >>
Download A 40 pages PDF And Learn Now.