Azure SQL Data Warehouse with PowerShell
We will teach how to create a new SQL Azure Data Warehouse using Powershell
2017-01-30
1,625 reads
Azure
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,706 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,639 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
Azure SQL Database Elastic Database Jobs
In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.
2016-04-28
5,096 reads
Getting Started Tuning Performance in Azure SQL Database
Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.
2016-04-20
3,285 reads
Introduction to Protecting SQL Server with Azure Site Recovery
Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.
2016-03-29
4,191 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers