Perform Data Filtering in Oracle Link to SQL Server
Learn how to perform data filtering in Oracle Linux using a database link to SQL Server
2020-04-13
1,808 reads
Linked Servers
2017-02-16
1,006 reads
Changing Linked Server Properties
A quick guide on changing the linked server properties and settings.
2018-09-03 (first published: 2016-07-07)
11,120 reads
2011-11-02 (first published: 2011-10-21)
1,580 reads
Setting up linked servers with an out-of-process OLEDB provider
There is an inprocess setting for linked servers. Have you ever used it? Gianluca Sartori gives a look at what the implications are for this.
2011-06-09
11,128 reads
Blogs
Creating a New Sequence–#SQLNewBlogger
By Steve Jones
I wrote about sequences in an editorial recently and decided to start using them....
An All Star Lineup for EightKB
By Steve Jones
An online conference is coming on June 17, 2020 that is full of high...
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...
Forums
Filestream or Filetable or None...what to be used?
I've been assigned with a project that includes converting the columns in the existing...
How to force MS SQL to select a partition instead of making a full table scan
Hi all, I am currently designing a datamart layer in MS SQL 2016 Enterprise....
Daily 3 Coping
Today’s tip is find three good reasons to be hopeful for the future. http://voiceofthedba.com/2020/06/03/daily-coping-3-jun-2020/
Ask SSC