Using Louis Vuitton and an Army bag to store your historical Data

This is a guest post by Christoph Hanser. Christoph is currently working as a freelancer in .NET, SQL Server, and BizTalk projects. He is originally from Hamburg but has studied also for a semester in Sweden at the Uppsala University. His blog is http://eai-technologies-and-their-pitfalls.blogspot.com/.

What does a fancy Louis Vuitton and an armee bag have in

Continue reading […] Using Louis Vuitton and an Army bag to store your historical Data […]

 

How to risk losing data and how to have most down time

Sorry about the blunt title, but I had no choice.

In a previous post I mentioned how important the design of the database files is. It is important for two reasons: performance and recovery.

Here comes the analogy:

Imagine, you are writing a book. You have written already 500 pages and you are keeping indigo copies somewhere.

You

Continue reading […] How to risk losing data and how to have most down time […]

 

The fundamentals of database structure

Think of a database as a bucket. Actually, scratch that.
Think of the database as a chemistry distillation glassware. Something like this:

Database File Structure

Each database is structured in a way that it has at least one filegroup (containing at least one data file), and at least one log file.
Think of the filegroups as

Continue reading […] The fundamentals of database structure […]