All Articles - SQL Authority with Pinal Dave

SQL SERVER – Download SQL Server Developer Edition 2012 for USD 60

September 8, 2013

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

SQL Server professionals often send me email asking about where can they download the full version of SQL Server for their own development. Microsoft only provides evalution version of its enterprise software (full version). The evaluation version is bound by time and it expires when the time trial is over. This does not…

SQL SERVER – Weekly Series – Memory Lane – #045

September 7, 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 – 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…

SQLAuthority News – 10 SQL in Sixty Days Video in 10 Days – Contest to Win 10 Cool Gifts

September 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL in Sixty Seconds series has received a very high appreciation in the community. I have been posting every month 3 or 4 new videos in this series but the popularity of the SQL in Sixty Seconds is such that I am constantly receiving emails requesting new videos in this…

SQLAuthority News – Learn MySQL Indexing in 99 Minutes – MySQL Indexing for Performance – Video Course

September 3, 2013

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

MySQL, SQL Index

Every year around September 1st, I have decided to do something cool. This is because September 1st is my daughter Shaivi’s birthday. In previous years, I have released my new books as well new courses on this day. This year I have done something similar for her. I like to…

SQLAuthority News – IT Security for Small Businesses

September 2, 2013

Pinal Dave

SQLAuthority News

SQL Server Security, SQL Training

Headlines today are filled with news of cyber attacks on some of the biggest corporate houses. Recently, media players such as the US newsletters.

SQL SERVER – SQL Basics Video: SQL 2012 Certification Path – SQL in Sixty Seconds #065

September 1, 2013

Pinal Dave

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

Joes 2 Pros, SQLAuthority Book Review

This is the 10th 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 new breakdown of the Microsoft SQL 2012 certification model offers new incentives…

SQL SERVER – Weekly Series – Memory Lane – #044

August 31, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane, SQL Scripts

SQL SERVER – SQL Basics Video: What Are Filegroups – SQL in Sixty Seconds #064

August 30, 2013

Pinal Dave

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

Joes 2 Pros, SQLAuthority Book Review

This is the 9th 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). There are many advantages to using filegroups to manage the database workload. A…