Best Option for Working with Files in SSIS
This time we will compare different solutions to copy system folders using different SSIS tasks.
2019-11-22 (first published: 2017-05-09)
13,916 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Azure DWH part 20: Create External and Internal tables As Select
CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.
2019-07-12 (first published: 2017-12-12)
4,304 reads
Azure DWH part 29: MicroStrategy Desktop with Azure
In this article, we will show how to connect MicroStrategy Desktop with ASDW.
2019-01-08
583 reads
Azure DWH part 28: The ASDW enemies
This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.
2018-06-26
523 reads
Azure DWH part 27: Creating your ASDW in Cloud Shell using Bash
In this article, we will show how to create an ASDW in Bash using the Cloud Shell.
2018-02-27
353 reads
Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell
In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.
2018-02-15
372 reads
Azure DWH part 25: Auditing and threat detection
In this new article, we will show how to audit the Data Warehouse Activities.
2018-01-30
545 reads
Azure DWH part 24: Elastic queries
This article will explain what is an elastic query and show an example.
2018-01-23
3,345 reads
Azure DWH part 23: Data Mining
SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.
2018-01-09
500 reads
Azure DWH part 22: Dynamic Management Views
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
2017-12-26
907 reads
Blogs
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Tech Conferences and Expanding Your View
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Managing subscribers, creating newsletters
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
Forums
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers