Saturday, 1 October 2016

FRAGMENTATION CONCEPT IN SQL SERVER DBA

FRAGMENTATION CONCEPT IN SQL SERVER DBA

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

Wednesday, 28 September 2016

SQL Server Security Authentication Concept

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

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

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

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 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
Pages (3)123

 
biz.