SSIS error: 'buffer manager cannot create a temporary storage file on any path in the BufferTempStoragePath property'
An ETL SSIS package implemented on a test environment was failing occasionally with the error:
[Read More]
Protecting against SQL Injection attacks
In a nutshell, an SQL injection attack is one where malicious code is passed to an instance of SQL Server for parsing and execution through a vulnerable application. Although most SQL injection attacks can come from the web (having a larger “target audience”) even machines connected to an organisation’s network...
[Read More]
Date and Time data types
Someone asked me why storing datetime values seem to allow a maximum year of 2079.
[Read More]
The First Record
Dear Reader,
[Read More]