Why is it that anytime people find out that they might have to pay for something to connect to these sources that there is an uproar and outrage on this...

Your access function could have logic built in to check hierarchies. The function can do a whole lot more than just compare user names.

Is it just me, or does the RLS implementation by Microsoft seem too complex? Why not just set your RLS in a view like the ssis team did with the...

Had no idea you could do this. This will really help me from doing stupid stuff in prod in the future :-D. I'll just make prod red and dev green

I'd honestly take XML and Xquery over the other two methods any day. TVP's seemed to still be in the infant stage of their development, meaning they have to be...

Pretty helpful. We are using this framework at our office to automate some SSIS tasks. One question though:

1) sometimes the source and destination columns in our tasks don't line...

I always use the stuff function to make a string array seperated by a delimeter:

declare @mystatus as table (stat_id int identity(1,1), stat_desc varchar(25) null);

insert @mystatus

select 'Active'

union all select...

kpatrick (7/2/2012)

---

Some questions to consider:

1. What kind of Windows Server security permissions does the identity running the SSIS package need in order to execute the WMI query? In...

I would suggest setting up a database trigger instead that tracks ddl events:

create trigger [LOG_EVENTS]

on database

for create_procedure, alter_procedure, drop_procedure,

create_table, alter_table, drop_table,

create_function, alter_function, drop_function

as

set nocount on

declare @data xml

set