sp
-
MSSQL User Defined Functions vs Stored Procedures
I received this question earlier today, and thought it was a valid question often misunderstood, and deserving of a small write-up: “Should a User Defined Function be your first choice instead of a Stored Procedure?” While there are many pros… Continue reading
-
DLL in Stored Procedure MSSQL
Extended Stored Procedures (MSDN), http://support.microsoft.com/kb/190987 Thread Local Storage in an extended stored procedure (MSDN), http://support.microsoft.com/kb/163449 Continue reading
-
How to Create secure relational databases in SQL
The first step to a secure DB, is a well structured DB and the application layers that access it. Take the following example of a table containing factories and the robots they produce. FACTORYNAME ROBOTNAME FACTORY1 Ron FACTORY1 John FACTORY2… Continue reading
{handshake sound} 