Reputation
5,883
Next tag badge:
88/100 score
26/20 answers
Badges
10 24
Newest
 sql-server
Impact
~138k people reached

Apr
23
awarded  sql-server
Apr
22
comment Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible
@RoniVered Ah! My bad, I didn't see that. Sorry.
Apr
22
answered Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible
Apr
14
answered Generate backup script of SQL Agent Jobs using c#
Apr
13
answered Need help with this backup audit SQL Server script
Apr
13
comment Need help with this backup audit SQL Server script
In my opinion, it doesn't make much sense. How are you correlating the 1st full backup file with the 1st diff backup file? And what happens if you have 6 diffs and 4 fulls?
Apr
13
answered is there a way to find out who was spid228 at a given time in the past?
Apr
11
answered Get a listing of snapshot data files
Apr
5
comment How to script permissions for all logins/users/tables/schemas
@KennethFisher sure, it's nice to have them scripted out. For me it's usually just a matter of adding/removing members to/from roles.
Apr
5
answered Principle of least privilege for sql server agent jobs
Apr
5
comment How to script permissions for all logins/users/tables/schemas
@KennethFisher you usually have roles for that.
Apr
5
comment High Availability Options for 2008 R2 or 2014 to 2016 “Mirror” for Reporting?
While I completely agree with your answer, it might be beneficial to the OP to understand WHY replication is the best option here. Also, stressing the limitations and the operations on the publisher that invalidate the subscriptions and/or snapshots would be of great help.
Apr
5
answered How to create an insert trigger?
Mar
19
comment Check constraint
I think that also escaping it with [ would work. I don't have a SQL server around to test it though
Mar
19
comment Check constraint
Great catch! I didn't think about that, but you're definitely right
Mar
19
comment SQL minimum permissions to manage any job
@fed1999 then I'm afraid that granting sysadmin is the only option you have, besides giving job ownership to the users. See the two answers you already have here
Mar
18
comment SQL minimum permissions to manage any job
How are you expecting users to manage the jobs? With SSMS or with a custom GUI/application? I'm asking because the answer depends on what you're planning to do.
Mar
17
comment Awful performance on joined queries while great separately
@Hauri you can post your plans anonimyzed for free at SQLPerformance.com using SQLSentry plan explorer (free). Without the plans it's a guessing game.
Mar
17
comment how to send email message with the results of a job?
I would simply add a call to sp_send_dbmail in the job step. Would that work for you?
Mar
17
comment How can i filter an extended event session by is_cache attribute?
In your question you mention is_cached, but your code sample attempts to filter on is_dac. Which one of the two are you trying to filter?