8h
comment Server 2012 Linked Server From An Instance
blogs.technet.com/b/askds/archive/2008/06/13/…
8h
comment Server 2012 Linked Server From An Instance
The 'most correct' way to fix this is to grant the service account the ability to register its own SPNs. That way you never have any hard-coded ports.
13h
answered SSIS permissions for specific databases
13h
comment how to identify why lookup failed in SSIS
SSIS lookups are actually .net string comparisons. Therefore, they must be EXACTLY the same to match. SQL 'where' clauses are much more permissive regarding whitespace and capitalization.
14h
answered TSQL vs SSIS Lookup
14h
comment Prevent Subscription to report from running on a holiday
Protip: If your question is actually about SSRS, put that in the title. You didn't mention what your reporting system was.
14h
answered Loading XML data from SQL Server directly into MarkLogic?
14h
comment SQL ssis delete imported rows from source table
is right about the question you asked, but this smells like something you should be using Service Broker for. It's a weird technology for a dba, but it's the correct solution for the sort of slow-drip etl that you seem to be describing.
14h
awarded Supporter
14h
answered Metadata Headache
14h
comment Create a read only excel file from SSIS?
I should add that the second case does expose the file briefly until the command task runs. If security is essential, that may not be acceptable.
14h
answered Create a read only excel file from SSIS?
2d
comment SQL CLR project in vs2012
I seem to have the 'sql clr' and 'sql clr vb' templates available in ssdt 2010 and ssdt 2012. I'm open to suggestions on how to get 'sql clr c#' added. Causes or solutions?
Jan
24
accepted SQL Server Service Broker Compatability across versions?
Jan
15
answered Disk Space usage
Jan
15
comment SQL Server Service Broker Compatability across versions?
I want the triggers to stuff records into asynchronous queues, rather than getting into a cascading trigger mess.
Jan
15
comment SQL Server Service Broker Compatability across versions?
FWIW, I ran through the 2008R2 tutorial and it seems to work, though I had to grant some endpoint connect rights on the 2012 side. Bi-directional communication seems to work for simple cases, at least. I'll begin the implemetation and see what happens. I'd feel better I there was some sort of document stating the interop behaviour. BOL seems to have an attitude of "no major changes- should work...".
Jan
15
comment SQL Server Service Broker Compatability across versions?
Shimming in some triggers to catch DDL and sending the changes to the new system. We're changing several layers of the app stack at the same time- OS, SQL Version and Schema. The new system is under development and is planned to receive inputs via Service Broker anyway. During development, I would like send copies of incoming operational events to the 2012 instance to simulate production load.
Jan
15
comment Is there an English idiom for trying to do two things at the same time and failing at both of them due to splitting your effort?
I have always said "It's only multitasking if you succeed. Otherwise it's multi-failing."
Jan
15
asked SQL Server Service Broker Compatability across versions?
1 2 3 4 5