The standard approach from MS would be to use AD groups to nest the permissions. Example:

new user bob would be added to the accounting group

the accounting group is a member...

I have a wait performance script that can be run for short periods of time to estimate which user or database is consuming more resources, but it is still an...

Use the Foreach Loop Container to find all the *.csv files in the folder. Use an expression on the file connection manager to assign the actual file name. For easy...

Do you need a true full accounting of the CPU time per application or do you just need to know in general which application uses the more CPU?

my bad, need another cup of coffee

You can copy the records in the DB, but as always, MS does not recommend that approach

In SSRS Roles = permission sets such as...

Do all the tables have the same columns?

Do all the tables have a single column for filtering the last quarters?

Is this a Kimball design with fact and dimension?

Microsoft, even with all their documentation not to build systems that need SA, still build SharePoint server with the requirement of securityadmin and dbcreator, which gives the services account 99%...

Gary Varga (2/25/2014)

---

Phil Factor (2/25/2014)

---

...A lot of attacks seem to merely probes to determine weaknesses. Others, if successful, take effective control of the server, but in a way that is...

I highly recommend using database roles for this requirement. Assign the permissions to the role and the next time around you just add the user to the role.

At some point, this type of logic becomes easier to write and maintain as a script task embedded in a package.

create a datetime dimension and join to it for the sort

Create Table dimDateTime (

DateOrder int,

MonthDescr varchar(10)

)

insert into dimDateTime values

(1,'JAN 2012'),

(2,'FEB 2012'),...

I don't have a set of screen shots handy, but these are my normal steps:

1) create a SSIS variable

2) use a SQL task to query they first database

3) use the...

I tell people that modern hardware is so powerful that it can overcome almost any bad code, then they write something like that!

Proves me wrong, everytime

Does the table have a trigger?

If you need to keep the delimiters, add them as names. put another column on the name table to indicate that is what they are, but it keeps all the...