Blog

SharePoint on MGDC FAQ: How can I use Delta State Datasets?

IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Overview When gathering SharePoint data through Microsoft Graph Data Connect in a large tenant, you might be pulling many thousands or even … Continue reading SharePoint on MGDC FAQ: How can I use Delta State Datasets? →

SharePoint on MGDC FAQ: Which date should I query?

IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Filter by SnapShotDate When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you must choose the date to query. This is … Continue reading SharePoint on MGDC FAQ: Which date should I query? →

Four Options for SharePoint Site Analytics

IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. Overview Here's a scenario: imagine that you are a SharePoint Online administrator and you have been asked to provide analytics about how the … Continue reading Four Options for SharePoint Site Analytics →

Loading CSV/text files with more than a million rows into Excel

1. The Problem If you usually load a very large CSV (comma-separated values) file or text file into Excel, you might run into the dreaded "File not loaded completely" message: As the message explains, the file you are trying to load is too large for Excel to handle. For me, it typically happens with large … Continue reading Loading CSV/text files with more than a million rows into Excel →

Broken image link? Search the archive…

I blogged for 15 years using the old TechNet blogs sites, under the https://blogs.technet.com/josebda URL. As you can tell if you click on that old link, it's no longer there. That blog service was closed, but there is an archive at https://learn.microsoft.com/en-us/archive/blogs/josebda/ including all the hundreds of posts from 2004 to 2018. I also backed … Continue reading Broken image link? Search the archive… →

Scary SQL Server stuff: tombstones, phantoms, ghosts and zombies

This post mixes the spirit of Halloween and the passion for SQL Server 🙂   Have you noticed how SQL Server has a number of things that seem right out of a horror movie? As a test of your SQL Server expertise and for a fun Halloween trivia game, try to describe the items in … Continue reading Scary SQL Server stuff: tombstones, phantoms, ghosts and zombies →

Step-by-step: Gathering a detailed dataset on your SharePoint Sites

A step-by-step guide to getting SharePoint Sites information using the Microsoft Graph Data Connect, Azure Synapse and Power BI IMPORTANT: This is an older version of this blog, using the consent process via Privileged Access Management (PAM). That process was replaced on 2023/08/18. If your tenant was enrolled on or after this date, use the updated … Continue reading Step-by-step: Gathering a detailed dataset on your SharePoint Sites →

SharePoint and OneDrive + Microsoft Graph Data Connect + Ignite 2022

The Ignite 2022 conference this week brought a number of presentations and announcements from all over Microsoft. For me in the OneDrive and SharePoint team, there were plenty of news. In my opinion, the biggest story is around Content AI and the announcement of Microsoft Syntex. If you haven't seen it yet, I would highly … Continue reading SharePoint and OneDrive + Microsoft Graph Data Connect + Ignite 2022 →

PowerShell cmdlets and parameters for the SharePoint Online module

This is a simple list of all the cmdlets in the Microsoft.Online.SharePoint.PowerShell module. This is a useful module for an Administrator using SharePoint Online or OneDrive for Business. Here are a few notes: If you don't have the module, you can install it using the following cmdlet: Install-Module -Name Microsoft.Online.SharePoint.PowerShell Before you can use most … Continue reading PowerShell cmdlets and parameters for the SharePoint Online module →