Welcome to the SQLOcean.com website!

Are you looking for an easy, fast, and efficient way to master SQL Server development and administration skills, then you have landed at the right place.

Our tutorials are practical and include numerous hands-on activities for better understanding for beginners as well as professional.

After going through our articles related to any topic, you will have a better thoritical and practical information about the same.

Let’s get started-

Microsoft SQL Server is basically a relational database management system(RDBMS) developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as used by other applications, which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

SQL Server Log Architecture

SQL Server Log Architecture

The log file is not just that stores information, this is mainly responsible for data consistency. This file stores all the transactions that modify/add data in the database.        Log files has VLF (Virtual Log Files) in it instead of pages unlike data files. VLF’s may not be of the same size, we can manually change ...
SQL Server Page Architecture

SQL Server Page Architecture

The page is the basic building block of storage in SQL server. Data is stored in datafiles (.mdf and .ndf).  Storages are built by group of pages, logically speaking data is stored in pages. Each page is of 8 KB (8192 bytes) in size, unlike the page/block size in filesystems, SQL server cannot change the ...
SQL Server Database Architecture

SQL Server Database Architecture

SQL Server database is a logical collection of data. In SQL Server, data is stored in two set of files, Data files and Log files. When we create a database there are two files created for every database that is the Data File (.mdf) and Log File(.ldf) and a Primary filegroup (a container) is created ...
Close Menu