Browse by Tags

• auditing
• DMVs
• katmai
• SQL Server 2005
• SQL Server 2008

• When was my database / table last accessed?

  A frequently asked question that surfaced again today is, "how do I see when my data has been accessed last?" SQL Server does not track this information for you. SELECT triggers still do not exist. Third party tools are expensive and can incur unexpected Read More... Posted Tuesday, May 06, 2008 2:14 AM by AaronBertrand | 8 Comments Filed under: SQL Server 2008, DMVs, dynamic management views, SQL Server 2005, auditing

• 16 Changed Dynamic Management Views in SQL Server 2008

  Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008 ; previously, I had noticed that a few of the existing DMVs from 2005 had changed slightly. So, Denis sparked my curiosity, and I ran the following query on a recent build of SQL Server Read More... Posted Thursday, February 07, 2008 9:46 AM by AaronBertrand | 3 Comments Filed under: katmai, SQL Server 2008, DMVs, dynamic management views

• Dynamic Management Objects are nice, but...

  Don't get me wrong, I really like the catalog views and dynamic management objects. There is so much information revealed to us now; previously, only available through PSSDiag, obscure or unsupported/undocumented DBCC commands, or not at all. But there Read More... Posted Wednesday, December 27, 2006 2:44 PM by AaronBertrand | 3 Comments Filed under: dynamic management views

• A custom report for Management Studio : Show Blocking

  Note that the techniques described in this post require the latest CTP of Service Pack 2 for SQL Server 2005 on the client (but the custom reports can run against a server that is at a lower build level). Since the early betas of "Yukon," which later Read More... Posted Tuesday, December 19, 2006 9:41 PM by AaronBertrand | 4 Comments Filed under: dynamic management views Attachment(s): ShowBlockers.rdlc.txt