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.
Here is a nice pattern for biding data to you HTML that is good to follow if you want to keep your HTML clean and simple. So you have a table that you are populating with values that you are getting form the server. Your table may look something like this: And your code may…
First, Why Should We Care About Employee Engagement? According to Rachele Williams, SPHR and Advisory Services lead for APQC, one of the world’s leading business benchmarking, best practices, and knowledge management research consultancies, “Employee engagement is to HR what customer loyalty is to marketing and sales. It is that often elusive frame of mind that…
You may have seen the viral meme “There is no cloud, it’s just someone else’s computer” posted on social media or forwarded in an email (or even on a mug). It’s only funny because it is true—but that’s kind of the whole point. It is someone else’s computer. But it isn’t really the computer that…
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);…
I am creating a Flot Line Chart in .Net based on the following Entity Framework result set. I want to get a distinct list of the report categories in alphabetical order to use as a control group. Entity Framework provides an easy Distinct() method to retrieve distinct values from a data set, but it wasn’t completely obvious…
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.…
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…
I was looking for a more accurate way to locate a top level item in any hierarchy without having to do a lot of extraneous looping. The solution I found was is efficient and easy! For this example, we will determine the top level manager for any employee, regardless of the level of their managerial…
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…
A Quick Tip Sometimes it may feel like optimizing your T-SQL queries can be a guessing game, but SQL Server provides some very simple tools you can use to analyze your queries. Simply write your T-SQL query in SQL Server Management Studio and instead of hitting execute, hit CTRL-L. This will open a new tab…