I'm using Office 2010 and Office 2013 to aggregate data from a SQL data source. In the past I have had no problems aliasing column names in MS Query but found today that it no longer seemed to work. It's not a big problem for regular columns, but … [Continue reading] about Alias names in Microsoft Query no longer work in recent versions of Office
SQL Server 2012 Reporting Services – Change format of Date Parameters
Hit a snag today trying to set the format on date parameters that drive SSRS 2012 reports - at first I thought it would be simple to fix but after searching around for solutions, didn't come up with much. The specific problem I was/am having is that … [Continue reading] about SQL Server 2012 Reporting Services – Change format of Date Parameters
Using an Non Dell SSD as a CacheCade on a Dell PowerEdge
I've been itching to try out the LSI CacheCade technology since reading this review: http://www.storagereview.com/lsi_megaraid_cachecade_pro_20_review The LSI CacheCade Technology is now included with Dell PowerEdge Servers that have the PERC H700 … [Continue reading] about Using an Non Dell SSD as a CacheCade on a Dell PowerEdge
Outlook: Your message did not reach some or all of the intended recipients.
Had a problem with a customer today sending an email and instantly getting a response that the message was undeliverable, with the message: Your message did not reach some or all of the intended recipients. Subject: FW: Offer Sent: 20/09/2011 … [Continue reading] about Outlook: Your message did not reach some or all of the intended recipients.
Email alerts from Dell Open Manage Server Administrator (OMSA)
Dell OpenManage Server Administrator can execute an application when a fault is detected in the hardware, unfortunately there is no built in e-mail support, so this PowerShell can send the email for you without the need for any additional … [Continue reading] about Email alerts from Dell Open Manage Server Administrator (OMSA)