As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write your ...

We are very pleased to announce today that SQL views from the SQL Server connector available at the end of the week in PowerApps. Leveraging SQL Views will allow you to combine data in SQL Server ...

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if ...

Can you use Power Query to move data out of Excel and into SQL Server? Well, it turns out you can… with some limitations. This blog post details what I found out while researching this problem. I ...