Lesson 2 Flashcards
What are the four system data base
master, model, made, temping
Data base with no user object
Empty shell database
In the server, we can create database using 2 options
gui and script
What is the Major version, Minor version, and Build number For 13.0.1601.5
Major Version- 13
Minor Version- 0
Build Nimber- 1601.5
Every time a Hot fix is applied which part changes
The build number
What command do you need to type to see if you have SQL server is installed in your computer
Service.smc
Best friend of the DBA- that automate things is called
SQL Server Agent
If you have named instances and you want to browse through them, we need
Browser
If you want to see only SQL server related services in your computer, what do you use
SSCM
The three network protocols available in SQL server
Shared memory, Named Pipes and TCP
The difference between the three protocols
Shared memory- server level
Named Pipes- LAN Local Area
TCP/IP- WAN Wide area network
To Connect to the server, we need to go ti or search
SSMS - SQL server management studio
ETL stands for
Extraction, Transformation, and Load
Take data from OLTP to OLAP
To extract data, we need
SSIS - SQL server Integration Service
To generate report from two different Data bases, we need
SSRS - SQL Server Reporting Database
The three BI services
Analyze service, reporting service, and integration service
Another way to connect to the default instant in the server
Type Dot .
Or you can type the IP
Regarding update, what comes after a HOT Fix
Cumulative update and then service pack
When do we apply update to servers
During Down Time or off period
In place upgrade means
Updating on the machine
The last year for service pack is …….. and starting from that year, they only added ……..,,
2016/ commutative updates
There is no SQL update for SQL 2017
If there are two hyphens - -
It means it is comment -
Who manages the Active Directory- where all the machine name, server, log in information
Window Team/ System Administration/ Security admin
The three BI’s in SQL
Integrating, reporting and analyzing service
