(Updated version available here) As suggested by M Merrill in my former post of SQLCMDScriptExpander (which can be found here ), I added an option for providing the encoding of files. So I created another option where you can specify the encoding from the following options: /Encoding:[ ASCII...

(Updated version available in this blog post ) How can we expand files from a .sql file referenced with the :r operator ? Ok, lets make a step back in the past and see how we used to reference files in .sql files and calling them via OSQL or ISQL. The answer is, we couldn't. We needed to use either...

For those struggling as I did for getting the complete list of all facets and its properties available, I went down the dark side of the code (Reflection) and got the methods to extract the information from the PBM framework. As a complete reference (as I couldn't find anything beside the SSMS view on...

Using syspreped images of SQL Server without any problems. There may be many of you using syspreping in the past and encountered problems during runtime due to not findable errors which were not reproducable on machine they were installed fom scratch and not syspreped. Well, although Windows takes...