Large data solutions can span multiple databases. I’ve recently shared how amazing Database Projects can be but objects which reference across database boundaries can throw up warnings. Is the code solid or have you picked the wrong table and column combination? – you won’t know, and the code is fragile. This is where References come into play. They make […]
A regular Database Project deployment is static and delivers consistent results regardless of environment. When it comes to schema, that’s usually desired, but data is a different story. Data is environment specific. You want a Database Project that works across all environments. You want smarter deployments. You need SQLCMD Variables. What are SQLCMD variables SQLCMD is a […]
Last month in SSMS v22.4, we had the Database DevOps (preview) workload introduced which brings with it Database Projects. Last week I shared my favourite features for them which make deployments amazing. But if you’ve tried them out in SSMS you might have noticed that not everything is present. It’s a preview, after all. So what can we […]
If you’ve been using Database Projects for simply maintaining copies of your database objects – like I used to – then you’ve been missing out on the power of its deployments. Initially I was sceptical about how it could effectively perform upgrades but after seeing them land in SSMS last month I wanted to revisit them as a means […]
Andy Brownsword 