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 ...

Part of the SQL Server 2022 blog series.. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

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 ...

PowerShell vs. SQL Server Management Studio When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 ...

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 ...