Arturi Bits

Category: Programming

  • Set up Basic Always-on availability & disaster recovery in SQL Server Standard

    —

    by

    dfsch
    in , , ,

    Index Contents Introduction 2 List of acronyms used in this document: 2 Explanation 2 A brief explanation of what BADR is and why we use it: 2 Limitations 3 Prerequisites for setting up BADR 4 Now we need to do the actual Basic Availability Setup 4 Step 1: Enable Always On in all participating instances…

  • Why Normalise Database Tables?

    —

    by

    dfsch
    in

    Many GUI and web developers I have spoken to, do not fully understand the value to be gained from normalising their database designs. It is, after all, easier to build the tables to look exactly like the form or web page they are building. The question that usually arises when we as database “specialists” question…

  • File system storage

    —

    by

    dfsch
    in

    I am constantly amazed at how many people believe the only way to change the storage option of a hard drive from FAT or FAT32 to NTFS is by means of formatting the hard drive. the following  command line (DOS)  should eliminate all those issues (execute (command shell) on any drive other than the drive being changed):…

  • Table Partitioning

    —

    by

    dfsch
    in

    Recently presented a discussion at the SA SQL User Group in Bryanston, on the topic of Logical Patitioning Database Tables in MSSQL 2005 & 2008 presentation: TablePartitioning