While Microsoft may be taking its lumps on dominating the Web, its time-tested client software model continues to succeed. The most glowing example of this success is MSFT SQL Server. Once considered too buggy and lightweight, SQL Server is now establishing itself as a leader in the open systems database market. SQL Server’s growth rate is nearly double that of its nearest competitor (Oracle) and like any good virus software, it has relied on the ease
More>
STANDARDIZE YOUR MSSQL INSTALL TECHNIQUE
BY ERIC GROSS
In the enterprise, it is important that each database instance be configured as similarly as possible in order to mitigate support resources. Performing the instance installation using the silent mode is a step in the right direction because the inputs are specified using a file rather than a complex wizard, which is prone to error and cannot be standardized. MSSQL 2005 ships with an example sql2005.ini file which you can customize with the values you desire. After that has been done, installation is simpler than when using the interactive option – all you need to do is run this command:
db Connections is the newsletter of GridApp Systems, the leading provider of database automation software and solutions. Click here
for more information about GridApp’s database automation software, GridApp Clarity™.
Eric Gross has 13 years of experience working with large database infrastructures. He provides innovative ways for companies to manage their database environments more securely and efficiently.
