Introduction to SQL Server Database Administration
The contents include: Exactly what is a DBMS, Security Management, Introducing SQL Server Manager System (SSMS), Administrative Tasks, Adding a new user, Changing a password,Re-enabling a locked out account, Granting/Denying Access to a DB, Granting/Denying Access to a Table, Creating a New Database, Deleting a Database, Creating a Table, Quick Tutorial on Data Types, Deleting a Table, Setting the Primary Key, Backing Up the Database, Restoring a Full Backup,Database Indexes Tutorial, Data Encryption.
Author(s): Tribal Data Workshop,CRITFC, Portland, Oregon
59 Pages
Introducing Microsoft SQL Server 2014
This book is for anyone who has an interest in SQL Server 2014 and wants to understand its capabilities. In this book, we explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions.
Author(s): Microsoft
NA PagesAdvertisement
