I have received many many request to do another series since my series SQL Server Interview Questions and Answers Complete List Download. I have created small series of Coding Standards and Guidelines, as this is the second most request I have received from readers. This document can be extremely long but I have limited to very few pages as it is difficult to follow thousands of the rules. My experience says it is more productive developer and better code if standard has important fewer rules than lots of micro rules.
Next two days I will be posting Guidelines. This is the standards which I use in my company. There is extra addendum also, which I will be not posting here as that is specific to our company only. Please let me know if you think I have missed any important coding standard rules, I will accommodate them.
Please feel free to contact me if any of you want to write mini series with me.
Complete Series of Database Coding Standards and Guidelines
SQL SERVER Database Coding Standards and Guidelines – Introduction
SQL SERVER – Database Coding Standards and Guidelines – Part 1
SQL SERVER – Database Coding Standards and Guidelines – Part 2
SQL SERVER Database Coding Standards and Guidelines Complete List Download
Click here to get free chapters (PDF) in the mailbox
This document tells developers how they must write their code, this document also improves maintainability of the code. Every database has its own language and this document specifically talks about SQL Server. You can use these standards in your organization, however, you must give credit back to SQL Authority blog.
Reference: Pinal Dave (https://blog.sqlauthority.com)
hi this is vikas tyagi and i m very im pressed of this site.
Great article….It seems that you had taken many points from the Microsoft SQL server book.
It’s very nice. I like your blog to read. Keep it up
i found your site very interesting
really its having lot of stuff in it
finally i thank you for publishing this site
sir please tell some concepts related to constraints in sql server 2005.which constraint accept null and which constraint reject it and why
i want to know how to make a good database Architecture
what r the rule we apply
Mr. dave…i am very impressed by going through ur notes….
It is much helpful for me to develop new ERP for my organisation……..
Am not able to view your coding samples using the links above, can you please help me.
It’s very useful
how i wil get tha sql code for any project through internet .. mns send me some site
hi all am sengu can you explain what is replication ……..
Read about at this link at SQL Server help file
that’s very good.you help me about SQL alot
I have a question.how I can Add 1 column to all of the tables in database
Really here is the chance to get Knowledge on Sql Server DBA…
Thanks to team for keeping the Updates…