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.

Combined Powershell script for managing both Azure AD and Exchange Online

_________________BEGIN Connect.ps1________________________ $LiveCred = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic –AllowRedirection Import-PSSession $Session -AllowClobber connect-msolservice -credential $LiveCred #Remove-PSSession $Session __________________END Connect.ps1_________________________   The above script connects to two services: (1) Azure Active Directory remote powershell and (2) Exchange Online remote powershell. This is useful because the former is required…

Trial Azure AD Premium

Now you can trial 100 Azure AD Premium Licenses for 90 days.  Not sure what will happen after the 90 days but go get them! Login to your Azure Subscription, go to Active Directory and select your domain:   Select licenses and you can activate the trial!

#Office365 Roadmap Website Launched

Microsoft today launched a new website covering the roadmap for Office 365, http://office.microsoft.com/en-us/products/office-365-roadmap-FX104343353.aspx. This is great, now you can see what new features and functionality has been launched, is rolling out and in development. One of the cool new features that is in the Rolling Out section is the ability to opt in to being…

SQL Server: Bulk Update

I maintain a rollup table of project metrics, which get updated on a frequent basis. This table contains a lot of calculations and data from multiple sources, which first populates a TABLE variable. Once all of the calculations and aggregate data sources have been completed, I want to update my project metrics table with the…

SQL Query: Joining a SQL Table with a Table-valued Function

Did you know that you can use a SQL Query to join together a SQL Table with a Table-valued Function into a single result set? Here’s how: I have created a Function that contains several calculations and returns some standard Project Metrics: CREATE FUNCTION [dbo].[fnGetProjectMetrics] (    @ProjectId int ) RETURNS @results table (     [ActivityStartDate] datetime     , [ActivityEndDate] datetime     ,…