Browse by Tags

• DMV's
• Policy Based Managment
• SQL Server 2008
• SQL Server 2008 R2

• Policy Based Management and the Unknown LoginMode

  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, Read More... Posted Wednesday, September 15, 2010 2:47 AM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, MSDN Forums, Policy Based Managment, SQL Server 2008, SQL Server 2008 R2

• Getting Log Space Usage without using DBCC SQLPERF

  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 Read More... Posted Saturday, June 06, 2009 2:10 AM by Jonathan Kehayias | 4 Comments Filed under: Database Administration, DMV's, MSDN Forums