http://blogs.msdn.com/b/jenss/en-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)Developer hearted / Relational mindedJens K. SuessmeyernoSQL Serveren-UShttp://blogs.msdn.com/b/jenss/archive/2013/03/15/updated-light-weight-sql-server-procedure-auditing-without-using-sql-server-auditing-version-0-2-1-0.aspxFri, 15 Mar 2013 09:32:35 GMT91d46819-8472-40ad-a661-2c78acb4018c:10402576Jens K. Suessmeyer -0http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10402576http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10402576http://blogs.msdn.com/b/jenss/archive/2013/03/15/updated-light-weight-sql-server-procedure-auditing-without-using-sql-server-auditing-version-0-2-1-0.aspx#commentsThe most recent version can be found here (The detailed Information of the solultion is mentioned here ) I created a minor update for the logging functionality in order to find the right entry point for injecting the code. It turned out that finding the...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/03/15/updated-light-weight-sql-server-procedure-auditing-without-using-sql-server-auditing-version-0-2-1-0.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10402576" width="1" height="1">SQL Server 2008SQL Server 2005SQL Server 2000LoggingSQL Server 2012TSQLhttp://blogs.msdn.com/b/jenss/archive/2013/03/07/finally-the-family-united-sql-server-bi-project-templates-now-available-in-visual-studio-2012.aspxThu, 07 Mar 2013 06:40:40 GMT91d46819-8472-40ad-a661-2c78acb4018c:10400160Jens K. Suessmeyer -9http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10400160http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10400160http://blogs.msdn.com/b/jenss/archive/2013/03/07/finally-the-family-united-sql-server-bi-project-templates-now-available-in-visual-studio-2012.aspx#comments&#160; We waited and hoped and now we finally have them. SQL Server BI project templates in Visual Studio 2012. This includes Project templates for SSAS Analysis services projects (.dwproj) SSRS Reporting services projects (.rptproj) SSIS Integration...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/03/07/finally-the-family-united-sql-server-bi-project-templates-now-available-in-visual-studio-2012.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10400160" width="1" height="1">SQL Server Analysis ServicesSQL Server Integration ServicesSSISSSRSSQL Server Reporting ServicesVisual Studio 2012SSAShttp://blogs.msdn.com/b/jenss/archive/2013/02/25/sql-server-reporting-services-load-simulator-v-0-2-0-0.aspxMon, 25 Feb 2013 23:23:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10396948Jens K. Suessmeyer -0http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10396948http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10396948http://blogs.msdn.com/b/jenss/archive/2013/02/25/sql-server-reporting-services-load-simulator-v-0-2-0-0.aspx#comments( 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...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/02/25/sql-server-reporting-services-load-simulator-v-0-2-0-0.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10396948" width="1" height="1">Reporting Servicestestinghttp://blogs.msdn.com/b/jenss/archive/2013/02/14/powershell-stdout-go-out-stderr-go-everywhere.aspxThu, 14 Feb 2013 20:08:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10393787Jens K. Suessmeyer -0http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10393787http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10393787http://blogs.msdn.com/b/jenss/archive/2013/02/14/powershell-stdout-go-out-stderr-go-everywhere.aspx#commentsWhile 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...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/02/14/powershell-stdout-go-out-stderr-go-everywhere.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10393787" width="1" height="1">Powershellhttp://blogs.msdn.com/b/jenss/archive/2013/02/08/blog-resources-online-again.aspxFri, 08 Feb 2013 15:38:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:10392202Jens K. Suessmeyer -0http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10392202http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10392202http://blogs.msdn.com/b/jenss/archive/2013/02/08/blog-resources-online-again.aspx#comments&#160; 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...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/02/08/blog-resources-online-again.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10392202" width="1" height="1">http://blogs.msdn.com/b/jenss/archive/2013/01/30/where-have-all-the-objects-gone-long-time-passing-version-0-1-0.aspxWed, 30 Jan 2013 20:31:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10389630Jens K. Suessmeyer -0http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10389630http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10389630http://blogs.msdn.com/b/jenss/archive/2013/01/30/where-have-all-the-objects-gone-long-time-passing-version-0-1-0.aspx#comments(You find the script at the end of the blog post) People who inherit databases encounter often the same problem. They either don&acute;t have the time &ldquo;learning&rdquo; the internals / logic of the existing objects within that database, or...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/01/30/where-have-all-the-objects-gone-long-time-passing-version-0-1-0.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10389630" width="1" height="1">Jens K. Suessmeyer -Where have all the objects gone, long time passing ? (Version 0.1.0)SQL Server 2008,SQL Server 2012,TSQLSQL Server 2008SQL Server 2012TSQLhttp://blogs.msdn.com/b/jenss/archive/2013/01/28/headless-build-can-make-you-scratch-your-head-part-1.aspxMon, 28 Jan 2013 08:15:42 GMT91d46819-8472-40ad-a661-2c78acb4018c:10388773Jens K. Suessmeyer -0http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10388773http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10388773http://blogs.msdn.com/b/jenss/archive/2013/01/28/headless-build-can-make-you-scratch-your-head-part-1.aspx#comments&#160; One big advantage over recent database projects is the ability to do headless build on a build controller. &#160; There is no straight forward definition of a headless build. In summary you can describe it that only the needed prerequisites are...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/01/28/headless-build-can-make-you-scratch-your-head-part-1.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10388773" width="1" height="1">SQL Server 2008.NetVSDBCMDVSTSDBALMMSBuildSQL Server 2012SSDThttp://blogs.msdn.com/b/jenss/archive/2013/01/14/why-the-name-of-the-service-ist-not-the-servicename-is-not-the-servicename.aspxMon, 14 Jan 2013 12:04:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:10384693Jens K. Suessmeyer -0http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10384693http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10384693http://blogs.msdn.com/b/jenss/archive/2013/01/14/why-the-name-of-the-service-ist-not-the-servicename-is-not-the-servicename.aspx#commentsWhile 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...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/01/14/why-the-name-of-the-service-ist-not-the-servicename-is-not-the-servicename.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10384693" width="1" height="1">.NetC#Windows Servicehttp://blogs.msdn.com/b/jenss/archive/2013/01/10/the-help-for-the-database-schema-provider-could-not-be-determined.aspxThu, 10 Jan 2013 19:22:42 GMT91d46819-8472-40ad-a661-2c78acb4018c:10383972Jens K. Suessmeyer -2http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10383972http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10383972http://blogs.msdn.com/b/jenss/archive/2013/01/10/the-help-for-the-database-schema-provider-could-not-be-determined.aspx#commentsSome 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...(<a href="http://blogs.msdn.com/b/jenss/archive/2013/01/10/the-help-for-the-database-schema-provider-could-not-be-determined.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10383972" width="1" height="1">SQL Server 2008Data DudeSQL Server 2005SQL Server 2000ADO.NETVSDBCMDVSTSDBALMhttp://blogs.msdn.com/b/jenss/archive/2012/09/28/outage-external-sample-server-down.aspxFri, 28 Sep 2012 09:42:17 GMT91d46819-8472-40ad-a661-2c78acb4018c:10354061Jens K. Suessmeyer -1http://blogs.msdn.com/b/jenss/rsscomments.aspx?WeblogPostID=10354061http://blogs.msdn.com/b/jenss/commentapi.aspx?WeblogPostID=10354061http://blogs.msdn.com/b/jenss/archive/2012/09/28/outage-external-sample-server-down.aspx#commentsAs I am hosting my sample files on an external server, you may experience a 404 downloading them at the moment. This is due to a server move I am currently in. Sorry for the inconvenience, I will post when they are available again. In the meantime, if...(<a href="http://blogs.msdn.com/b/jenss/archive/2012/09/28/outage-external-sample-server-down.aspx">read more</a>)<img src="http://blogs.msdn.com/aggbug.aspx?PostID=10354061" width="1" height="1">