def METHOD_NAME(self, cursor):
    self.log.debug("collecting sql server instance settings")
    query = self._get_settings_query_cached(cursor)
    self.log.debug("Running query [%s] %s", query)
    cursor.execute(query)
    columns = [i[0] for i in cursor.description]
    # construct row dicts manually as there's no DictCursor for pyodbc
    rows = [dict(zip(columns, row)) for row in cursor.fetchall()]
    self.log.debug("loaded sql server settings len(rows)=%s", len(rows))
    return rows