Tim Mitchell

October 21, 2024

T-SQL Tuesday #179 Roundup: The Data Detective Toolkit

Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked, “What’s in your data detective toolkit?” We got some great responses which I’ll recap here, and I’ll share a few thoughts of my own at the end. First up, Rob Farley shared his approach, which focuses on the bigger picture of the business use of the…

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

Reflections on My First-Ever Presentation, Fifteen Years Later

My Office Setup

Returning to PASS Summit

Creating a Generic SSRS Report

What Stephen King Taught Me About Data Storytelling

Let’s Talk About Your Development Environment

Moving On From PASS. What’s Next?

January 8, 2021

Connecting to SharePoint Lists with SSIS

SharePoint lists are popular and simple tools for storing modestly-sized discrete sets of data. SQL Server Integration Services (SSIS) includes a source component to allow reading data from SharePoint lists. In this post, I’ll demonstrate how to use SSIS to read from a SharePoint list using the OData source. SharePoint lists A SharePoint list is a simple collection of related…

1 2 3 … 34 »