Category Archives: SQL

Reduce page load time using asynchronous database queries
24.06.2016 No Comments No new comments

Traditionally in MySQL, we execute queries sequentially i.e. queries will be executed one after other only. So if we are executing multiple queries then each query will be blocked until … Continue reading Reduce page load time using asynchronous database queries

SQL Injection:  The Security Dread
31.12.2014 No Comments No new comments

“SQL injection (SQLI) is considered one of the top 10 web application vulnerabilities of 2007 and 2010 by the Open Web Application Security Project. In 2013, SQLI was rated the … Continue reading SQL Injection:  The Security Dread

What’s New in SQL Server 2012 -Part 1
20.03.2014 No Comments No new comments

Columnstore Index              Columnstore technology has introduced to SQL Server 2012 is the columnstore index. This is an index created just like any other, but … Continue reading What’s New in SQL Server 2012 -Part 1

An Introduction to Stored Procedures in MySQL 5
17.03.2014 No Comments No new comments

MySQL 5 introduced a plenty of new features – stored procedures being one of the most significant. In this tutorial, we will cover the basics of stored procedures and its … Continue reading An Introduction to Stored Procedures in MySQL 5

How to write ‘PIT Solutions’ in SQL?
12.12.2007 No Comments No new comments

 SELECT CONVERT(VARCHAR, 0x50495420536F6C7574696F6E73);