Malcolm Smith

mhsql.github.io

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

Malcolm Smith's Sessions

Modernizing Local Development: Using SDK-Style Projects with DockerSQLBits 2026

A guide to updating from a local SQL Server install to Docker for your local development. With a focus on alignment with CI/CD processes and resources, to reduce 'it works on my machine' issues This will cover the basics of Docker and the SDK Style Database projects, touching on the use of database testing.

Personal Growth To Professional Success: The Power of Training & Community in Your Life JourneySQLBits 2026

A guide to how training, community events and network has enhanced my career, leading to my 'bucket list' life in Hong Kong Let me guide you to how I get involved, with opportunities open to all.

Unit Testing & Code Style: Enhancing Database Code Quality with SQLCop and tSQLtSQLBits 2026

Dev's do it all the time, yet they 'mock' at the database level. This session goes over what we should all know, testing is important. It uses tSQLt and SQLCop as examples of t-sql based code that can be used to tests inside the database, and cover scenarios the 'set-up' from .NET code may not be able to test

Database Projects in Azure Data StudioSQLBits 2022

Using ADS Database Projects