News

It’s surprisingly easy to stop query folding happening in Power Query by changing the data type of a column. This is mentioned in the docs here, and it’s something several people have blogged about ...
My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve the ...
Harnessing SQL Server 2022's Power. ... S3 object storage integration enables backups/restores to/from S3-compatible storage, plus the ability to query parquet files directly with T-SQL.
Includes basic information about products that use the SQL Server Analysis Services database connector, supported authentication types, prerequisites, and connection instructions. Analysis Services ...
We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions – including ...
SQL Advisor. Query SQL Server with PowerShell. Get the right information on your SQL Servers via the Get-Service cmdlet. By Joshua Jones; 03/10/2011; Last time, I discussed how to get PowerShell and ...