Generating a Database Data Dictionary
Accurate documentation is paramount for any system. Unfotunately, when developing a database we sometimes tend to overlook this particular document.
[Read More]
Database Upgrade from SQL Server 7
When migrating databases from SQL Server 7 or 2000 to SQL Server 2005/2008 the steps can be summarised as follows:
[Read More]
Header for Database Code Objects
Stored procedures and functions allow for the implementation of groups of data manipulation language (DML) statements as database objects. Besides each code block having the relevant comments to facilitate other parties’ understanding of the same code blocks (amongst other reasons), a good coding practice is that some information about the object...
[Read More]
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]