If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
2,779 reads
2015-05-13 (first published: 2013-03-14)
5,520 reads
This script automatically generates stored procedures for insert, update and delete operations on the given table
2009-08-12 (first published: 2009-07-23)
2,097 reads
Just a thought, but it struck me that the difference between Consistency Check and Concole Command could possibly be significant in a certification exam. I would really hate to miss a question on something so trivial.Myself, it'll always be the former, I harken back to the 4.21a days on top of LanMan/OS2.
2005-05-05
I need to be able to set the DTSDestination column dynamically using a variable for the column name. Here is the code I am using: strColName = cstr(DTSSource("ColName")) DTSDestination(strColName ) = DTSSource("QVal") I am getting the error "Invalid procedure call or argument: 'DTSDestination'". I'm sure that I am just missing something.Thanks!
2004-10-04
3 reads
I didn't know that you could license SQL Server to a person. I thought there were only two licensing options.CALPer processorIn my case I deal exclusively with systems accessible via the web so only per processor applies to me.Most people don't give a pair of fetid dingos kidneys about licensing until FAST come knocking at […]
2004-01-29
Thanks to all. I will test the CASE option as well as the view. The temp table could be an option later. I created a store proc this morning and will test that one too. Thank you again.
2004-01-28
This may be a dumb question, but is DTS an option for you? Using a text file as the source and an table as the destination can be extremely fast. With straight ActiveX copy columns I've been loading around 700,000 records in about 9 minutes. These are not small records, either....over 150 columns, and our […]
2003-06-23
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers