How to differentiate Logical Server versus Onpremise SQL Server in SSMS ? | SQL School

How to differentiate Logical Server versus Onpremise SQL Server in SSMS ?
Scenario Based Interview Question:
YOU JOINED A NEW PROJECT. YOU WERE GIVEN ACCESS TO ONE SQL SERVER.
YOU WERE GIVEN WITH ONE SQL SERVER NAME, SQL AUTHENTICATION DETAILS : LOGIN, PASSWORD.
YOU CONNECTED TO THE SERVER FROM SSMS TOOL.
HOW DO YOU IDENTIFY WHETHER IT IS AN ON-PREMISE (NON CLOUD) SQL SERVER OR AZURE SQL SERVER (LOGICAL SERVER) ?
ANSWER:
Identify based on
1. SERVER NAME
2. VERSION NUMBER
3. SQL AGENT
4. MANAGEMENT FOLDER
5. REPLICATION
6. PROPERTIES
7. OS DEPENDANCY
For more such videos:
1. Follow us on #youtube Channel : / sequelschool
2. Join us #whatsapp Channel : whatsapp.com/channel/0029Vaep...
3. Join our #linkedin Page: / sql-school
4. www.sqlschool.com
#sqlschool #isocertifiedinstitute #bestrainingcenter #besttrainers #bestsql #bestazuretraining #bestplacetolearnsql #bestplaceto learnpowerbi
At SQL School, we provide Trainings and Projects on:
1. SQL Server
2. SQL DBA
3. Azure Data Engineer
4. Power BI
5. Azure SQL DBA
6. Snowflake
7. Python Analytics
8. Python Programming
Applicable Job Roles:
1. SQL Developer
2. SQL Database Aministrator
3. Data Analyst
4. Business Analyst
5. BI Developer
6. Data Engineer
8. Big Data Analytics
9. Data Science
10.Report Developer
11. ETL Admin
12. BI Admin
13. Cloud Admin
14. Programmer
Why Choose #SQLSchool?
1. 100% Real-time and Practical Trainings
2. Weekly Case Studies
3. End to End Projects
4. Cloud Integrations
5. Real-time Projects
6. Errors, Solutions
7. Concept wise FAQs
8. Resume Guidance
9. Job Assistance
10. Project FAQs
Latest Schedules, Free Demo: www.sqlschool.com/Register
Course inquiries: pls reach us on wa.me/[phone]
Reach me (Trainer) at: wa.me/[phone]
[e-mail]
www.sqlschool.com
[phone] (USA)
Website: www.sqlschool.com
Join this channel to get access to perks:
/ @sequelschool