SQL Query: Joining a SQL Table with a Table-valued Function
Did you know that you can use a SQL Query to join together a SQL Table with a Table-valued Function…
[Podcast] Getting Down to Business: Small Business and the Cloud
Recently I had the pleasure of being invited on "Getting Down to Business" with David Weatherford (http://gdtb.biz/). This is a…
Offline Root CA’s require periodic maintenance
In most environments where an offline Root CA is used, it must come back online once every 7 months…
Minimum Exchange Hybrid Server Requirements for Managing On-Premises Users
Recently I was trying to locate guidance for the minimum requirements that an Exchange Hybrid Server would need if…
How to prevent Ransomware from infecting your Enterprise Applications
Everyone has heard of Spyware and Malware. Ransomware is becoming an all too familiar term but I feel many IT…
Tool for Testing SCSM Subscriptions
I recently discover a great tool for testing subscriptions and workflow notification in System Center Service Manager. The tool is…
Creating a first simple runbook in SMA to connect to Operations Manager
If you want to learn technologies which are strategic to the Microsoft direction I recommend three: PowerShell, SMA and WAP.…
An IT Geeks experiences with Office on an iPad
I’ve been an iPad user for a while now and also working with my Surface 2 RT (see https://www.catapultsystems.com/cfuller/archive/2014/04/09/using-the-surface-2-rt-like-a-pro-fessional-1.aspx for…
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…
Fixing the JavaScript error when registering the Advisor Service
In a recent environment where we were configuring Advisor within Operations Manager we received errors that the "Microsoft account requires…