looking for the professional communities opinion.
Good evening all,
given the glorious move on advents part to provide off the shelf support for SQL server as part of thier service desk offering.
however.
having studied the backend structure of the SQL version database i am somewhat surprised to learn the following.
The database architecture is that off merely flat tables (no procedures, triggers, views etc). with this in mind the only possible method that an application (in this case servicedesk plus) has of accessing the data is by use of "on the fly" sql statements. e.g "SELECT col from table where blah blah blah". common to popular misconception this method of data access does nothing to leverage the backend processing power of an industry standard RDBMS such as SQL.
Is this something that Advent are proud to stand by or is their offerings in the pipeline for a product built according to industry best practices.
I throw the topic open to debate in the following manner with a prayer that the developers will take note of the following.
"Any company wishing to implement a service desk utilising SQL server as a backend database will do so either because they appreciate the power of such a data product OR because they already have it in use for other purposes" with both scenarios in mind the product does not take advantage of the platform from either angle, burdeningthe server with adhoc queries in the colocated angle and under utilising its power in the standalone install.
my only other point with regards to the general methods employed by the company itself is that if you advertise a date for release, please make it a realisticly achievable target date. If this date is "next week" please appreciate the confidence in the product and in turn the company will deminish quickly.
as a close, i feel that the product shows amazing potential in its own right when compared to its peer group (both price and feature based) and that managed correctly has the scope to become THE service desk of choice. Further i feel that by listening to the responses offered within this forum by the people on the ground using implementing and assesing the product(s), the vendor themselves have a captive audience of professionals to braindump, poll and feedback to. This in itself is a mechanism that could well be enviable to many competitors.
I hope that the powers that be appreciate that this message is of constructive nature and ask that service desk advocates and critics comments as they feel fit.
I am available happy to discuss this topic further if anyone wishes
kind regards,
Daniel.
given the glorious move on advents part to provide off the shelf support for SQL server as part of thier service desk offering.
however.
having studied the backend structure of the SQL version database i am somewhat surprised to learn the following.
The database architecture is that off merely flat tables (no procedures, triggers, views etc). with this in mind the only possible method that an application (in this case servicedesk plus) has of accessing the data is by use of "on the fly" sql statements. e.g "SELECT col from table where blah blah blah". common to popular misconception this method of data access does nothing to leverage the backend processing power of an industry standard RDBMS such as SQL.
Is this something that Advent are proud to stand by or is their offerings in the pipeline for a product built according to industry best practices.
I throw the topic open to debate in the following manner with a prayer that the developers will take note of the following.
"Any company wishing to implement a service desk utilising SQL server as a backend database will do so either because they appreciate the power of such a data product OR because they already have it in use for other purposes" with both scenarios in mind the product does not take advantage of the platform from either angle, burdeningthe server with adhoc queries in the colocated angle and under utilising its power in the standalone install.
my only other point with regards to the general methods employed by the company itself is that if you advertise a date for release, please make it a realisticly achievable target date. If this date is "next week" please appreciate the confidence in the product and in turn the company will deminish quickly.
as a close, i feel that the product shows amazing potential in its own right when compared to its peer group (both price and feature based) and that managed correctly has the scope to become THE service desk of choice. Further i feel that by listening to the responses offered within this forum by the people on the ground using implementing and assesing the product(s), the vendor themselves have a captive audience of professionals to braindump, poll and feedback to. This in itself is a mechanism that could well be enviable to many competitors.
I hope that the powers that be appreciate that this message is of constructive nature and ask that service desk advocates and critics comments as they feel fit.
I am available happy to discuss this topic further if anyone wishes
kind regards,
Daniel.