Adatis BI Blogs

What's New

  • Nonclustered Columnstore Indexes And Stored Procedures

    I was recently working on a project with a developer who needed to execute a stored procedure which followed this pattern (amended for simplicity): CREATE PROC ExampleProc AS IF ( SELECT COUNT (*) FROM Sys.indexes WHERE name = 'NCCIDX_DemoIndex' ) > 0      DROP INDEX [NCCIDX_DemoIndex] ON [dbo].[Demo] INSERT INTO [dbo...
    Posted to Jonathon Eve-O'Connor's Blog (Weblog) by JEOC on 08-19-2014
  • DQS Reference Data Services with SSIS

    Rather than just using the the local domain values in its internal knowledge base, Data Quality Services (DQS) can instead clean data by using external reference data. This is a feature called Reference Data Services and in this blog post I’m going to show an example of cleaning SSIS data by connecting to the Azure Data Market. Azure Data Market After...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 07-24-2014