February 25th Links: SQL SERVER,Design Pattern,Web

SQL SERVER

    1. Find Current Location of Data and Log Files of All the DateBase

    T-SQL statement:

    SELECT name,physical_name AS current_file_location

    FROM sys.master_files

    2. List All Server Wide Configurations Values

    T-SQL statement:

    SELECT *

    FROM sys.configurations

    3. Why Should We Backup Master Database(Reasons to Backup Master Database)

    Master database contains all the system level information of server.Information about all the login account, system configurations and information required to access all the other database are stored in Master Database.if the Master Database is damaged,it will be difficult to use any other database in SQL Server that makes it most important database in SQL Server.

    How Should We Restore Master Database?-The 2 Stemps of Easy

    1) It's necessary to start SQL Server in signle user mode

    2) Exec sqlcmd command line:

        RESTORE DATABASE master FROM DISK='C\BackupLocation\master.bak' WITH                     REPLACE

Design Pattern

    1. Stratege Pattern-Refactoring: Replace Enums With the Strategy Pattern

    Although enums aren't necessary a code smell for refactoring,they can definitely be a waring sign.Especially if u find yourself having to make changes in more than one place,in this case both the enum and the corresponding switch statement,each time that u wnat to add new functionality.If this sounds familiar to u,then it may be time to take a look at the strategy pattern for your own needs.

WEB

    1. IE6 Warning- Stop Living In The Past- Get off of IE6

    2. Formatting source code in a blog post

English

    1. Microsoft Certification Exam: 微软认证考试

    2. Polymorphism: 多态性

    3. Corresponding: 一致的，符合的