SQL Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored. All sorts of tasks performed by a DBA or developer can benefit greatly from knowledge of what the storage engine is doing and how it works. This tool has been designed to make database internals...
SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components. Step by Step Instructions for Creating a sample Custom Component. Download here .
Ever tried to update content over 64K in a ntext field in Query Analyzer? It won't work as pasting text into Query Analyzer is limited to 64K. So there you are then! As far as I know only the use of ADO might be of any help. But if you're after a quick and neat solution, have a look QALite . It might just be what you're looking for...
posted by
on
to
()
And you thought you were on easy street by knowing ETL! Take a look at Data Patterns and weap!