All Articles - SQL Authority with Pinal Dave

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

July 15, 2013

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…

SQL SERVER – Drivers for PHP, JDBC, ODBC and OLE DB

July 14, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

A driver is software that allows your computer to communicate with hardware, devices or other software. Without drivers, the software or hardware you connect to your computer will not work properly. Here is the list of the drivers which are available for SQL Server to connect from multiple applications and…

SQL SERVER – Weekly Series – Memory Lane – #037

July 13, 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…

MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

July 12, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of…

SQL – Agile Software Development Methodology vs Waterfall Software Development Methodology

July 11, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

If you are in the process of developing and creating software, a business, or product, the steps to get from point A – the idea – to point B – the finished product – can seem completely overwhelming. You start brainstorming, you get a great idea and follow it, but…

SQL SERVER – Need Your Feedback – Next Action Items in SQL in Sixty Seconds

July 10, 2013

Pinal Dave

SQL Video

SQL in Sixty Seconds, SQL Server

SQL in Sixty Second series has been going on for over a year and we have over 50 videos. Here is one idea. I am planning to do a series on one topic in SQL in Sixty Seconds. I would like to gather your feedback about what should I create this series on.

SQL – Download Database Cheat Sheet for MongoDB, NuoDB, MySQL for FREE

July 9, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, NuoDB, SQL Documentation, SQL Download

In the new database world there are so many different solutions, vendors and options available that it is super hard to figure out which database is the right solution for us. First of all the world of the big data itself is very confusing. It is so hard to figure…

SQL – Difference between != and <> Operator used for NOT EQUAL TO Operation

July 8, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is interesting question received on my Facebook page. (On a side note, today we have crossed over 50,000 fans on SQLAuthority Facebook Fan Page). What is the difference between != and <>Operator in SQL Server as both of them works same for Not Equal To Operator? Very interesting question indeed.…

SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL

July 7, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Earlier I wrote a blog post SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL and in follow up to the blog post, I received few questions. Let me try to answer those questions in following blog post. Q: How do we know if setting which returns NULL when concated to another NULL value is…

SQL SERVER – Weekly Series – Memory Lane – #036

July 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane