And possibly herein lies the problem with bugs.  My personal feeling is that those who create software should be the ones who have to find and fix the problems...

That should just be a matter of changing the date format, I based that off the article you were using to get the directory listing but for the date format...

The second solution I posted does not require pushing anything to SQL Server and should work with the standard PS install.

Hmm... it looks like that list directory is just returning an array of strings that you'll have to parse if you want the relevant file information.  As for getting it...

Now I'm curious what kind of use case requires Sybase and SQL Server installed on the same system.

Well do you actually have the 5 years experience on your resume?

That query should have the login and the sql command in it, you'll just need to add the filter.

Well does the account running SQL Server have access to the filepath?

You could do something like and filter as needed,

SELECT * FROM sys.dm_exec_requests er
INNER JOIN sys.dm_exec_sessions ses on er.session_id = ses.session_id
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) sql_text

Hmm... you wouldn't put the pagination in the order by clause.  The order by clause is used to define the result set then the pagination filters it.

As a Data Architect I'm primarily focused on ETL in a MS stack.  Official tools are pretty much just our 2 main ETL tools, we don't use SSIS, and some...

Well if you make your categories broad enough then sure everyone will fit into a small number of categories.  And in that case most companies will fit into some broad...

Just the parts that would be impacted,

For the params, if you want to keep the date as a datetime to let powershell auto validate the format you'll need to check...

Another option might be to default the parameters to wild cards and use -like instead of -eq in your comparisons since everything is strings.

Otherwise you're going to have to write...

Well how are you deciding which conf code for each badge number to use?

• This reply was modified 4 years, 6 months ago by ZZartin.