Setting things in the right compatibility view (Visual Studio 2005 / 2008 / 2010 / 2012 / 2013 / BIDS / BI Development SSAS SSIS SSRS SSDT, SQL Server 2005 / 2008 / 2008R2 / 2012 / 2014)

  A very common request and question is (as I have to confess that this is confusing) is which version of SQL Server (SSMS – SQL Server Management Studio, BIDS – Business Intelligence Development Studio, VS- Visual Studio) does works together with which version of SQL Sever which target version and which project type. Here…

2

Update to SQLCmdScriptExpander => 0.2.0.0 is out

(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 |                     BigEndianUnicode |                     Default |                    …

6

Expand :r referenced files for SQLCMD into one file (SQLCmdScriptExpander)

(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…

5

Getting a list of all facets and its properties

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 things,…

9

Renaming sysprepred SQL Servers via script

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 a lot responsiblity about renaming all…

0