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 got the requirement to check one of the stored procedure execution times in my SQL server database. This article will help you check the stored procedure execution history in an SQL Server. How To Check Stored Procedure Execution History In SQL Server To check stored procedure execution history in SQL server, follow the … Read more >>
Checking the Datatype Of a Column in an SQL Server is a basic task for a SQL developer or an SQL DBA. In this article, let me guide you through all the approaches to do this. How To Check Datatype Of Column In SQL Server Let us discuss all the approaches individually. Approach-1 Using SQL … Read more >>
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 >>
Recently, I got a requirement from one of my clients to enable a query store for one of our SQL databases. In this article, I will walk you through the quick steps we followed to enable query store in sql server 2019. How To Enable Query Store In SQL Server Let us discuss all the … Read more >>
Recently, my team was required to migrate an SQL Server database to Azure SQL using the Azure database migration service. We analyzed the requirements and performed the complete steps to do this. In this article, you will learn how to migrate your SQL Server database to an Azure SQL database using Azure Database Migration Service. … Read more >>
Azure SQL has many advantages over the on-premise or local SQL Server instance. For example, high availability, security, and reliability. You may want to migrate your SQL Server database to Azure cloud if you wish to use these facilities. Migrate SQL Server to Azure SQL database Let us discuss all the approaches individually. Approach-1: Using SQL … Read more >>
Recently, I got the oppertunity to setup Oracle database in archivelog mode for one of my Oracle databases. So I have identified 2 simple approaches to do this. In this Oracle database tutorial, I will explain how to setup Oracle database in archivelog mode. How to setup Oracle Database in Archivelog Mode We can setup … Read more >>
Recently, while trying to insert explicit values into a critical table, I got this error: “An explicit value for the identity column in table can only be specified when a column list is used.” Fix “An Explicit Value For The Identity Column In Table” The below screenshot shows the same error. Error Cause Note that … Read more >>
Recently, I got a requirement to enable database encryption for a few of my SQL server databases. So before implementing, I am supposed to check if the database encryption is already enabled for my databases. I have identified a few simple approaches to check database encryption status in SQL server. In this article, I will … Read more >>
Download A 40 pages PDF And Learn Now.