View on SQL Server View

Advantages Views are used for several different reasons: 1.     To hide data complexity. Instead of forcing your users to learn the T-SQL JOIN syntax you might wish to provide a view that runs a commonly requested SQL statement.   2.     To protect the data. If you have a table containing sensitive data in certain columns, you might wish to hide those columns from certain groups of users....

Read more »

Know System Databases

Master Purpose – Core system database to manage the SQL Server instance. In SQL Server 2005, the Master database is the logical repository for the system objects residing in the sys schema. In SQL Server 2000 and previous editions of SQL Server, the Master database physically stored all of the system objects. Prominent Functionality Per instance configurations Databases residing on the instance Files for each database Logins Linked\Remote...

Read more »

Types of startup accounts

Local User Account: This user account is created in your server where SQL Server is installed, this account does not have access to network resources.Local Service Account: This is a builtin windows account that is available for configuring services in windows. This account has permissions as same as accounts that are in the users group, thus it has limited access to the resources in the server. This account is not supported for SQL SERVER...

Read more »

SQL Server 2012 Certification Exam Codes

v  Querying Microsoft SQL Server (70-461) [BI and DBA]v  Administering a Microsoft SQL Server 2012 Database (70-462) [DBA]v  Building Data Warehouses with Microsoft SQL Server 2012 (70-463) [BI]v  Developing a Microsoft SQL Server 2012 Database (70-464) [DBA]v  Designing Database Solutions for SQL Server 2012 (70-465) [DBA]v  Implementing Data Models and Reports with Microsoft SQL Server 2012 (70-466) [BI]v  Designing...

Read more »

FILESTREAM Example

FILESTREAM FeatureFILESTREAM was introduced in SQL Server 2008 for the storage and management of unstructured data. The FILESTREAM feature allows storing BLOB data (example: word documents, image files, music and videos etc) in the NT file system and ensures transactional consistency between the unstructured data stored in the NT file system and the structured data stored in the table.Storing BLOB data in NT file system, allows SQL Server to take...

Read more »