SQL Server Import and Export Tips
Analysis Services
Archiving
Automation
BIML
Bulk Insert
- Bulk Insert Data into SQL Server
- Dynamically Generate SQL Server BCP Format Files
- Minimally Logging Bulk Load Inserts into SQL Server
- Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert
- Scale SQL Server Bulk Loading On a Budget - Part 1
- Scale SQL Server Bulk Loading with Partition Switching for Performance - Part 2
- SQL Server Bulk Insert for Multiple CSV Files from a Single Folder
- SQL Server Bulk Insert Row Terminator Issues
- Troubleshooting Common SQL Server Bulk Insert Errors
Calculations
Comparison
Cross Platform
- Import Active Directory Data to a SQL Server Table
- Importing DBF files into SQL Server
- Using Python and Regex for SQL Server ETL Needs with Non-Standard Text Files
Data
- Best Practices For Building Alerts for Using APIs with SQL Server
- Custom SQL Server Change Tracking Example
- Excel File Data Validation for SQL Server Imports
- Import end of day prices for all NASDAQ stocks into SQL Server
- Importing Historical Stock Prices from Yahoo Finance into SQL Server
- Loading Historical Data into a SQL Server Data Warehouse
- SQL Server Bulk Insert For Full Files, Misformatted Data and Unusual Characters
Data Validation
- Pre-Validating Data with PowerShell Before Importing to SQL Server
- Preventing Invalid Data Early In An ETL Flow
- SQL Server Stored Procedure to remove outliers from data sets
- SQL Server Video to Pre-Validate Data with PowerShell Before Importing
- SQL Server Video to Remove Outliers from Data Sets
- Using a Simple SQL Server Bulk Insert to View and Validate Data
Export
- Export SQL Server Data to Multiple Excel Worksheets with C#
- Export SQL Server Records into Individual Text Files
File System
Formatting
Integration Services
JSON
- Different Ways to Import JSON Files into SQL Server
- Import Nested JSON Files to SQL Server with SSIS
- Importing Complex JSON files using SQL Server Integration Services
- Importing JSON formatted data into SQL Server
Microsoft Office Integration
- Export SQL Server Table to Excel with C#
- Simple step by step process to import MS Access data into SQL Server using SSIS
Monitoring
MySQL
Notifications
OPENROWSET
- Using OPENROWSET to read large files into SQL Server
- Using SQL Servers OPENROWSET to break the rules
Oracle
Overview
Performance
- Compare PUSH vs PULL Data Copy Performance in SQL Server
- Data Import Performance Comparison T-SQL vs SSIS for large import
- How to Copy a Table in SQL Server to Another Database
- Options to Improve SQL Server Bulk Load Performance
- Performance Improvement for SQL Server SELECT... INTO T-SQL Statement
PowerShell
- Import Excel Data into SQL Server with PowerShell
- Importing Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell
R Language
Scripts
T-SQL
Table
Temp Tables
Text Files
Tools
Troubleshooting
- Solutions to Track Delayed SQL Server Transaction Latency
- Techniques to Cleanse Bad Data in SQL Server
Workflow