MDX formatting and the changing toolset

Reporting Services includes a very useful visual MDX query tool, which I often start with when writing reports. It can add parameters and create calculated members for you which are both handy features. Very quickly though you realise that it can't do more complicated MDX queries for you without you…

Querying Active Directory (LDAP) from SQL Server

LDAP LDAP, the "lightweight directory access protocol" is a strange beast. It's technically a protocol for accessing network directories (directories as in phone directories, not folders), but it sort of qualifies as a no-SQL database because its distributed addressing mechanism doesn't consist of relations like a RDBMS, it has entries…