script

PowerShell to export data from a SQL Server table to csv in chunk of 15 days

by

A client had a table which was storing data since 11 years, and he wanted to export all that data into csv files in a chunk of 15 days data per csv file. So I developed a PowerShell script to do the same. Hope it helps in different scenarios.

T-SQL Script to list foreign key relationships

by

In this article, we will see T-SQL scripts to list foreign key relationships between tables. What is Referential dependency ? Referential dependency is a constraint between two tables in a relational database that ensures data consistency. To establish a referential dependency, you define a foreign key on a table that refers to the primary key … Read more