Compress Archive Databases, Gain Disk Space And Improve Performance

Database Compression is one of the useful functionalities that is became available with SQL Server 2008. By compressing tables and indexes of archive database, you can gain 6-8 time disk space and reduce I/O workload.

Opendatasource And 'NT AUTHORITY\ANONYMOUS LOGON' Error

When you use opendatasource to query something, you may get the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." 

Foreign Key With Nocheck checks foreign key

Although foreign key is created with "with nocheck" option, it checks foreign key. It has to be run nocheck script.

Change object schema

Sometimes it is needed to change schema of object. Because objects are created under wrong schema.
Unfortunately it is not possible to change schema using Management Studio.

Database compatibility level check with Policy Based Management

Sometime database compatibility level is lower than server level. Normally database compatibility level must be up to date. If you have lots of SQL Servers, to check all databases manually is not  the optimum way.

Policy Based Management And Filtering

With policy based management, it is possible to define policies and evaluate the policies against lots of instances and againsts lots of objects. While evaluating policies, to exclude the object and the servers which are out of scope will optimize the management.