Automating “Click Continue”

Infrastructure

A friend of mine mentioned that he unexpectantly spent a few hours with glazed over eyes clicking “C” on the keyboard to press “Continue” on a dialog box that was being generated a few hundred times.  He quickly acknowledged that there was definitely a better way to use his time and accomplish the task at…

SQL – An aggregate may not appear in the set list of an UPDATE statement

Applications

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]…

Autoscaling, Azure, WAP and System Center

Infrastructure

The term autoscaling can have several meanings including scaling out (adding additional instance), scaling up (adding more resources to an existing instance) and scaling down (removing resources from an existing instance). In Azure this is explained at http://msdn.microsoft.com/en-us/library/hh680945(v=PandP.50).aspx. In this three part blog post series, my goal is to explain what the current state for…

nintex-forms

RESOLVED – Microsoft OneDrive and Search Indexer 30% CPU ALL THE TIME and OneDrive stuck saying “Checking for changes” in the systray!

Infrastructure

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 \…