Catapult, a Quisitive company, is a Microsoft-focused solutions and services firm that specializes in imagining, building and sustaining digital transformation and cloud-based solutions that people love to use. Catapult has consistently been recognized as a leading Microsoft Partner with 10 Advanced Specializations and 17 Microsoft competencies. Recent accolades include 2020 MSUS Partner Award Winner Azure – DevOps, Top Microsoft 365 Security Partner for FY20, and being named a finalist of the Data Analytics 2020 Microsoft Partner of the Year Award. Catapult has offices nationwide.

Entity Framework: Get Distinct Result Set on Multiple Columns with Order By

I am creating a report based off of the following result set: I wanted to get a unique set of weeks from the control group, but I also wanted to retrieve whether the week is an actual vs. a forecast. Turns out it’s pretty easy: public List<WeeklyUtilizationHistoryAndForecast> ReportSummary = businessService.GetWeeklyUtilizationHistoryAndForecast(isCache, ParamUserId, ParamStartWeek, ParamEndWeek, ParamBusinessUnitId, ParamIncludeTimeOff);…

Starting an Office 365 User Group

When I moved away from Chicago, one of the things I had to leave was the Chicago Office 365 User Group. While deeply saddened about this departure, I was excited to start my new opportunity in Phoenix with Catapult Systems. I took on the role of SharePoint Local Practice Lead (LPL) for Catapult’s Phoenix office.…

Using Azure Automation to Generate SharePoint Online Site Collection Storage Reports

We’ll keep this one short and sweet. Jeff Jones (@spjeff) wrote a nice PowerShell script to generate an HTML-based report detailing SharePoint Online site collection storage quotas and usage. You can view his original script and his post on it here: http://www.spjeff.com/2015/05/18/office-365-monitor-site-collection-storage-ps1-daily-email/. This is great for on-prem scenarios, but I’ve been doing a lot in…

SQL Server 2012 Availability Groups in Azure, Step by Step

Coming soon – a step by step guide to setting up a SQL Server Always-On Availability Group lab environment in Azure Virtual Machines.   Edit: Turns out Microsoft has already documented this thusly. High Availability and Disaster Recovery for SQL Server in Azure Virtual Machines (Updated: June 4, 2015)https://msdn.microsoft.com/library/azure/jj870962.aspx   How to Configure Windows Failover…