Viewing 15 posts - 1 through 15 (of 329 total)
That seems like a practical approach! A ticketing system.
We just need the courage and persistence to tell everyone we need a ticket for stuff that...
October 19, 2017 at 4:19 pm
Thank you again. It's amazing to me how the notion of "data-tier app" and registration is so valuable yet most documentation is largely unclear on this on their purpose.
June 27, 2017 at 9:13 pm
That's a great answer. I have one question: you wrote
>>> The dacpac has the definitions and properties and registering allows SQL Server to use the files...
June 27, 2017 at 8:00 pm
>> So, you don't care what the non-primary key columns contain at all? In other words, you never have the need for an UPDATE?
Correct. It's simply a matter of replacing...
October 12, 2016 at 8:14 pm
Another great thought. You're not rookie!
October 12, 2016 at 8:13 pm
Great idea!. I was thinking about something along that line but it didn't quite crystallize. Your push got made me think about it again and it became much clearer.
October 12, 2016 at 5:14 pm
No replication either (as the source DB is already involved in a replication relationship.)
October 12, 2016 at 5:07 pm
I asked about that and they said "no" (as third parties are involved in the drama and that could impact their code.)
October 12, 2016 at 5:06 pm
Very interesting script. I'm reviewing it now....
March 29, 2016 at 5:58 pm
We have Sql 2008! Everyone holds the tantalizing "sp_WhoIsActive" in front of me but I was hoping to find documentation describing how to effectively use...
March 29, 2016 at 7:18 am
I will watch that URL tonight!
March 23, 2016 at 5:48 pm
I'm new to SSIS 2014. You wrote
>>> To combat this I reduced the default values for how long information (365 days) and project versions (10 I believe) are...
February 9, 2016 at 11:00 pm
Very good ideas! Will explore.
Thanks Gila and Grant
January 11, 2016 at 12:36 pm
Indeed the 8060 byte row limitation is a reality but regarding the SSIS default of 50 I would need to manually updated hundreds of fields in SSIS to correct their...
September 30, 2015 at 6:59 am
Thanks for the answer. A part of one sentence was not complete:
"domains (racks) and upgrade domains (groups of hosts that . "
July 14, 2015 at 5:55 pm