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.
This chapter covers the following topics:
SQL Server standards
SQL Server development standards
SQL Server database design standards and best practices
Data protection standards
SQL Server production standards
Windows PowerShell coding standards ...
Get Microsoft® SQL Server® 2008 Administration with Windows PowerShell™ now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
