SQL Server: Using ROWNUMBER to Apply Ranking

I have a set of records for employee utilization, and I wanted a quick way to rank them from highest utilization to lowest utilization. It turns out that the ROWNUMBER() function did exactly what I needed. Here is an example of my data: ConsultantNameUtilizationPercentConsultant A100.5%Consultant B87.4%Consultant C95.0%Consultant D101.2%The following query can be used to return…

Should I deploy UR2 to OpsMgr 2012 or wait on SP1? (#SCOM, #SYSCTR)

I had a client who is running OpsMgr 2012 and hasn’t applied an update rollup yet and they were asking if it makes sense to apply UR2 or to wait until SP1 is available. Relevant links: UR2 Download: http://www.microsoft.com/en-us/download/details.aspx?id=30421 KB link: http://support.microsoft.com/kb/2706783 System Center 2012 SP1 – beta was just released on 9/10/12: http://www.microsoft.com/en-us/download/details.aspx?id=34607 The…

Excel Tips & Trivia: Remove Duplicates

This week’s trivia… Ever wonder why it’s called a spreadsheet? According to Wikipedia, the word "spreadsheet" referred to the format of paper-based accounting ledgers, where two long sheets opened, or "spread" across the center binding, much like a newspaper, with categories in columns along the top and invoices on one side and payment amounts on…

OpsMgr Agentless Monitoring, Service Manager 2012 and backwards compatibility MP (#SCOM, #SCSM, #SYSCTR)

During some recent testing of Operations Manager 2012, we needed to add the backwards compatibility management pack as it was required for several of the management packs including:   Microsoft.CommerceServer.2007 (Converted) Microsoft.Windows.Server.GroupPolicy.2003 (Converted) Microsoft.Windows.Server.InternetNamingService (Converted) Microsoft.Windows.Server.RRAS (Converted)   We had already also been monitoring Service Manager 2012 which requires agentless monitoring as discussed at: http://social.technet.microsoft.com/Forums/en-US/operationsmanagerdeployment/thread/48396343-70b9-42c6-9d84-79955365ed93/…