SQL Server Archives - Page 102 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055

July 17, 2013

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Have you ever needed WAIT or DELAY function in SQL Server? Well, I personally have never needed it but I see lots of people asking for the same. It seems the need of the function is when developers are working with asynchronous applications or programs. When they are working with…

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…

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