Category Archives: SQL Server

SQL Server – How to Search for Objects in a database

By | 10/01/2024

In this post, we will see how to search for objects in our SQL server databases, using a simple Stored Procedure called SearchInAll.In the world of database management, searching through various database objects for specific text can be a tough task, especially in large and complex databases. Whether it’s for debugging, auditing, or just general… Read More »

SQL Server – Temporal Table

By | 06/07/2022

In this post, we will see how to create and manage a Temporal Table in Sql Server.But first of all, what is a Temporal Table?From Microsoft web site:“Temporal tables (also known as system-versioned temporal tables) are a database feature that brings built-in support for providing information about data stored in the table at any point… Read More »