In this guide, we will walk through the process of automating an Oracle 19c database backup using PowerShell . The backup will be stored ... Read more »
Monday, March 24, 2025
Tuesday, February 4, 2025
Different ways to Handle Remote / User data of attendance logs for SaaS based HR System
7:29 PM
Assalamualikum ! As businesses and organizations generate and consume vast amounts of data, the need to efficiently integrate that data in... Read more »
Category:
.Net,
api,
Csharp,
Database,
sql-server,
Tips and Tricks
Monday, February 3, 2025
Table-Valued Parameters (TVP) vs. SQLBulkCopy for Uploading Large CSV Files in C# and SQL Server
4:31 PM
Uploading large CSV files efficiently in SQL Server is a common requirement in enterprise applications. Two widely used approaches in C# a... Read more »
Category:
Csharp,
sql-server,
Tips and Tricks
Sunday, December 29, 2024
SQL DB Performance Tuning Scripts
3:53 PM

1. Performance Tuning Scripts a. Identify Missing Indexes sql Copy code SELECT DB_NAME(database_id) AS DatabaseName, OBJECT_NAM... Read more »
Subscribe to:
Posts (Atom)