SQL Puzzle Archives - Page 9 of 28 - SQL Authority with Pinal Dave

SQL Contest – Identify the Database Celebrity – Win USD 100 Amazon Gift Card

September 19, 2013

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Regular readers of this blog are familiar with NuoDB and their generous offers for SQLAuthority.com readers. I was just talking to them earlier and together we have come up with a very interesting contest for all of us. This contest has two parts. Part 1 Identify Database Personality and in Part…

SQL SERVER – Simple Puzzle with UNION – Part 2

September 6, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Union clause, Union

Yesterday we had very easy kind of Back to Basics Puzzle with UNION and I have received tremendous response to the simple puzzle. Even though there is no giveaway due to sheer interest in the subject, I have received many replies. Due to all the request, here is another back…

SQL SERVER – Simple Puzzle with UNION

September 5, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Union clause, Union

It has been a long time since played a simple game on SQLAuthority.com. Let us play a simple game today. It is very simple puzzle but indeed a fun one. First let us execute following SQL. Query 1: SELECT 1 UNION ALL SELECT 1 ORDER BY 1 It will return…

SQL Contest – Download NuoDB 1.2 to Win 20 Amazon Gift Cards

August 27, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

NuoDB

NuoDb have earlier released NuoDB 1.2 and I have been using it for an entire month and my favorite feature is their support to Stored Procedure. I am a big fan of stored procedures and their advantages. Nod 1.2 has received great response in the industry and it has emerged…

SQL – Solution – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog

August 19, 2013

Pinal Dave

SQL Puzzle

Blogging, SQL Server

Earlier this month we were running a contest for solving the crossword based on my Blogging courses – Course 1, Course 2. Here are the details of the contest. The winner of the contest was to win Melting Clock (Do not confuse this as a dummy or not working clock. This looks like melting, but it always shows accurate time and it is perfectly balanced to hang off of any flat surface). Let us see Crossword Puzzle.

SQL – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog

August 1, 2013

Pinal Dave

SQL Puzzle

Blogging, SQL Training

Do you like Crossword Puzzles? I personally love it. Everytime I open the newspaper, I try to resolve at least one crossword or sudoku. It is just fun to tease a brain little and stretch its limits.
Regular readers of the blogs are aware that I have recently published two courses on how to build successful high traffic profitable blog.

SQL – What ACID stands in the Database? – Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit

July 15, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

We love puzzles. One of the brain’s main task is to solve puzzles. Sometime puzzles are very complicated (e.g Solving Rubik Cube or Sodoku) and sometimes the puzzles are very simple (multiplying 4 by 8 or finding the shortest route while driving). It is always to solve puzzle and it creates…