CATEGORY |
MS SQL Server 2012 - DBA Articles
|
KEY WORDS |
Installation and Configuration |
Level 01 |
Editions of SQL Server 2012 |
Pre-installation |
Level 01 |
Comparing the SQL Server 2012 Express, Web, and Standard Editions |
Pre-installation |
Level 01 |
Components of SQL Server 2012 |
Pre-installation |
Level 01 |
Management Tools of SQL Server 2012 |
Pre-installtion |
Level 01 |
Hardware and Software Requirements for Installing SQL Server 2012 |
Pre-installation |
Level 01 |
What's New in SQL Server 2012 - Installation |
Pre-installation |
Level 01 |
Installation for SQL Server 2012 - Default Instance |
Installation |
Level 01 |
Installation for SQL Server 2012 - Named Instance |
Installation |
Level 01 |
Overview of SQL Server Configuration Manager |
Post-installation |
Level 01 |
Overview of SQL Server Services |
Post-installation |
Level 01 |
Start, Stop, Pause, Resume, Restart the SQL Server Services |
Post-installation |
Level 01 |
Change the Service Startup Account for SQL Server |
Post-installation |
Level 01 |
Configure a Server to Listen on a Specific TCP Port |
Post-installation |
Level 01 |
Configure a Server to Listen on an Alternate Pipe |
Post-installation |
Level 01 |
Enable or Disable a Server Network Protocol |
Post-installation |
System and User Defined Database |
Level 01 |
System Databases of SQL Server 2012 |
Database |
Level 01 |
Database Files and Filegroups of SQL Server 2012 |
Database |
Level 01 |
CREATE DATABASE - User Defined Data and Log Files |
Database |
Level 01 |
CREATE DATABASE - Secondary Data Files with User-defined Filegroup |
Database |
Level 01 |
SET DATABASE - Multi-users to Single-user Mode |
Database |
Level 01 |
ALTER DATABASE - Compatibility Level of SQL Server 2012 |
Database |
User Authentication in SQL Server 2012 |
Level 01 |
Principals and Permissions Hierarchy |
User Authentication |
Level 01 |
Window vs. SQL Authentication Mode |
User Authentication |
Level 01 |
SET - SQL Server Authentication Mode |
User Authentication |
Level 01 |
SQL Server - Password Policy |
User Authentication |
Level 01 |
SQL Server - Server Level Fixed Roles |
User Authentication |
Level 01 |
SQL Server - Database Level Fixed Roles |
User Authentication |
Level 01 |
CREATE LOGIN to connect SQL Server Instance |
User Authentication |
Level 01 |
CREATE DATABASE User to connect Database |
User Authentication |
Level 01 |
Recover - System Administrator Access of SQL Server |
User Authentication |
Fundamental of SQL Statements |
Level 01 |
Overview of Data Definition Language |
DDL Statements |
Level 01 |
CREATE DATABASE - User Defined Data and Log Files |
DDL Statements |
Level 01 |
CREATE DATABASE - Multi Disks Data and Log Files that deployed with Filegroups |
DDL Statements |
Level 01 |
ALTER DATABASE - Add, Modify, Delete Secondary Data File |
DDL Statements |
Level 01 |
ALTER DATABASE - Add, Modify, Delete Log Information File |
DDL Statements |
Level 01 |
ALTER DATABASE - Add, Modify, Delete Filegroup Information |
DDL Statements |
Level 01 |
DROP DATABASE - Single and Multiple Databases |
DDL Statements |
Level 01 |
CREATE TABLE - Simple and Temporary Table Structure |
DDL Statements |
Level 01 |
DISCRIBE TABLE - Display Existing Table Structure |
DDL Statements |
Level 01 |
ALTER TABLE - Add, Modify, Delete Column Information |
DDL Statements |
Level 01 |
RENAME TABLE - Rename Table and Column Information |
DDL Statements |
Level 01 |
TRUNCATE TABLE - Delete Records from Table |
DDL Statements |
Level 01 |
DROP TABLE - Delete Existing Table Structure |
DDL Statements |
Level 01 |
Overview of Data Manipulation Language |
DML Statements |
Level 01 |
INSERT - Add Particular Columns of Record |
DML Statements |
Level 01 |
SELECT - Display Particular Columns of Records |
DML Statements |
Level 01 |
UPDATE - Modify Existing Records with Conditional Data |
DML Statements |
Level 01 |
DELETE - Delete Existing Records with Conditional Data |
DML Statements |
Level 01 |
Overview of Transaction Control Language |
TCL Statements |
Level 01 |
BEGIN ... COMMIT Transaction Process Flow |
TCL Statements |
Level 01 |
AUTOCOMMIT Transaction Process Flow |
TCL Statements |
Level 01 |
BEGIN ... ROLLBACK Transaction Process Flow |
TCL Statements |
Level 01 |
SAVE Transaction Process Flow |
TCL Statements |
Index - Database Read Optimization Technique |
Level 02 |
Pages And Extents |
Index |
Level 02 |
Overview Of Index |
Index |
Level 02 |
Type 01 - Clustered Index |
Index |
Level 02 |
Type 02 - Nonclustered Index |
Index |
Level 02 |
Type 03 - Unique Index |
Index |
Level 02 |
Type 04 - Filtered Index |
Index |
Level 02 |
Type 05 - BITMAP Index |
Index |
Level 02 |
Fill Factor Option |
Index |
Level 02 |
Index Defragmentation |
Index |
Level 02 |
Reorganize Indexes |
Index |
Level 02 |
Rebuild Indexes |
Index |
Level 02 |
Disable Index |
Index |
Level 02 |
Enable Index |
Index |
Level 02 |
Drop Index |
Index |