July Discount: Comprehensive Database Performance Health Check | Testimonials

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
, ,
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 More

SQL SERVER – Enumerations in Relational Database – Best Practice

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
, , , ,
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 More

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
, , ,
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
Menu