Ricardo Parente's Blog

Pinal Dave, my SQL Guru, completed today 1500 posts on his blog SQLAuthority, with 20 million views in iyts 4th year. That’s amazing! Good job. He explains how he came up with the blog’s name on this article. Keep up the good work Pinal !

This week I had to write a stored procedure for retrieving real estate properties and use the data in a ColdFusion template with pagination.  I had the following input arguments: StartRow, EndRow, PriceFrom, PriceTo and SortBy. Since I use Fusebox, all parameters passed in the URL query string are converted to the scope “attributes”.  So, [...]

We, at the company,  had to find all cities in my city table which name were composed of more than one word and the last word should have only two characters, like “Berlin SO”, “Santa Fe”… Phillip Gagnon, our I.T. manager, showed us two simple ways to list them using wildcards: 1 2 3 SELECT [...]

Microsoft released the SQL 2008 Service Pack 2. You may download it here. Reference: Pinal Dave

I have found many solutions to pass a list parameter from ColdFusion to a stored procedure, and this one is a very simple and efficient way to convert a string to a table. Thanks to Amit Gaur posting to SQL ServerCentral. I modified his original function which returns only integers (forcing you to pass only [...]

We are constantly implementing new tasks and developing web sites for about 12 customers. We have a development server at our office and our live servers are at our datacenter. Many times we have to rewrite or modify stored procedures and then after testing, we need to copy them to the live server.

My friend Pedro Claudio posted a link on my Facebook Wall about this presentation made by Bernardo D. A. Guimarães at the Black Hat Briefings Europe, Amsterdam in April 2009. I found it interesting and here is the slide presentation: Advanced SQL injection to operating system full control (slides) View more documents from Bernardo Damele [...]

I was following the SQL list and came across a post from Jim Gotwald where he showed his solution to convert a time string into a decimal value (ex: ’10:30′ to 10.5). So I decided to write a custom function where you can either pass a complete date as a string or just the time [...]

In my previous post, I discussed the function used to split a string into a table of tokens. Very useful instead creating a cursor. Now, with SQL 2005/2008, it became easier and faster to do the same job using XML parsing. I found this function online, written by Jacob Sebastian which is much faster than my [...]