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…
If you are like me you were excited to see that Technical Previews are now available for Windows 10, Windows Server and System Center (details and download links are available at http://blogs.technet.com/b/systemcenter/archive/2014/10/02/announcing-availability-of-the-system-center-technical-preview.aspx). From what I’m seeing this will be an exciting update and I expect lots of good stuff will be shown at TechEd in…
As a quick summary for what has been added recently related to ReSearch This (community resolutions to Operations Manager alerts), there were several new KB articles added and the ReSearch This dashboard edition was also released recently. Details are below. New ReSearch This KB articles: SQL DB Engine 2012 Page Life Expectancy is too…
In the upcoming whitepaper entitled "Using Veeam solutions to augment System Center and Hyper-V" Pete Zerger and I discuss how the Veeam management pack can be used to enhance the functionality available in System Center. Specifically we focused on how the new Hyper-V functionality could be leveraged for additional benefits in System Center. While integration…
One of the approaches which has been available to provide dashboard integration for Operations Manager utilizes Visio and SharePoint Enterprise edition. I have worked with this approach and blogged on it several times in the past including: Creating a Visio integrated diagram from a distributed application: https://www.catapultsystems.com/cfuller/archive/2011/08/16/opsmgr-dashboard-integration-creating-a-visio-integrated-diagram-from-a-distributed-application.aspx Customizing linked items and how they represent their…
In Cumulative Update 3 for System Center Configuration Manager 2012 R2, Microsoft introduced Management Point Affinity and Justin Chalfant had a nice write-up on the new feature. One thing that was left undocumented was an acceptable way to set MP Affinity; the blog only mentions the use of Group Policy, Compliance Scripts, etc.I worked out…
Thank you to all of the attendees at the recent Cloud Management with System Center presentation in Dallas! As a follow-up from this presentation, the following are some relevant links to the topics that we discussed: Savision has made a copy of the slides available here for your review. For more details on Office 365…
During a recent presentation on Cloud Management with System Center several good questions were asked but one really caught my attention. The client wanted to know why they couldn’t see performance information for their VM’s which are running in Azure. This blog post will dig into the underlying area of confusion as to what is…
A colleague of mine recently was working on a Windows image with a specific setting for Microsoft Office 2010. However, the registry key simply would not “sick” and would be stripped out at some point before the user could log on and launch the application. There are a few options for making changes to all…
Life is good, the presentation is going well. The audience is engaged in the discussion. I mention an interesting technical point and continue on. I’m part way into the next slide and twitter pops up with a tweet about the interesting technical point that I had just discussed. Wait a second. I know that I…
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.