Software Development Archives - SQL Authority with Pinal Dave

Google Drive Trick – Google Spreadsheet Formatting Dates to String

September 14, 2014

I have been using google drive and google spreadsheet for a while. I work with experts around the world and we all use different date format. The biggest confusion which often happens when we are sharing data is a timestamp. For some people it is natural to have dates time…

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

March 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, Professional Development, Software Development

I was just reading Dr. W. Edwards Demings 14 principles of Total Quality Management. It is indeed very impressive and interesting. I have tried to collect a few of the important resources related to the same over here. Dr. Demings’s 14 principles Create a constant purpose toward improvement Adopt the…

Personal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device

November 17, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Software Development

Recently I was cleaning my house – clearing out old books and computer junk that I’ve been storing for a long time, when I found a box of floppy disks. I was filled with nostalgia. There was a time when I used floppy disks for everything – games, images, and…

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

April 1, 2010

Pinal Dave

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

Software Development, SQL Humor

First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once…

SQL SERVER – Enumerations in Relational Database – Best Practice

March 22, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, Software Development, SQL Documentation

Marko Parkkola This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1…

SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies

November 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Policy Management, Software Development, SQL Scripts

Introduction This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of…

SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis

August 31, 2009

Pinal Dave

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

Database, MySQL, Software Development

On 20 April 2009, Oracle Corporation announced its acquisition of Sun Microsystems in a deal worth about US$ 6 billion. This would have been just another one of corporate mega-deals that sound interesting in the news but really have no effect on your life. Except for the fact that with…