Reputation
8,879
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 19 57
Impact
~546k people reached

Aug
24
comment “Specify SQL Server administrators” - unusual default value
I would say that is necessarily impersonating a service SID in that example, he is altering what is called by the service. So you are simply what the service is calling. That is a cool way of doing it though.
Aug
24
answered “Specify SQL Server administrators” - unusual default value
Aug
23
comment Random and constant “Log Growths” Alerting, how to make it stop?
Well you have an alert firing based on how you configured it, so what action is taken to resolve the issue? If this is not an issue then why alert on it?
Aug
20
comment SMO Not Scripting DB Objects
Why would you put it under that profile? How are you trying to call PowerShell from T-SQL? There are plenty of reasons for it to give a behavior we do not know about. What error do you get or what output does SSMS show you?
Aug
18
revised Capturing sp_executesql statement in sql profiler
formatting
Aug
16
awarded  sql-server-2012
Aug
15
reviewed Reject Will I need to create a pivot or can I alter this query
Aug
14
reviewed Reject Why scalar valued functions need execute permission rather than select?
Aug
14
reviewed Reject Can't get access to other database
Aug
14
reviewed Approve Automate Backup of SQL Server Database Structure
Aug
12
comment how to pass the “file path” as a parameter in powershell?
In your function at this point foreach ($_), remove the ($_). You can also add this at the top of the script and it is possible more information on the error will bubble up to the job history: $erroractionpreference = "Stop"
Aug
11
comment PSQL not executing SQL command - Powershell
That might be something with psql. I can't really say as I don't have an installation of PostgreSQL on my machine to test with, sorry.
Aug
11
revised PSQL not executing SQL command - Powershell
added 634 characters in body
Aug
11
comment PSQL not executing SQL command - Powershell
You can try adding -NoTypeInformation to the last line and that should get rid of the #TYPE line.
Aug
11
answered PSQL not executing SQL command - Powershell
Aug
11
comment how to pass the “file path” as a parameter in powershell?
You might take a look at this question as well: dba.stackexchange.com/q/51870/507
Aug
10
comment SSRS Report drop down parameters. Use SP or embeded SQL query for datasource?
I think you answered your own question...it is up to the designer and the standard you want to use when building your reports.
Aug
10
reviewed Close PostgreSQL: How to get a sum of values and the total rows that went into each value?
Aug
10
comment Need to Sync Oracle DB table data with mysql
@RickJames This question and the one you linked to are both closure for shopping list request. Questions asking on tools to use are generally frowned upon, because the tool you say can work today may not be around in two years, or a better one is released.
Aug
10
reviewed Close Need to Sync Oracle DB table data with mysql