SQL Data Warehouse

Connecting to SQL Data Warehouse

  • Article

The most frustrating thing with any new system is often just working out how to connect to it. Oddly, you can’t use SSMS with SQL Data Warehouse, but it is fine with SSDT, SSIS, Power BI desktop, sqlcmd, BCP, and a range of Microsoft cloud services - there are PowerShell Cmdlets too. Rob Sheldon provides the details.


3,054 reads


Backup Techniques for SQL Server on Azure Virtual Machines


In the previous blog post I did a quick overview building a SQL VM...

SQLCover 0.5 - Fixes, smaller features and an exciting surprise


It has been a little while but I have updated SQLCover to include a...

Switch activity in Azure Data Factory: Container with many IFs


(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with...

Read the latest Blogs


service pack Question

By itmasterw 60042

Hi, I updated our SQL ser5ver from Sp2 to SP 4 today, and it...

SQL Server security after deleting AD group

By jontris

I currently have a scenario where an AD group that was defined as a...

join with GEOMETRY data type

By snomadj

I want to perform something like....   SELECT * FROM a JOIN b ON...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers