Reputation
2,091
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 12 29
Impact
~117k people reached

Feb
9
awarded  Nice Question
Feb
7
comment How do I grant the privilege of connecting to SSIS?
@imanabidi: you made that same comment weeks ago. Again: SSMS is not in any way related to this question. This is about SSIS.
Feb
3
answered Ordering of a dimension in sql server datawarehouse
Jan
13
comment How do I grant the privilege of connecting to SSIS?
@imanabidi: I'm not sure what SSMS has to do with it, but running dtexec as an admin did not solve the problem. Also, granting local admin privs may not be prudent, though it may be possible for testing purposes.
Dec
28
comment Database normalization: Which is the best fit?
What's the proposed schema for the unified child table?
Dec
18
awarded  Famous Question
Nov
28
awarded  Custodian
Nov
28
reviewed Approve Ctrl-F1 shortcut stopped working in SSMS 2014
Nov
12
comment How long is the output of EncryptByPassPhrase(), relative to the input?
That's exactly what I needed! I know it's usually bad form to accept an answer so soon, but this is a perfect answer.
Nov
12
accepted How long is the output of EncryptByPassPhrase(), relative to the input?
Nov
12
comment How long is the output of EncryptByPassPhrase(), relative to the input?
@srutzky: You are quite correct: the value had trailing spaces. I'd forgotten that SQL Server can store trailing spaces but doesn't report them with LEN.
Nov
12
asked How long is the output of EncryptByPassPhrase(), relative to the input?
Nov
2
answered Standard Time to Military Time
Sep
24
awarded  Notable Question
Aug
24
reviewed Reviewed How can I compare the number of transactions in the first weeks or months of different stores
Aug
20
awarded  Notable Question
Aug
19
awarded  Self-Learner
Jul
10
comment Efficiently storing sets of key-value pairs with wildly different keys
How much overlap is there in the fields? Do ten fields cover all 100 subtypes, or are there ~500 wholly distinct fields?
Jun
25
comment Where can I get error messages from SQL Server Auditing?
@ShawnMelton: Original RTM, 12.0.2000.8 (X64). Auditing is not mentioned in the SP1 release notes, but something could have been fixed or expanded.
Jun
25
comment What is the cause of this problem with CONVERT()?
@TomV: sure. Aaron did propose what seems to be the correct answer, so he should get the credit, but if wikifying it would be simpler I'm sure that's fine too.