Luke Hayler - SQL Server developer

Another potentially easy one to fix. When you know how…………..
I received the error “Log on failure: unknown user name or bad password. (Exception from HRESULT: 0×8007052E)” recently when trying to ‘run’ a report in Report Builder. From what I can gather, it has everything to do with the configuration settings for SQL Server Reporting [...]

Haven’t I done this before?

As a Reporting Services Developer you may have found yourself completing the same tasks over and over for each new report that you create. To alleviate this somewhat, you may have just done a quick ‘Copy & Paste’ of an existing report, renamed it and then modified all the elements within [...]

I have read quite a few blog posts over the last few weeks on documentation. Some of the posts are specific to SQL Server, some are more general in their approach choosing to explain why documentation is good practice and indeed necessary, why it is not just important to have documentation, but to have good [...]

BOL’s description of the JOIN() Function: “Returns a string created by joining a number of substrings contained in an array.”. The syntax of the function is as follows:
=JOIN(List [,delimiter])

List – Required. One-dimensional array containing substrings to be joined
Delimiter – Optional. String character used to separate substrings. If omitted, a space “ “ will be [...]

Since I am always up for anything that is free, and particularly when ‘Free’ includes learning, I signed up for a bunch of sessions from the 24 Hours of PASS, due to be held on September 2nd 2009. This event is a series of 24 hour-long SQL Server based sessions by a number of Industry [...]