[Updated]: Light weight SQL Server procedure auditing without using SQL Server auditing version

  (The new solution can be downloaded here) (The detailed Information of the solution is mentioned here) After having seeing the solution settled in numerous projects and getting great feedback from you, I added the following request to the solution. Out-of-transaction support for Procedure Logging While you might run the logging within your own crafted…


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…


Bulk Backup and Restore at the tip of your finger <New version>

  Thanks to all the users, contributors and reviewers of the backup and restore procedure I once write for SQL Server databases. If anyone does not know about this, more information can be found here (http://blogs.msdn.com/b/jenss/archive/2011/09/08/bulk-backup-and-restore-at-the-tip-of-your-finger.aspx) I revamped the procedure to be agnostic to SQL Server >2012 as well as the schema changed in the…


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…