Understand Permission Function

fn_my_permissions fn_my_permissions ( securable , 'securable_class') Arguments securable Is the name of the securable. If the securable is the server or a database, this value should be set to NULL. securable is a scalar expression of type sysname. securablecan be a multipart...

Read more »

The "Balanced Data Distributor" for SSIS

There is a new transform component available for SQL Server Integration Services.  It's called the Balanced Data Distributor (BDD) and the download is available here.  The BDD provides an easy way to amp up your usage of multi-processor and multi-core servers by introducing parallelism in the data flow of an SSIS package. Functionality of the BDD The functionality of the BDD is very simple:  It takes its input data and routes...

Read more »