Storing Files in SQL Database Using FILESTREAM – Part 1
FILESTREAM has been introduced by Microsoft in 2008. The purpose was to store and manage...
How to Move Datafiles in SQL Server – Part 1
Introduction There are a number of situations which would warrant the movement of database files or transaction log files from one volume...
Conditional Split Transformation: Export Data from SQL Server into Oracle and MySQL Databases
In this article, I have explained how we can divide and export data of SQL Server database table into Oracle and MySQL databases. That...
Export data from SQL Server to Excel and Text file via using SSIS package
While using the SSIS data flow, we can perform ETL task that can be used for data migration, data...
Exporting Oracle Table to Excel Worksheet
In this article, I will explain how we can divide and export data of an Oracle database table into multiple worksheets of an Excel file...
Different Ways to Compare SQL Server Tables Schema and Data
SQL Server provides us with different solutions to replicate or archive a database table or tables to another database, or the same...
Performing Data Changes Audit Using Temporal Table
SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal...
Art of Isolating Dependencies and Data in Database Unit Testing
All the database developers more or less write database unit tests that not only help in detecting bugs early but also save a lot of time...
The Art of Aggregating Data in SQL from Simple to Sliding Aggregations
Let us start our SQL journey to understand aggregating data in SQL and types of aggregations including simple and sliding aggregations....
Struggling with Data Export from Microsoft Dynamics 365 CRM to External Portals
Though Microsoft Dynamics 365 does not offer any built-in feature to export the CRM data to...
