SQL or Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).

learn more… | top users | synonyms

1
vote
2answers
743 views

IBM DB2 database connect to Sharepoint

We have an IBM DB2 database which stores our documents as BLOBS in binary format. I've read about Remote Blob Storage(RBS) and FILESTREAM but I'm still puzzled if its possible to hook up our IBM DB2 ...
4
votes
4answers
5k views

CAML vs LINQ vs SQL

So LINQ is a front end to CAML so of course CAML is faster, and CAML is a front end to SQL so of course SQL is faster. However what would be a good test to see where and when to use each of these on ...
3
votes
0answers
3k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
0
votes
2answers
299 views

How to deploy an EventReceiver which writes to SQL Server correctly

following scenario. I have a client machine on which I have all the permissions for: SQL-databases (db_owner) Full access to a Sharepoint Application. Created a Sql-account (db_owner) and included ...
1
vote
3answers
66 views

Sharepoint 2010 and 2013 on same SQL Server

We have a Sharepoint 2013 installed with SQL database Cluster and our old Sharepoint 2010 databases should also be moved to the new SQL database Cluster but not migrated to Sharepoint 2013. I have ...
1
vote
1answer
210 views

Filling an SP column with SQL data

As part of an internship assignment, I'm working with SharePoint 2013. I'm completely new to SharePoint in general. Part of this assignment is a labeling system. The idea is that users can add labels ...
1
vote
4answers
3k views

Find Database Column Names for List Columns

I am attempting to create a Database View derived from Sharepoint List Data in Sharepoint 2010. Currently to do this I have simply added a new List Item with Unique values, and manually mapped the ...
0
votes
2answers
69 views

How to describe all content from the list in SQL

I must do Data Warehouse from my lists in Sharepoint. I need to connect to the Sharepoint and get all elements from the list and Show them in MS SQL Serwer 2008 R2. I need to show them in another ...
0
votes
2answers
2k views

Recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010

Are there any recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010 please? Is there any specific SQL feature that should be enabled please?