Malcolm Smith
mhSQL
Hong Kong
Actions
Malcolm is a Data Architect in the online gaming world
Trying to keep up with the ever-changing cloud technologies, using past experience to select best solution
Having gone through the pains of providing support, working with SQL 2000+, SSIS, SSRS and Power BI, as well as performance tuning
He's always happy to acknowledge there is no single correct option and always happy to share knowledge and explore new options
Area of Expertise
Topics
Azure Cost Management, analysis outside the Azure Portal
While Azure Cost Management provides analysis in the Azure Portal and via a Power BI Premium Dashboard, what other options are there.
This session will focus on a solution converting daily extracts from Azure Cost Management with Power BI
Looking at the progress from raw file reporting to analysis via database and why the Cost Management Api where not used
ADS Database Projects with SQLCop quality control
This session will focus on SQL Projects in Azure Data Studio and making use of SQLCop as part of a CI pipeline
This will look at how to get the sdk-style projects working & building
And the use of the tSQLt framework with SQLCop to validate best practice in your code
While most people are still behind with database unit testing, SQLCop provide a quick and basic level of testing for any project
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top