performance
-
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
-
Is your brain faster than your PC?
Computer vs the brain I wrote a post quite some time ago illustrating methods that humans can use to solve multiplication faster than you can lookup on a PC.The methods are very simple and involve practice over a weekly (or… 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
-
Lambda Functions in .Net
Lambda expressions in .Net are denoted by the ‘=>’ symbol. These powerful operators can be used to create sleek, optimized loops that perform much faster. The usage below condenses the equivalent of at least 20 lines of two loops. (Sorry… Continue reading
{handshake sound} 