All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

April, 2008

  • SQL Server 2008 Replication & Filestream

    Ever wondered whether filestream will be supported with replication? Well before I give the answer to that, let me just give you a brief background on FILESTREAM: Much of the data that is created every day is unstructured data, such as text documents...
  • SQL Server 2008 Compression feature and INSERTS

    If you a heap (table without indexes) configured for page-level compression, pages receive page-level compression only in the following ways: Data is inserted by using the BULK INSERT syntax Data is inserted using INSERT INTO... WITH (TABLOCK...
  • Remix 08

    REMIX08 registrations are now open for Sydney, 20 May and Melbourne, 22 May. REMIX08 will be packed with demos, Customer presentations and how-to’s for Web Developers and Designers, building next generation experiences through Silverlight . This year...
  • In case you were wondering.....SQL Server 2008 Change Data Capture

    Today I just had a question from someone with regards to SQL Server Change Data Capture and database compatibility level. The questions was will CDC work with databases with compatibility level 80 or 90 on SQL Server 2008. And the answer is....... ...