Reputation
8,540
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 21 57
Newest
 Nice Answer
Impact
~589k people reached

1d
revised MySQL database repair - innodb tables
Comments to question
2d
revised ORA : 12519 No appropriate Service Handler
Comments are ephemeral
2d
reviewed Close Copy MySQL database between two Windows 10 laptops
2d
reviewed Close Altering column data SQL
2d
comment Altering column data SQL
I think the mechanism with which you are attempting to implement the age calculation is a horrible one and will not scale over time. You know when an event occurred. You know what today is. You can perform the calculation to determine the age. You replace your start date with the age and now you've lost the original date, but that's ok because you have age. The sun sets and now it's tomorrow. Is the Age still correct? Probably. 17 months from now, you've long forgotten about this one time conversion query - a business user is going to ask, is that age correct? How will you be able to prove it?
2d
reviewed Close Manual sync between 2 SQL server databases
2d
reviewed Close Disk Space issue
2d
reviewed Close what does “\” symbol mean?
2d
reviewed Close Can mirror and witness have same port number?
2d
reviewed Approve How to tune MySQL Data engine Innodb
Apr
26
comment Help with SSIS Framework- Resolve Referrences in Data Flow
Which template did you start with?
Apr
26
revised Help with SSIS Framework- Resolve Referrences in Data Flow
pi
Apr
25
comment Failed to execute IS server package because of error 0x80131904 … System.ComponentModel.Win32Exception: The handle is invalid
internal.start_execution_internal is a CLR method in the SSISDB that ships from MS. Best I can think of is to check system health XE and SQL error log to see if you can correlate system activity to the exceptions. The other semi-obvious thing is to ensure you're on current patch level. After that, it might warrant a call to CSS
Apr
20
comment SSIS Package Error Unable to locate reference column
Usually when this happens, it's the result of a schema change - someone has renamed or dropped a column. The other place to look is whether a run-time value is changing the destination a given connection manager is pointing to. Right click on the deployed project in the SSISDB and select Configure... see if there's an active configuration and it's pointing to somewhere unexpected
Apr
13
comment Can I print RAISERROR message from SQL task in an SSIS send e-mail task?
Decompose your problem into smaller steps until it can be solved. Step 1 - can I capture text of SQL RAISERROR in an Execute SQL Task. Off the top of my head, I can't think of anywhere in the task itself that information would be available. But, you can look at the OnError event handler as that data might be available there. The OnError event handler has 3? variables that are only scoped to it. If the messages are populated, then it's a matter of a script/expression task to copy the details into a variable you then use as the basis for MessageSource change MessageSourceType to not direct input
Apr
13
reviewed Approve Cannot execute inserts querys after upgrade to mysql 5.7
Apr
8
answered Trying to query AD on a linked server error message is 7321
Apr
8
revised Trying to query AD on a linked server error message is 7321
form
Apr
6
comment SQL Server : ETL Stage Index
For your staging/historical table, do you need more than one month's worth of data to satisfy the DW load?
Apr
5
revised Using DateTime Variable In Where Clause
Thought I'd tack in the global temporary table approach for future readers.