Author: dfsch
-
Set up Windows Server Failover Clusters
Set up Windows Server Failover Clusters As a precursor for HA in SQL Server Standard Edition Index Contents Introduction 2 List of acronyms used in this document: 2 Explanation 2 A brief explanation of what WSFC is and why we use it: 2 Prerequisites for setting up WSFC 3 Additionally, verify the following account requirements:…
-
Data recovery services: What is it and when will you make use of it?
Have you ever had a PC that just would not start up? Or a hard drive that is just not read by any machine? Did an external hard drive stop responding, become unsearchable and/or start making funny clicking sounds? Have you ever formatted a drive (albeit hard drive or flash drive (memory stick)), only to…
-
Our current projects
We have several projects in the pipeline, covering a wide audience These include: > My Secret Secret, a simple encryption / decryption tool, making use of a complex encryption algorithm, with a dynamic key length, determined by the user. > Biblios Personae, a library application, making it possible to manage who you lend what to and…
-
Why Normalise Database Tables?
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…
-
Table Partitioning
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