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: EDW

Uncategorized

Meta data Automation at SqlBits 2022

The absolute key to getting agility and extensibility in a data warehouse project is a good meta data based automation framework and tools, regardless of whether you are using TSQL, Pool, Databricks and/or Python. If you are coming to SqlBits 2022, then there are a few sessions touching on this subjects. Full Schedule on this … Continue reading Meta data Automation at SqlBits 2022

March 7, 2022March 7, 2022EDW, SynapseLeave a comment
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

Posts navigation

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