Hot of the announcements at Microsoft Ignite conference is the arrival of some new Memory Optimised VM Types. For those of you configuring SQL workloads on VMs, the DSv2 series has always been the "goto" VM Type for 8 and 16 core workloads, due to the higher RAM to core and IOPS to core ratios. … Continue reading The new King VM Type for SQL has arrived!
This is the third blog in a series looking at the need for DW Automation focusing on Synapse SQL Pools (dedicated). In the first blog we looked at why we need DW Automation tools and what they look like:https://prodata.ie/2021/09/14/the-need-for-dw-automation-1-3/In the second blog we looked at a maturity model for DW automation with six levels of … Continue reading DW Automation demo for Synapse SQL Pools (3/3)