Why Do We Need Statistics and to be more specific SQL Server statistics

 

This post is written by Ivan Mukiibi, a young SQL Server professional based in Kampala, Uganda. Ivan is devoted to SQL Server performance tuning, SQL Server internals and also he is passionate about ETL solutions. At this early stage of his DBA carreer he has done an outstanding job researching and interpreting the facts in

Continue reading […] Why Do We Need Statistics and to be more specific SQL Server statistics […]

 

Best Practices Analyzer

Microsoft has been working hard to release their own tools which help DBAs and IT professionals to get a hang of their database systems.

The Bets Practices Analyzer is not a new concept – it is available for SQL 2000, SQL 2005 and SQL 2008 (and for R2!).

What it does is exactly what the title suggests:

Continue reading […] Best Practices Analyzer […]

 

Extracting SSIS package definition from MSDB

How can you extract a SSIS package definition from MSDB repository?

The SSIS packages in MSDB are saved as image blobs and can easily be cast to VARBINARY and then to XML.

Here is the code:

?View Code TSQLSELECT p.[name] as [PackageName]
,[description] as [PackageDescription]
,case [packagetype]
when 0 then ‘Undefined’
when 1 then ‘SQL Server Import and Export Wizard’
when 2 then ‘DTS

Continue reading […] Extracting SSIS package definition from MSDB […]