Reporting

PowerBI using a gateway is capable of refreshing data on a set interval from a spreadsheet. However, exporting this data is currently a manual process for the end user. Providing the ability to allow an automatic export post sync, and provide a de...

Older versions of SQL do not support the legacy cardinality hint methodology. Microsoft has a reccomendation where any report that times out should use the hint technology, or set the SQL instance to an older compatability mode. All of the queries...