The topic of this post comes from a question on the MSDN Forums, and had it not been for some advice from Buck Woody (blog|twitter), I never would have known the answer.  Lately I’ve been doing a lot of work with Policy Based Management, in particular, working with Lara Rubbelke’s (blog|twitter) Enterprise Policy Management Framework which is ...

Every now and then I get a SQL epiphany and figure out another way of doing something.  Forever, I have used DBCC SQLPERF('logspace') to get the utilization information for the database transaction logs in SQL Server.  A question on the forums asked how to get the code for this DBCC command because sp_help_text wouldn't provide it.  ...