Frank Kalis

http://blogs.msdn.com/bartd/archive/2008/09/03/Query-Fingerprints-and-Plan-Fingerprints_3A00_-The-Best-New-SQL-2008-Feature-You_2700_ve-Never-Heard-Of.aspx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/BPSemanticDBModeling.docx

SELECT 
    DB_NAME(IXStats.database_id) AS DatabaseName,
    OBJECT_NAME (IXStats.[object_id]) AS TabellenName,
    SIX.[Name] AS IndexName,
    IXStats.avg_fragmentation_in_percent,
    IXStats.index_type_desc
FROM 
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) IXStats
    JOIN 
    sys.indexes SIX ON IXStats.[object_id] = SIX.[object_id] AND IXStats.index_id = SIX.index_id
WHERE 
    IXStats.database_id = DB_ID()
ORDER BY 
    IXStats.avg_fragmentation_in_percent DESC

http://www.sqlskills.com/blogs/paul/2008/08/29/TechEdDemoCreatingDetachingReattachingAndFixingASuspectDatabase.aspx

DECLARE @string varchar(500)
SELECT
    @string = '%SomeString%'
 SELECT 
    SCP.usecounts, SCP.cacheobjtype, SCP.objtype, 
    [Statement].text, 
    Executionplan.query_plan 
FROM
    sys.dm_exec_cached_plans SCP
    OUTER APPLY sys.dm_exec_sql_text(plan_handle) [Statement]
    OUTER APPLY sys.dm_exec_query_plan(plan_handle) Executionplan
WHERE
    Statement.[text] LIKE @string AND
    SCP.cacheobjtype ='Compiled Plan' AND 
    SCP.objtype = 'proc'

http://blogs.msdn.com/dtjones/archive/2008/08/28/where-the-heck-is-dmo.aspx

http://www.sqlskills.com/blogs/paul/2008/08/26/ShouldMicrosoftProvideATransactionLogReaderTool.aspx

http://www.sqlskills.com/blogs/paul/2008/08/25/HighperformanceFILESTREAMTipsAndTricks.aspx