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.

Transaction SQL Date Calculations – First Day of Month and Last Day of Month

I find that I am consistently trying to determine the first and last day of the current month using Transact SQL. The following is a cheat sheet for calculating easily those dates: DECLARE @today DATETIME, @first_of_month DATETIME, @last_of_month DATETIME   SET @today = GETDATE() SET @first_of_month = DATEADD(dd,-(DATEPART(dd, @today)-1),@today) SET @last_of_month = DATEADD(dd, –1, DATEADD(mm,…

Config Mgr 2012 Mof modifications (SCCM 2012 MOF importing) (WORK IN PROGRESS)

It seems no matter how good SCCM becomes there will always be a need to modify the existing hardware inventory gathering.   I am not sure if I am NOT using the Reg2mof 2012 version correctly but so far my experience with the 2007 tool has been utter failure.   http://myitforum.com/cs2/blogs/skissinger/archive/2010/12/01/march-cochrane-s-regkeytomof-v2-5.aspx   I have used…

Installing Exchange 2010 SP3 on an Edge Server

I’ve run into multiple issues with this task, so I thought I’d write a post on how to successfully update your Exchange 2010 Edge server to Service Pack 3.  In my scenario, I’m running a single server with the following services: Exchange 2010 SP1 Edge server Forefront Threat Management Gateway (TMG) 2010 Forefront Protection for…

Dual Authentication for Office 365

Microsoft is rolling out two factor authentication for Windows Azure Active Directory (WAAD) called Windows Azure Active Authentication, http://www.windowsazure.com/en-us/services/identity/. I wanted to give this a test drive, here is my experience with the new Active Authentication.   Setup Microsoft published a TechNet Article about configuring WAAD for Active Authentication, http://technet.microsoft.com/library/dn249466.aspx From the Article: Creating an…