Featured Posts

Bug – Synapse SqlPool Language and dates

We found this interesting bug on Dedicated SQL Pool when working with British style language. If you use Dynamic SQL to change the language, then selects on the date fail with a conversion error, but prints work. Weird… An example…

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…

Selecting the right Azure VM for SQL

When looking for the right VM for SQL we need to look at a lot of factors, but mainly these four factors Throughput of VM (Cached and Uncached)Cores AvailableVM Memory GNCost per month (compute and SQL license) This can be…

Power BI- Data Connectivity Modes

Import Data This connection means that Power BI will cache the data meaning Pulling data from Data Source and into Power BI Desktop File. Advantages: Caching the data makes you take full advantage of Vertipaq Engine. Report Performance will be…

Loading…

Something went wrong. Please refresh the page and/or try again.