Category: SQL

SharePoint, SQL

SharePoint and SSRS: The given key was not present in the dictionary

Consider this scenario. You have SharePoint with SQL Reporting Services (SSRS) running in SharePoint Integrated mode. You want to use a SharePoint list as a data source for a report. In the SSRS Data Connection you enter the URL and credentials for the SharePoint site but when you test the connection the following error appears: The given key was not present in the dictionary After … Continue reading SharePoint and SSRS: The given key was not present in the dictionary

SteveLeave a comment
SharePoint, SQL

Changing SSRS database names

I’ve been working on a project where multiple servers including two SharePoint farms running SQL Server Reporting Services (SSRS) in SharePoint Integrated mode need to be moved to a single SQL Server. Each farm has its own SQL Server to host the SharePoint and SSRS databases. To make the job a little more challenging the databases in each farm have the same name. To complete … Continue reading Changing SSRS database names

SteveLeave a comment
SharePoint, SQL, Uncategorized

Data Channel : Managing SharePoint Databases

I was recently interviewed for the Data Channel about managing SharePoint databases on SQL Server. In the interview with Nagaraj Venkatesan (SQL Server MVP from Singapore) I cover many of the common questions DBA’s have about SharePoint including: Things that make SharePoint databases unique Capacity Planning Remote Blob Storage (RBS) Backup / Recovery SSRS Integration Patching You can download a copy of my presentation from #SQLsat614 … Continue reading Data Channel : Managing SharePoint Databases

SteveLeave a comment
SharePoint, SQL

SharePoint for DBA’s

Yesterday I presented at #SQLSat614 in Christchurch. SQL Saturday was a full day event with 20 experts talking on topics related to the Microsoft Data Platform. Since this wasn’t my normal audience, I thought I’d ask the twitter-sphere what questions DBA’s have when it comes to managing SharePoint and the responses helped formulate my talk. I attended another session where the speaker raised culture as … Continue reading SharePoint for DBA’s

Steve2 Comments
Office 365, SharePoint, SQL, SSIS

SSIS, InfoPath and SharePoint Lists

Have you ever needed  a low cost solution for capturing data in a form on mobile device and then pull the data back into an in house SQL database. In this solution data is entered into an InfoPath form on a tablet (Windows, iOS or Android), submitted to a SharePoint Online form library and then pulled into a SQLserver database using SQL Integration Services (SSIS). This solution will also … Continue reading SSIS, InfoPath and SharePoint Lists

Steve5 Comments