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 →

Dear Friends We are launching the YouTube Channel “Decode ITES”. Decode ITES will be sharing technical videos over multiple IT infra skills like SQL Server, Postgres, Oracle, Windows, Public Cloud, VM Ware, Backup, Network, Storage, etc.. Decode ITES is a continual part of successful Web blog “https://mssqlfun.com/” from the last 5+ years with thousands of … Continue reading →