Table-Value Parameters in SQL Server 2005

dotnethitman.spaces.live.com — In pre-SQL Server 2005 in order to pass in a set of values one had to create a temporary table, populate it with data using INSERT, and then just use it in the procedure or function since they are created for the current session and are available to all processes in that session. I did a blog on how to pass in Table-Value Parameters in SQL Server 2008 but what if we have a need to pass in multiple rows of data to a T-SQL statement, or a routine such as stored procedure or function in SQL Server 2005? read more...

add a comment | category: Tips & Tricks | Views: 15

Forms Authentication Timeout vs Session Timeout

dotnethitman.spaces.live.com — If we set the forms authentication and session timeouts to 10 minutes and after the 10th minute the user clicked on any link the app would redirect the user to the login page but the session was not abandoned i.e. the forms authentication ticket had expired but not the session state timeout. read more...

add a comment | category: ASP.NET | Views: 62

ASP.NET Performance Tips

weblogs.asp.net — The article lists few of some of the many performance tweaks that can be implement to boost up ASP.NET performance. read more...

3 comments | category: ASP.NET | Views: 526

Dependency Injection: Factory vs Container - Unity

dotnethitman.spaces.live.com — As application size and complexity increase it becomes more and more difficult to reuse existing components and integrating these components to form an interconnected architecture because of the dependencies of the components. One way to reduce dependencies is by using Dependency Injection, which allows you to inject objects into a class, rather than relying on the class to create the object itself. read more...

add a comment | category: Patterns | Views: 19

SQL Server 2008 Data Compression Part-1

weblogs.asp.net — The article provide a breif introduction of new data compression feature in SQL Server 2008. read more...

add a comment | category: Database | Views: 19

Preventing SQL injection attacks in ASP.NET

dotnethitman.spaces.live.com — SQL injection can occur when an application uses input to construct dynamic SQL statements or when it uses stored procedures to connect to the database. Conventional security measures, such as the use of SSL and IPSec, do not protect your application from SQL injection attacks. Successful SQL injection attacks enable malicious users to execute commands in an application's database. You should always be reviewing your code to find these or other security vulnerabilities; remember all type of attacks start with some input, and your first line of defense should be input validation using both client-side and server-side validation. read more...

add a comment | category: ASP.NET | Views: 14