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.

SQL Server: Removing Time from the Date Field for Comparisons

Consider this SQL SELECT statement: SELECT     [TS].* FROM     [dbo].[TimeSheet] [TS] WHERE     ([TS].[EntryDate] = @ActivityStartDate) Seems pretty straight forward, but you run into some issues when comparing dates with timestamps. If @ActivityStartDate is passed into the query as 6/1/2014 12:00 AM, because a specific time was never specified, but the timesheet entries contain timestamps, then you run into some…

Weekly Exchange PowerShell Tip: Bulk Create O365 Mail Contacts

If you want to bulk create mail contacts in O365, the following powershell cmdlet will pull in a list of users from a CSV and create mail contacts from it:   Import-Csv .\MailContacts.csv|%{New-MailContact -Name $_.Name -DisplayName $_.Name -ExternalEmailAddress $_.ExternalEmailAddress -FirstName $_.FirstName -LastName $_.LastName}   Example of the CSV: ExternalEmailAddress,Name,FirstName,LastName Bob.Smith@Office365.com,Bob Smith,Bob,Smith

Bootstrap Version 3 Icon Glyph Font Reference

  Bootstrap v3.0.3 and higher has changed its icon glyph from an image to a font, which has several benefits, including the fact that they appear smoother, and can be adjusted easily in size and color the way you would adjust a font. You can download Bootstrap here: http://getbootstrap.com/getting-started/#download For example, I can display KPIs…

Streamline Administration in #Office365

As you might have read, Office 365 Administration Streamlined and Simplified. I have observed several of these simplified changes over the past few days, but one caught my eye today, while doing a demo for a client. The below changes are related to modifying a User in the Office 365 Admin Center. Selecting a User…