Can varbinary data type be compressed?

Data compression is one of the useful tools of sql server. But not all data types can be really compressed. What about varbinary data type?

Database principal permissions script

With the GUI of SSMS is it not easy to grasp all permission and role membership of a database principal. With the code following, you can get all object level and schema level permissions and role membership. If the principal is member of a role, the role membership is extracted until the end.

Create Index Rebuild Script With DMV

Creating an operation script via T-SQL is a common way. With T-SQL code following, you can create index rebuild script for all indexes which is fragmented more then 20 % .

Key Points Of Logon Trigger

SQL Server has a useful utility which is logon trigger. But if you don't be careful enough it can be very dangerous, even SQL Server instance may be out of service.