We've developed a couple of apps using ORM and E/F. As far as I can see, they are supposed to obviate the DBA.

And they worked -- for a while. But...

Got it:

$Code = "*_GOL_*"

Get-ADGroup -Filter {(name -like $Code)} | select -ExpandProperty name

Thanks!

John: You're right about the variable not substituting. The literal "*_GOL_*" returns the correct list.

Any ideas how to make this work?

$Code = "GOL"

This returns all the groups having "GOL" in their names:

Get-QADGroup "*$Code*"

This returns all the groups having _GOL_ in their names:

Get-QADGroup "*`_$Code`_*"

Both of these return nothing:

Get-ADGroup -Filter {Name -like...

Matt: Yes, that can be handled in my design. Although as I mentioned, I'm going to have to do some serious testing in order to determine if this is even...

You're now technical talking about *bi-temporal support*, not just temporal. As in - in order to provide the correct history in your OLTP, you will need to keep track of...

That's what I'm getting at: there won't be a separate warehouse anymore. Although historical reporting will not be done against the live database.

And yes, the application will be managing the...

Our product *is* the information in our database: if some of that content does in fact change 10 times in 10 minutes -- an unlikely scenario, but theoretically possible --,...

Where is gets complicated: our DB is effectively both OLTP and DSS/warehouse. For many years, we've been able to segregate the roles on separate servers, by refreshing the DSS server...

Hmmm. I see I've used the wrong term: I guess that should be "Temporal Database".

Although to be honest, I can't really see how they differ... tables have valid-from and valid-to...

Hi Shawn,

Thanks for the response.

1) Yep, as long as I know the password, life is fairly simple. But I don't. Which brings me to...

2) Execute As or SetUser would...

I like that, a little easier on the eyes.

Something like this?

http://mspowershell.blogspot.ca/2013/01/executing-tasks-in-parallel-in.html

Using my credentials (I'm a member of local admin on domain_1 SQL servers, and member of sysadmin on the SQL Servers. I'm an average user on domain_2.)

Msg 15404, Level 16,...

Hmmm....I wonder if we changed the SQL Server account to one from the other domain?