SQL Server Data Tools: A Work in Progress. I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...

Next I have the all-important Transform data using Power Query action. At the moment you can only use Power Query with SQL Server data sources, and (at least when I tested it) it only seems to work ...