Category Archives: SQL Server

I am excited to share that MSSQLFUN reaches the milestone of 1000 subscribers with your support. Thank you, everyone, to stay along with me on this journey. I started this blog for the self repository of SQL Server knowledge articles, Later I made it public to connect with you all. I had also started 2nd … Continue reading →

Hyper-V is a Microsoft feature to create a virtualized environment. Hyper-V is available in your windows OS and you need to enable it from “Turn On or Off Windows Feature”. You can enable Hyper-V and create your own virtual environment. This helps in running multiple operating systems on a single physical computer. Note: Hyper-V option … Continue reading →

SQL Server Architecture SQL Server is Microsoft RDMS that works on a client-server architecture. Here, End-user sends a request and SQL Server accepts, process, and share the result with the user. This seems a very simple process from frontend however there are multiple processes runs in the background to fulfill this request. Microsoft SQL Server … Continue reading →

SQL Server editions:- · Enterprise – Enterprise edition is the topmost edition with all available features. This is best suited for mission-critical Tier 1 applications. Enterprise edition is the capabilities of tremendous hardware scaleup. · Standard – Standard edition is mostly used in economic edition with limitations of hardware support and advance features. In case … Continue reading →

RDBMS means Relations Database Management System. RDBMS is one of the DBMS types where data is stored in 2 dimension structures called “Table”. RDBMS stores data in table format with rows and columns relations. Types of DBMS:- Hierarchical DBMS Network DBMS Relational DBMS Object-Oriented DBMS We have multiple RDBMS available products in the market Oracle … Continue reading →