T-SQL script to get detailed login permissions
This script is very helpful when you need to know all the permissions a user have in detail.
Tag: tsql
Method to update LOB data with minimal log
Use the .WRITE (expression, @Offset,@Length) clause to perform a partial or full update of varchar(max), nvarchar(max), and varbinary(max) data types. For example, a partial update of
Using SQL Operations Studio Agent
SQL Operations Studio Agent is visual way to see, edit and create SQL Server jobs and everybody was asking this
