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
salesforce
Salesforce: A Very Straightforward Cloud Development Platform
Force.com is an enigma; a Platform-as-a-Service that is designed to appeal to a broad church of developers, to make it quick and easy to write simple cloud-based applications. Robert Sheldon explains, as simply as possible, why this unusual data-centric, and metadata-driven platform is attracting so much interest in the industry.
2015-01-05
7,123 reads
The Salesforce Platform: The Return of the Citizen Programmer
The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?
2014-11-24
11,320 reads
Synchronize Salesforce with SQL Server using SSIS
Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.
2014-09-30
5,788 reads
RE: Moving the Logfile
Allen,Thank You for the swift reply.As I said I am new to this forum, what do you mean by BOL.Also instead of doing the detach and attach using stored procedures, can I do them using the Enterprise Manager?? If so what is the proper sequence of events to move the Logfile?Thanks,
2005-04-29
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
trouble loading simple text file
I am having trouble importing a simple flat text file. My dts routine was running fine until the last couple of imports. The error I get is: Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Error Description: Column Delimiter not found When I tried to do a straight forward import using enterprise manager […]
2004-06-09
1 reads
RE: Log Reader Software
Try LogPI - it's advertised on the SqlCentral web site all over the place, does this and more.
2004-06-02
RE: Installing SQL Server 7.0
I do not have a SQL-server installation on the server at all and trying to install one fails and then cleans up after itself and doesn't leave anything to delete, clean up, or uninstall etc!
2004-05-13
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
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