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,642 reads
Azure
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,186 reads
How to Build Your First SQL Server Virtual Lab in Windows Azure
If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.
2017-02-13
5,534 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,652 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,748 reads
Automatically upload SQL Server Database Backups to Azure with Integration Services
Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups.
2016-10-18
4,153 reads
Taking Azure SQL Data Warehouse for a Test-Drive
Azure SQL Data Warehouse uses SQL to query the data, but there are some differences to SQL Server's dialect of TSQL, and queries don't necessarily work in the same way. DBAs are also required to use SSDT to access Azure SQL Data Warehouse. It is worth taking the time to try the preview of the product, and take it for a 'spin around the block', following Robert Sheldon's walk-through.
2016-06-21
4,892 reads
Azure Machine Learning - Your first experiment
In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.
2017-05-05 (first published: 2016-06-14)
5,734 reads
Comparing Networking Options in Azure
What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you'll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), Site-to-Site (S2S), and ExpressRoute, but what are their relative advantages, and which one is right for the way you need to use Azure?
2016-05-19
3,041 reads
Getting started with Azure SQL Data Warehouse
Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.
2016-05-02
3,466 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers