BULK INSERT loads large SQL Server files through a tested format, accessible path, staging table, measured batches, and final validation.
Connecting Java Applications With the JDBC Driver
Choose a current JDBC driver for SQL Server, verify its connection URL and encryption settings, and test integrated authentication on the app host.
SQL Injection: How It Works and How to Stop It
Prevent SQL injection by separating values from command text, parameterizing dynamic SQL, and validating object names before using QUOTENAME.
ATN2: Keep the Quadrant When Calculating an Angle
ATN2 uses two components to calculate an angle while retaining its quadrant. I keep the argument order and angle unit visible. Dividing one component by the other would lose useful information and introduce a zero-denominator case.
SQL SERVER – Rollback TRUNCATE Command in Transaction
Many believe TRUNCATE cannot be rolled back. It can. Here is a Rollback TRUNCATE command example inside a transaction, and why TRUNCATE is logged.
SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT
A Performance Comparison of INSERT TOP (N) INTO a table versus INSERT with SELECT TOP (N). The first is clearly faster, but the two can give very different results.
QUOTENAME Object Names: Quote Each SQL Server Name Part
QUOTENAME object names separately to keep each part of a qualified SQL Server name intact. The function surrounds its entire input with identifier delimiters. A dot inside that input stays inside one quoted name. I keep the schema and object in separate variables.