Software Tip: Add Machine Name to Log4Net Filename

If you have multiple servers logging to the same folder, you can create unique file names by adding the server name to the file that it logs to by changing your log4netConfig.xml file to something like: 

<file type=”log4net.Util.PatternString” value=”logs/MultiServerApp.%property{log4net:HostName}.log” />

Beware! SQL Server Stops Execution on Recompile

Can anyone tell me why Microsoft SQL Server stops executing a stored procedure when it is recompiled?  This is dangerous behavior unlike any other software code release system I’ve ever seen.   Through all my years of SQL development this thought never crossed my mind.  [Read more →]