Format your BIML in SQL Data Studio

I’m a big fan of both Redgate SQL Prompt and SQL Smasin SQL Server Management Studio, but when I’m writing BIML in SQL Server Data Tools I have less options for cool tools to help with things like making my code pretty.  Today I learned a hotkey built into the IDE that I expect to be using a LOT going forward.  CTRL+K, CTRL+D.  Press those two at the same time and your code will pop into line and you’re good to go.  You might have to do a little manual tweaking of course, but this hotkey combo will definitely save you some time!

Leave a Reply

Your email address will not be published. Required fields are marked *