For those of us who have had the unfortunate experience of trying to access CRM data using SOAP queries, it is a luxury to be able to query CRM entities using LINQ. It is pretty easy to setup your .NET project to use CRM and LINQ. Simply install the CRM SDK. This link is to…
Project Description PowerShell script that updates AD objects based on a CSV schema. First, a big thank you to Cary Landers and Nuno Mota. This effort was adapted from: https://companydirectory.codeplex.com/ by Cary Landers https://gallery.technet.microsoft.com/scriptcenter/f7b246a4-95a2-4408-b1a1-73b53003883c by Nuno Mota This script does the following: Iterates through records in a CSV For each record, looks up the AD object’s distinguishedName based…
I recently had a need to take the normal people search results in SharePoint Online and make them look better. In particular, use all that white space to the right of the default search results listing. Forgive the photos below. I wanted to keep the large resolution to demonstrate the functionality here. Default People Search…
Adding a Geolocation column to a list in SharePoint 2013 is a bit of a pain because there’s no built-in user interface to do so. Instead, you have to add it with code. Check out Tobias Zimmergren’s article to get acquainted with the Geolocation column in SharePoint 2013: http://zimmergren.net/technical/sp-2013-getting-started-with-the-new-geolocation-field-in-sharepoint-2013. Now, to the point of my…
Using the DATEDIFF function allows you to easily calculate week days in SQL, because it both removes the time from a date and converts the date into a number for easy mathematical calculations. Calculating Most Recent Monday DECLARE @MostRecentMonday DATETIME = DATEDIFF(day, 0, GETDATE() – DATEDIFF(day, 0, GETDATE()) %7) PRINT @MostRecentMonday Calculating Previous…
I have a Project table that contains a couple of fields used for reporting and metrics called FirstActivity, LastActivity, and TotalHours. I created the following SQL query to update those fields based on some aggregated results from the ProjectHours table: UPDATE [dbo].[Project] SET FirstActivity = MIN(ProjectHours.[EntryDate]) , FirstActivity = MAX(ProjectHours.[EntryDate]) , TotalHours = SUM(ProjectHours.[TotalHours]) FROM…
I have a Project table that contains a couple of fields used for reporting and metrics called FirstActivity, LastActivity, and TotalHours. I created the following SQL query to update those fields based on some aggregated results from the ProjectHours table: UPDATE [dbo].[Project] SET FirstActivity = MIN(ProjectHours.[EntryDate]) , FirstActivity = MAX(ProjectHours.[EntryDate]) , TotalHours = SUM(ProjectHours.[TotalHours]) FROM [dbo].[Project] INNER JOIN [ProjectHours] ON [Project].[ProjectId]…
Bookmark the link below so that you can tell what Microsoft server software is supported on Azure virtual machines. It’s a living webpage. http://support.microsoft.com/kb/2721672
UPDATE 10/29/2014 It took me a while but I finally figured out why I was having problems with OneDrive. Scroll to the 10/05/2014 section for a description of what the problem was. It turns out I had a folder name using an unusual character. This was not a special character that OneDrive can’t sync as in \…
We had another great meeting of the Office 365 International User Group yesterday. While it was a bit shorter than most of the meetings, that being my fault as I was a bit busy and unable to line up a presenter, it did have a bunch of cross talk and discussion. I started out the…
Catapult uses cookies to enhance your experience, to display customized content in accordance with your browser settings, and to help us better understand how you use our website. By continuing to browse or closing this banner, you indicate your agreement. To learn more about the cookies we use and to set your own preferences, see our Privacy and Cookie Policy.