Tally table or counting table is characterized by consisting of a single column of numerical type with consecutive values. The column values remain unchanged and are used, for example, to generate sequences in SQL without… Read More »Tally Table: Generate Ranges in SQL Server without While
A common issue when we are creating a search functionality is to exclude results due to accent marks. For example, if we search by name or surname of an employee, we could exclude rows due… Read More »Function for remove accent marks in SQL Server
We will find and delete duplicate rows in SQL Server based on specific criteria is a pretty common task when we are working with databases. In this post, you will learn how to: Find duplicate… Read More »Delete duplicate rows in SQL Server
Docker has become an important piece of development for example we can recreate easily a development environment where we can restore SQL Server backups into a Docker container with a minimal effort. In this post,… Read More »Restore SQL Server backups using Docker