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

Browse by Tags

Related Posts
  • Blog Post: Converting Existing table from BLOB to Filestream

    1. Create FILESTREAM filegroup. 2. Add FILESTREAM column to table 3.   Choose one of: a. Write an app to select data from the BLOB column and stream it into the FILESTREAM column b. UPDATE <table> SET <filestream_column> = <blob column>; 4. Drop blob column Note: Filestream...
  • Blog Post: SQL Server 2008: Filestream Data & Delete Statement

    When using Filestream data in SQL Server 2008, you may come across what seems like strange behaviour. This is when you issue a DELETE statement to delete the filestream data, it doesnt actually disappear from the file system. You may ask…why is this? This is essentially because of SQL Server transaction...
  • Blog Post: Tips & Tricks: SharePoint 2010 Performance Point Services–Reporting Services report settings

    I see this occur quite often and even I keep on repeating this mistake – when it comes to setting up the Report Server URL and Report URL properties for a Reporting Services based report (in SharePoint integrated mode) in Performance Point Services Dashboard Designer. I will quite often just copy and...