Pages
(Move to ...)
Home
Oracle 12c
Oracle 11g
PL/SQL
MySQL
Data Warehousing
SQL Server
Data Analytics
Big Data
NoSQL
About
▼
Showing posts with label
SQL Server
.
Show all posts
Showing posts with label
SQL Server
.
Show all posts
Identity and Access Control: Authentication and Users
›
Access to a SQL Server database takes place through three levels of security . In each one you need to have access and permissions config...
SQL Server: the data dictionary
›
Distribution of catalog information: What is stored in the master database? What is kept in the user databases? Base metadata tables are...
SQL Server: Database Snapshots
›
Available only in the Enterprise version . Snapshots provide read-only , static views of a database. Each snapshot capture the state of...
SQL Server: Moving a Database
›
Three mechanisms for moving a database (within the same server, or between servers): Backup and Restore Copy Database Wizard Detach/A...
SQL Server: Database Configuration Options
›
Configuration Options Autogrowth Recovery Model Compatibility Level Auto Shrink Restrict Access Autogrowth - Property of each ...
›
Home
View web version