Resource database in sql server

Resource database is read only database includes all Sql server system objects. Resource database deals with sql server system Meta data whereas master database contains user metadata. It is use for compatibility changes that why it is not accessible to user. Resource database makes sql server version upgrade much faster where as in old version ...

Policy Based Management in SQL Server 2008

Most of company has their own policies related to the business in which they deal and to implement those policies on production server is very tedious work. SQL Server 2008 introduces new feature of policy based management to implement business policies and security policies on production.   Policy based management is collection of various policy ...

SQL Server – Move database using sp_detach_db and sp_attach_db

This article will help you to understand different options for moving database files (i.e. mdf and ldf ) from one to another location and sp_detach_db and sp_attach_db statement help you to move these files. Here will give you an idea that are available with SQL Server 2005 and step by step approach for moving database ...

SQL Server 2008 R2 new features

Transparent Data Encryption Encryption can be applied on database, data files or log file level without changing application code. The main benefit of TDE (Transparent Data Encryption) is securing data from unauthorized users without any application change. Extensible Key Management The new feature added in SQL Server 2008 is extensible key management which allows integrating ...

SQL Server Database Migration Checklist

As SQL DBA, you might come across activity like SQL Server database migration from one to another server. While migration of database you should take care some important things like transfer of logins or dependent objects and jobs related to database that will participate in migration. There is possible chance of missing some steps which hurt ...

SQL Server- How to Upgrade SQL Server 2005 to 2008

SQL Server Upgrade from 2005 to 2008 While upgrading sql server from one version to another version like sql server 2005 to 2008, recommended to run the sql server upgrade advisor to find out if there is any issue before and after up-gradation of sql server database. We have two type of upgrade in sql server In ...