All Articles - SQL Authority with Pinal Dave

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

August 27, 2013

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

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 SERVER – SQL Basics Video: SQL Code Generators – SQL in Sixty Seconds #061

August 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 6th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). With the SQL Server Management Studio User Interface (SSMS UI), we can create a table…

SQL SERVER – SQL Basics Video: Using Management Studio – SQL in Sixty Seconds #060

August 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 5th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). By now you have written several queries. This means you have opened SQL…

SQL SERVER – SQL Basics Video: Code Comments – SQL in Sixty Seconds #059

August 25, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 4th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). The amount of effort to type the ‘–‘ signs for a single-line comment increases…

SQL SERVER – Weekly Series – Memory Lane – #043

August 24, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – SQL Basics Video: Joining Tables – SQL in Sixty Seconds #058

August 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 3rd post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). An INNER JOIN clause allows us to join multiple tables in a single query,…

SQL SERVER – Basics Video: Running SQL Code – SQL in Sixty Seconds #057

August 22, 2013

Pinal Dave

SQL Video

Joes 2 Pros, SQLAuthority Book Review

This is the 2nd post out of my 10 post series of my videos on my 10th book – SQL Basics Video: Running SQL Code. Wach the video here

SQL SERVER – SQL Basics Video: Data and Information in Businesses – SQL in Sixty Seconds #056

August 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 1st post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). Databases have been around since cavemen were drawing stick figures of their family’s on…

SQL SERVER – Simple Trick to Backup Azure Database with SkyDrive

August 20, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure, SQL Backup and Restore

To ensure your SQL Server or Azure databases remain safe, you should backup your databases periodically. And it is important to store the backups in a reliable location. Microsoft SkyDrive currently offers 7GB free, Box offers 5GB free – both are reliable and it is simple to send your backups…

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.