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 […]
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 […]
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]
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 […]