Database With Fun (While 1 = 1)

"The desire to create is one of the deepest yearnings of the human soul."  -- Dieter F. Uchtdorf   Before we jump into the designing part, lets take a quick look at how the SQL Server databases are formed. Database Files Ever database has one Primary data file, which by default has an .MDF extension. In addition, ever database can also have secondary database files, which have .NDF extension.   All database files are grouped into FileGroups. FileGroup is a logical unit that simplifies database administration.  Imagine houses in an area. We recognize each house with it's own number but we also include a lot og groups in the address. Sector is a Filegroup. Pin-code is a Filegroup. This is how it looks like in database. There are 5 disks with 4 data files and 1 transaction log file. You can add multiple data files inside a filegroup. This lets you spread the load across different storage drives. This could help you improve I/O performance. Filegroup1 - green - contains ...

“By failing to prepare, you are preparing to fail.”   ― Benjamin Franklin, Founding Father of the United States   Planning is usually the difference between a smooth road managing the SQL Server & a rocky one. Things to consider: Installation Requirements Selecting the features Scale up Capacity Planning Designing databases Security Core mode installation Bench-marking tools Installation Requirements This steps is all about information gathering. Let's identify all necessary components Evaluate Installation SQL components to install SQL Server Edition Operating System Virtualization Target Hardware     Scale-Up and Scale-Out Gone are the days when someone could predict the Max database size, etc in an early discussion meeting. Ideally you want your business to grow and that means more and more data. You design should consider that possibility. Assuming your database is hosted on a VM, it should have access to Ram, Processor and Storage so you can Scale the syste...