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
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
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
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
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
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
SQL Server Versions – Identifiers
After installing SQL Server, you will discover a folder with a number of files under your program files. Any number, such as 80, 90, 100,
Big Data & SQL 