Dear SMT users and fans,
We just finished second major change of SMT in the year 2020.
As the previous one was more about backend changes and making the update process more flexible the current one was mostly about frontend and meant that the whole architecture and utilised technologies were changed.
In the meantime, we have also delivered more than 15 minor upgrades including reporting and collection part of SMT, which were done completely remotely, and we did not need to run any manual scripts in client’s environment.
Back to our current release, as the change is significant we jumped in the versioning to SMT 1.0 and it is a significant step on our way to make SMT self-manageable and give our future customers an option to install it and used it entirely on their own.
Frontend of SMT 1.0 is now REACT app using own API to handle communication between the app and database. New SMT app is loaded into user’s browser and runs there responding to users’ requests. One of the benefits of re-building the frontend – backend relationship from scratch allowed us to enhance the processes of loading data using caches and overall gain performance for the best user’s experience.
Additionally, using the modern frontend technology will provide us with options how to interact with user’s and this is already in our development pipeline among ideas for new reports.
Changes were also made around the user authentication, which has been centralised and users and their requests are verified against a point accessible via secured internet connection.
Last but not least, with all these significant changes all the reports have been standardized and are now built using the same or very similar approach depending on the particular type of the report and the optimal way how to provide the figures the SMT users are looking for.
Your SMT team.
Michal Tinthofer is the face of the Woodler company which (as he does), is fully committed to complete support of Microsoft SQL Server products to its customers. He often acts as a database architect, performance tuner, administrator, SQL Server monitoring developer (Woodler SMT) and, last but not least, a trainer of people who are developing their skills in this area. His current "Quest" is to help admins and developers to quickly and accurately identify issues related to their work and SQL Server runtime.
There are usually multiple ways how to provide a view of a set of data as a report, involving decisions like; keep it easy to read, interpret the relationships between multiple figures in the correct way and to show user as much information as possible at
Read moreI would like to say thank you for attending my presentations on this year ShowIT.
Read moreIn the world of SQL Server, TEMPDB is often called the "public dumping ground." We expect it to be busy, but we also expect it to clean up after itself.
Read more
