" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Are You Paginating Right?

Posted on November 24th, 2015 by Sathyan R

The one issue that dogs most programmers is application performance and there are certain things that are in our control always, one of that being returning only the necessary data from the backend. This is very relevant for web applications. Some form of grid is almost used in every web application and we implement paging, […]

FileTable in SQL 2012

Posted on November 24th, 2015 by Sathyan R

FileStream is a very powerful feature that was introduced in SQL Server 2008. This is a super hero feature which destroyed many performance villains associated with File System based work in SQL. This is a nice whitepaper on FileStream if you are new to it. SQL 2012 introduces FileTable, which is a great addition, we […]

TRY_PARSE In SQL Server 2012

Posted on November 24th, 2015 by Sathyan R

Many of the programming languages provide a try parse function today to enable easy error handling associated with numeric conversions. These make our life easier while dealing with error prone conversions. SQL Server 2012 introduces the same in SQL space and here is a quick look. Basics: SELECT TRY_PARSE(‘TechZeus’ AS DATETIME) SELECT TRY_PARSE(’00-22-2321′ AS FLOAT) […]