Finally, the family…united. SQL Server BI Project templates now available in Visual Studio 2012

  Update( 30.06.2014): Beside the below mentioned information, I have written an updated compatibility sheet for the avaialable combinations or Visual Studio / SQL Server and the BI templates which is published here. We waited and hoped and now we finally have them. SQL Server BI project templates in Visual Studio 2012. This includes Project…


SQL Server Reporting Services Load Simulator v

( Download at the end of the blog entry )   Testing with realistic parameter sets Ever wanted to test your SQL Server Reporting Services infrastructure against a realistic workload? Most often the problem is where to get the realistic data (parameter sets, a good weight of the different rendering formats) from. You already have…


PowerShell StdOut go out, StdErr go everywhere

  While becoming familiar and a really big fan of PowerShell, I faced the following issue. During a migration project doing bulk migrations, I needed information Messages (coming to StdOut) as well as error message (coming to StdErr) displayed to the Console. Well that is quite easy as being the standard behavior. The challenge was,…


Blog Resources online again !

  I will write everyone who directed me directly again, but for those watching the blog, the ressources linked in the blog entries are online again..finally. Thanks for all your patience ! -Jens


Where have all the objects gone, long time passing ? (Version 0.1.0)

  (You find the script at the end of the blog post)   People who inherit databases encounter often the same problem. They either don´t have the time “learning” the internals / logic of the existing objects within that database, or the learning curve and the time needed is too high for getting started. So…


Headless build can make you scratch your head (Part 1)

  One big advantage over recent database projects is the ability to do headless build on a build controller.   There is no straight forward definition of a headless build. In summary you can describe it that only the needed prerequisites are installed for compiling and translating the bits. While for some compilations specific applications…


Why the name of the service ist not the ServiceName, is not the ServiceName

  While recently writing a windows service which should be a multi-instance Service, I encountered the following challenge. As in SQL Server I wanted to use a similiar naming convention like MyServiceName$InstanceNameHere to distinguish the services from another. Within the service I needed exactly this service name in order to gather the right configuration. Fortunately,…


The help for “The database schema provider could not be determined…”

Some of us might be still bound to VSDBCMD instead of using the new tools of SSDT like SQLPackage. As frustrating as it is, we need to also get around this and the limitations of the existing error Messages of VSDBCMD. The one you will encounter often is: The database schema provider could not be…