Here is the follow up question to my earlier question SQL – Difference between != and Operator <> used for NOT EQUAL TO Operation. There was a pretty good discussion about this subject earlier and lots of people participated with their opinion. Though the answer was very simple but the conversation was indeed delightful and was indeed very informative. In this blog post I have another following up question to all of you. What is the difference between INNER JOIN and JOIN?
SQL – What ACID stands in the Database? – Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit
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…
Read MoreSQL SERVER – Drivers for PHP, JDBC, ODBC and OLE DB
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…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #037
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…
Read MoreMySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes
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…
Read MoreSQL – Agile Software Development Methodology vs Waterfall Software Development Methodology
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…
Read More
SQL SERVER – Need Your Feedback – Next Action Items in SQL in Sixty Seconds
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
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…
Read MoreSQL – Difference between != and <> Operator used for NOT EQUAL TO Operation
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.…
Read MoreSQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL
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…
Read More