# bidesign.uk > AI-optimized mirror of bidesign.uk containing 50 pages totalling 18,296 words of clean markdown content, structured data, and semantic HTML. Original source: https://bidesign.uk/. Last updated: 2026-06-15T05:04:19.544Z. Each page is available as HTML (with JSON-LD structured data) and Markdown (text-only, ideal for LLMs and RAG). ## Homepage - [BI Design](/content/site-root.html): We specialise in the design and development of bespoke reporting solutions. (864 words) ## Articles & Blog Posts - [Condor Ferries](/content/portfolio/condor-ferries/index.html) (180 words) - [Samsung Electronics](/content/portfolio/samsung-electronics/index.html) (143 words) - [Reducing the Size of the Distribution Database: Improving Transactional Replication Performance (Part 3)](/content/post-sitemap-xml.html) (60 words) - [Time Dimension](/content/wpdmpro-sitemap-xml.html) (14 words) - [Portfolio](/content/portfolio-sitemap-xml.html) (30 words) - [category-sitemap-xml.html](/content/category-sitemap-xml.html) (20 words) - [sitemap_index-xml.html](/content/sitemap_index-xml.html) (14 words) - [wpdmcategory-sitemap-xml.html](/content/wpdmcategory-sitemap-xml.html) (2 words) - [post_tag-sitemap-xml.html](/content/post_tag-sitemap-xml.html) (12 words) - [page-sitemap-xml.html](/content/page-sitemap-xml.html) (18 words) - [data-warehousing-tip-7/index.html](/content/data-warehousing-tip-7/index.html) (1 words) - [Too complex to query](/content/data-warehousing-tip-4/index.html): Trust your instinct when it comes to building solutions. If the solution seems too complex then maybe it is. (1,458 words) - [Building to spec](/content/data-warehousing-tip-9/index.html): If you aren't testing at volume you are leaving the performance of your solution to chance. (1,503 words) - [What should the value of your unknown member key be?](/content/data-warehousing-tip-6/index.html): In this article I’m discussing the benefits of using a consistent unknown member key across your data warehouse. (1,690 words) - [Symptoms:](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-1.html) (714 words) - [Single version of the truth](/content/data-warehousing-tip-2/index.html): Follow some clear rules when building your data warehouse to ensure that your solution delivers accuracy, simplicity, and responsiveness. (1,085 words) - [You can make your keys smaller and more efficient](/content/data-warehousing-tip-5/index.html): Why you should always use surrogate keys for your dimension and fact tables. (796 words) - [Implementing](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-3.html) (1,018 words) - [Change is good](/content/data-warehousing-tip-8/index.html): The focus of this article is to ensure that when you make changes that they enhance your data warehouse and it's reputation not diminish them. (1,132 words) - [Requirements, what requirements?](/content/data-warehousing-tip-3/index.html): Build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in, and use this to drive the next release. (1,230 words) - [ADF Logging to DB](/content/download/adf-logging-to-db/index.html) (66 words) - [ADF Logging to DB](/content/download-category/all/index.html) (64 words) - [Differing distribution schedules](/content/reducing-the-size-of-the-distribution-database-improving-transactional-replication-performance-part-2.html) (737 words) - [Tag](/content/tag/sql-server/index.html) (351 words) - [ADF Incremental Load](/content/download/adf-incremental-load/index.html) (71 words) - [A Fabric solution can be very cost effective - BI Design](/content/a-fabric-solution-can-be-a-very-cost-effective/index.html) (355 words) - [Draper Tools](/content/portfolio/draper-tools/index.html) (257 words) - [The issue](/content/ssis-azure-blob-source-text-qualifier-issue/index.html) (655 words) - [Tag](/content/tag/ssis/index.html) (88 words) - [Are you getting value from your reporting? - BI Design](/content/are-you-getting-value-from-your-reporting/index.html) (269 words) - [SSIS Multithreading](/content/download/ssis-multithreading/index.html) (70 words) - [Time Dimension](/content/download/time-dimension/index.html) (70 words) - [A bespoke reporting solution doesn’t have to cost the earth - BI Design](/content/a-bespoke-reporting-solution-doesnt-have-to-cost-the-earth.html) (277 words) - [ADF Dynamic Load](/content/download/adf-dynamic-load-to-staging/index.html) (71 words) - [Tag](/content/tag/sql-server-replication/index.html) (212 words) - [Data Warehousing Tip #1 - Store fact data at the leaf level - BI Design](/content/data-warehousing-tip-1/index.html): Store fact data at the leaf level. If you aggregate your fact data as part of your ETL/ELT then you are painting yourself into a corner. (237 words) - [ADF Dynamic Query](/content/download/adf-dynamic-query/index.html) (71 words) - [Essential Criteria for a Reporting System](/content/the-fundamental-requirements-of-a-reporting-system/index.html) (280 words) - [NHS Dorset](/content/portfolio/nhs-dorset/index.html) (316 words) - [Tag](/content/tag/t-sql/index.html) (90 words) - [Tag](/content/tag/data-warehouse-design/index.html) (87 words) - [Tag](/content/tag/ssdt/index.html) (88 words) - [Advanced Resource Managers](/content/portfolio/arm/index.html) (236 words) - [Tornado Wire](/content/portfolio/tornado-wire/index.html) (287 words) - [Troy UK](/content/portfolio/troy-uk/index.html) (339 words) - [Mole Avon Country Stores](/content/portfolio/mole-avon-country-stores/index.html) (238 words) - [Hiatt Hardware](/content/portfolio/hiatt-hardware/index.html) (201 words) - [Jobsite](/content/portfolio/jobsite/index.html) (157 words) - [ADF Dynamic Load II](/content/download/adf-dynamic-load-ii/index.html) (72 words) ## Resources - [Full Page Index](/index.html): Browse all cached pages with rich metadata - [About This Cache](/content/about.html): Methodology, technical details, and usage guidelines - [XML Sitemap](/sitemap.xml): Machine-readable sitemap for crawler discovery - [Robots.txt](/robots.txt): Crawler directives