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

* * * * *

Email Your Comment To AUTHOR

Quick Links
Home
About Me
System Analyze Method
Dimensional Data Model
Entity Relationship Model
Relational Database Model
Tutorials
MS SQL Server - DBA
SSIS - Video Tutorials
SSAS - Video Tutorials
SSRS - Video Tutorials
SQL Server White Papers
Programming in SQL Server
Help Us
Terms Of Use                                                  Protected by Copyscape Online Plagiarism Tool             Copyrights © . Data-e-Education. All Rights Reserved.