Fragmentation: Storing data non-contiguously on disk is known as fragmentation. We have 2 types of fragmentation. Internal fragmentation External fragmentation 1.Internal Fragmentation: When records are stored non-contiguously inside the page, then it is called internal fragmentation. In other words, out of 8kb page data, pages left empty not
Saturday, 1 October 2016
Wednesday, 28 September 2016
SQL Server Security Authentication Concept
Authentication: Authentication is one of the security concept in SQL DBA.. Validating credentials(user name and password) on server called Authentication.For any user who are connecting to server will have login name and password. We have 2 types of logins: Window login SQL Server login 1.Window login
SQL SERVER DBA MIGRATION CONCEPT
MIGRATION: Migration means moving one or set of databases from one server to another server. Pre-Migration Checklist: Analyze the target server disk space for the new database, if the disk space is insufficient add more space on the target server Confirm the data and log file location
DBA'S Roles and Daily Activities
DBA's Roles and Daily Activities: As part of DBA team need to provide 24/7 production support to client and users. We will look into client mail box first and respond to required mails We will check Ticketing tool and will work on the available tickets which includes Incidents,
SQL Server Security Authorization Concept
Authorization: Once user connected to server,they should have permissions to perform/operating certain tasks. As a DBA we need to restrict the permissions by granting the roles,roles are set of privilages for connection server and to access the database. We have 2 types of roles. Server role
Protocols available in SQL Server DBA
Protocols available in SQL Server: SQL Server network interface(SNI) is a protocol layer that establishes the network connection between the client and server. SQL server supports 4 protocols 1.Shared memory 2.Named pipes 3.TCP/IP 4.VIA Shared memory: It is default protocol used to connect client and SQL server on the same
SQL SERVER DBA ATTACH AND DETACH THE DATABASES
It is one of the method for moving the database from one instance to other instance in sql server.In this process real time used for sql DBA's. lenova
Subscribe to:
Posts (Atom)