The databases that are loaded with SQL Server are known as system databases. These are used to store system-level data, metadata data, data about scheduled
Category: SQL Server
SQL Server Administration, Development and Maintenance
SQL Server – Connecting through CLI
You can connect to a SQL Server instance using either the GUI (SQL Server Management Studio) or the CLI (Command Line Interface). We’ll demonstrate connecting
SQL Sub Languages
The sub-languages that SQL supports fall into 5 categories. The primary purpose of these sub-languages is to add, remove, or change database objects, and they
Installation of SQL Server
Microsoft SQL Server is a Relational Database Management System (RDBMS) that can be used on a variety of platforms, including small single-processor computers and big
SQL Server Objects – Object Explorer
All Microsoft SQL Server components can be configured, managed, and administered using SQL Server Management Studio, a software that was initially released with Microsoft SQL
Denormalization
By adding redundant data to one or more tables, denormalization is a database optimization approach. In a relational database, this can help us avoid expensive
Big Data & SQL 