Skip to content
Prodata

Prodata

SQL Centre Of Excellence

  • Home
  • Services
    • Synapse and EDW
    • SSAS Services
    • Power BI
    • SQL Server Platform
  • Blogs
  • Offerings
  • About Us
    • History and Verticals
    • Team
    • Contact
    • Jobs at Prodata

Tag: DW

Uncategorized

Top 10 SQL Partition Commandments

I wrote this in 2010, before Clustered Column Store Indexes, SQL Pools (so rule 3 looks a bit odd), and before date data type was mainstream, but the rest of these still look quite Thou Shalt use something that exists in your query as a partition keyThou shalt not make up a surrogate partition keyThou … Continue reading Top 10 SQL Partition Commandments

May 29, 2021May 29, 2021DW, EDW, SQLLeave a comment
Uncategorized

Top 10 SSIS/DW Commandments

Blast from the past. I wrote this is 2008 and at one point we had it made into a poster for the office rule whereby on code review we not say a word but just point to the poster. Not sure how well this stood the test of time now it is 2021 so many … Continue reading Top 10 SSIS/DW Commandments

May 29, 2021May 29, 2021Architecture, DW, EDW, SQL, SSISLeave a comment

Posts navigation

Older posts
  • Facebook
  • Twitter
  • LinkedIn
Prodata
Proudly powered by WordPress Theme: Shoreditch.