Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team


  • Blog Post: About Maintenance Plans – grooming SQL Server

    Hello all, I admit I’m not a big fan of Maintenance Plans (the feature that goes by that name) mainly because of its “do or die” approach. So, it was not by chance that I wrote and keep updating the AdaptiveIndexDefrag procedure. Good maintenance (or lack thereof) may be the difference...
  • Blog Post: SQL Swiss Army Knife #11.1 - Locking, blocking and active transactions

    EDIT (12-04-2013): Added page type information (PFS; GAM or SGAM) when wait type is PAGELATCH_ or PAGEIOLATCH_ . EDIT (23-05-2013): Fixed parse page issue. EDIT (17-10-2013): Added memory grant info, statements to blocking and blocked sections of blocking report, and fixed head blocker info. ...
  • Blog Post: SQL Server Tools - Extended Events Manager & Partition Management

    There are two tools available on Codeplex that you may consider to use/test: SQL Server 2008 Extended Events Manager http://extendedeventmanager.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23813 and SQL Server Partition Management http://sqlpartitionmgmt.codeplex.com/Release/ProjectReleases.aspx...
  • Blog Post: SQL Nexus 2.5.0.7 released

    Hi, A new version of the tool - SQL Nexus (2.5.0.7) was released: http://sqlnexus.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23339 Release Notes Most fixes are related to silent or batch processing 1) Adjusted CurrentDB text box for auto-complete and copy and paste database name 2) Enhanced...
  • Blog Post: RML Utilities, version 9.01 Released

    A new version of the RML Utilities for SQL Server, version 9.01, was released (with support for SQL Server 2008): http://blogs.msdn.com/psssql/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx Review, also, the last minute update regarding a small...
Page 1 of 1 (5 items)