Category Archives: Database

How to set up Basic Always-On Availability Groups in SQL Server Standard Edition

Posted on 20 March 2024 by admin

Set up Basic Always-on availability & disaster recovery In SQL Server Standard Edition Index Contents Index 1 Introduction 2 List of acronyms used in this document: 2 Explanation 2 A brief explanation of what BADR is and why we use … Continue reading →

Posted in Database, Programming | Tagged , , , | Comments Off on How to set up Basic Always-On Availability Groups in SQL Server Standard Edition

Why Normalise Database Tables?

Posted on 13 July 2011 by admin

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 … Continue reading →

Posted in Database | Tagged , | Comments Off on Why Normalise Database Tables?

Table Partitioning

Posted on 30 September 2010 by admin

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

Posted in Database | Tagged , | 1 Comment