Level 1 of the Stairway to Synapse Analytics - Create a Synapse Workspace
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creation of the Synapse Workspace. In Level 2, data analysis was done on Data Lake files using Serverless SQL Pool. In Level 3, I will analyze data from the files uploaded in Data Lake container using a Spark Pool. I will […]
Learn how to remove TDE from a database and return it to a normal state.
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.
Learn how you can configure a Snowflake account in your cloud database and load data.
This article shows you how to create an Analysis Services Tabular Model project, import data from World Wide Importers database, create a measure and analyze in Excel.
In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.
In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
I'm not sure that I'm posting this in the right section, so please mods...
Hi all I've written a script to keep track of how long backups...
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...
In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?
See possible answers