Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS
In this article, we will show how to create reports in ASDW using SSRS
2017-03-27
1,607 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Backups in Azure SQL Data Warehouse
This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.
2017-03-20
3,695 reads
Azure DWH Part 5: How to work with the command line in Azure SQL DW
This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse
2017-03-09
1,218 reads
Azure DWH part 4: How to import data to Azure DWH using SSIS
In this article, we will use SSIS to import a CSV file to Azure SQL Data Warehouse.
2017-02-13
1,490 reads
Azure SQL Data Warehouse with PowerShell
We will teach how to create a new SQL Azure Data Warehouse using Powershell
2017-01-30
1,674 reads
Azure DWH part 2: Get Started with Azure Data Warehouse
In this article, we will learn how to use Visual Studio to query Azure SQL Data Warehouse tables and how to create a new table.
2017-01-25
2,822 reads
Join Two CSV Files with a Common Column
In this example we will join two CSV files with a common column using SQL Server.
2017-01-23
7,517 reads
Data Mining Introduction
Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.
2017-01-20 (first published: 2012-11-12)
55,116 reads
Data Mining Introduction
Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.
2017-01-20 (first published: 2012-11-12)
52,809 reads
Azure DWH part 1:Common questions about Azure SQL Data Warehouse
This article compiles some common questions and answers about Azure SQL Data Warehouse.
2016-12-28
9,369 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers