TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources
TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).
2017-08-28
2,733 reads
TDS
Connect to Salesforce Data as a Linked Server
Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.
2018-07-27 (first published: 2015-08-18)
7,101 reads
RE: Server Checkups
I think you did cover everything. But something you might want to look at is any locking/blocking in the databases. This will give you a good idea about the health of the system.
2005-02-14
RE: Snaking columns
Don't know if it would make a difference, but I have only created this kind of report using a table control, not the list control...have you tried it that way?
2005-02-04
RE: Query Help
Am I missing something here? what is wrong with this:Update o Set mynbr = datediff(d,(select min(mydate) from testt t where t.empid = o.Empid ),o.mydate) from testt o Tests:create table testt (recnbr int , mynbr int, mydate datetime, empid varchar(50)) goinsert into testt (recnbr, mynbr,mydate,empid) Values (1, 0 , '1/1/2001', 'bob') insert into testt (recnbr, mynbr,mydate,empid) […]
2004-07-26
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers