I often work with advanced features of the SQL Server and this really led me to change how SQL Server is starting up. Recently I was changing the start up options in SQL Server and I was very delighted when I saw the startup option screen in Denali. It has really improved and is very convenient to use. Now I realized that the more I use Denali, the more I love it.
Here is the screen of the earlier version of SQL Server. Frankly speaking, it was a bit difficult to modify. I used to copy the settings to notepad and then change each one of them.
SQL Server 2000:
Here is the screen of SQL Server ‘Denali’, the next version of the SQL Server. You can get to the screen using following path:
SQL Server Configuration Manager >> SQL Server Services >> Properties >> Startup Parameters.
SQL Server ‘Denali’:
Sometimes small things like these make the life of DBA a lot easier.
Reference: Pinal Dave (https://blog.sqlauthority.com)