My first Weekend Project: visiting a friend’s technical institute, which has grown into many cities with classes on BI, project management and networking.
SQL SERVER – Discard Results After Query Execution – SSMS
No results in SSMS, yet the same query works in the app? My friend Ajit hit this, and the cause was the option to discard results after query execution.
SQL SERVER – Validating Spatial Object as NULL using IsNULL
How do spatial functions handle NULL? I show two ways of validating a spatial object as NULL: the IsNULL method, which returns 0 or NULL, and IsValidDetailed.
SQL SERVER – Validating Spatial Object with IsValidDetailed Function
Invalid spatial objects used to give only a simple error. The IsValidDetailed function tells you whether a shape is valid and, when it is not, the reason why.
SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred
Error 3623, an invalid floating point operation, shows up when a math function gets a bad value. I explain it with simple examples like SQRT(-5) and LOG(-9).
SQL SERVER – Powershell – Importing CSV File Into Database – Video
PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
XACT_ABORT: Why a Half-Done Transaction Can Survive an Error
Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.