Chapter 14. Building SQL Server Standards and PowerShell Coding Standards

Defining and documenting SQL Server's standards is very important for any organization. Standards are important because they improve database manageability, platform scalability, Transact-SQL readability, and database performance, in addition to making troubleshooting easier. This chapter deals with SQL Server standards in a shop. SQL Server is not just a RDBMS; it contains many features. Based on the environment and resource availability, the features that are supported in an organization should be defined. Although it is easy and useful to adopt Microsoft's recommended standards and best practices, depending on your environment and the features that your department is going to support, you also need to define your own standards.

The standards illustrated in this chapter are a compilation of different scenarios drawn from our personal experiences in various companies. If you are already following SQL Server standards in your company, you may not need to review this chapter. However, we recommend you to go through the Windows PowerShell standards and at least glance through this entire chapter. It will definitely give you more insight and help you improve your current standards.