This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
Google Drive Trick – Google Spreadsheet Formatting Dates to String
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…
Read MoreProfessional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management
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…
Read MorePersonal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device
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…
Read MoreSQLAuthority News – MS Access Database is the Way to Go – April 1st 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…
Read MoreSQL SERVER – Enumerations in Relational Database – Best Practice
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…
Read MoreSQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
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…
Read More