Developer hearted / Relational minded

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

2013-03-15T09:32:35Z

The 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 occurence of the beginning of the body text does not work if supplement characters are present after the “AS” keyword, stopping the whole process of applying logging to all procedures. I now check the occurence and throw an error if the statement...(read more)

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

2013-03-07T06:40:40Z

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 services projects (.dtproj) More Information about this can be found here: http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/03/06/sql-server-data-tools-business-intelligence-for-visual-studio-2012-released-online.aspx The direct download link is Microsoft...(read more)

SQL Server Reporting Services Load Simulator v 0.2.0.0

2013-02-25T23:23:00Z

( 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 the data If you deployed an environment, you already hold the solution in your hand. You can grab the information from the execution log of the Reporting Services...(read more)

PowerShell StdOut go out, StdErr go everywhere

2013-02-14T20:08:00Z

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, that error in addition needed to be duplicated in an error file, that in case of an error you can simply grab all the non 0kb files and do through them in order to investigate...(read more)

Blog Resources online again !

2013-02-08T15:38:58Z

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...(read more)

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

2013-01-30T20:31:00Z

(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 cleaning up databases or checking for internal consistency is avoided in order “not to touch a running system”. So, simple things get out of focus like ...(read more)

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

2013-01-28T08:15:42Z

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 will have to be installed or even cannot be build without the IDE, headless builds use the builds machine build processor (for MSFT mostly msbuild.exe...(read more)

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

2013-01-14T12:04:00Z

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 Service class inherited already a property called ServiceName from ServiceBase, so I thought I was already done with all the...(read more)

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

2013-01-10T19:22:42Z

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 determined from the supplied connection string. Check if the connection string is valid for the ADO.NET provider used for your database provider and that you have the privileges necessary to connect to the...(read more)

Outage: External sample server down

2012-09-28T09:42:17Z

As 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 you need any sample / scripts / tools, let me know and I will send them you via mail....(read more)