In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.

Level 2 of the Stairway to Synapse Analytics: Analyze Data in Storage Account using the Serverless SQL pool

by Sucharita Das

SQLServerCentral

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.

Level 3 of the Stairway to Synapse Analytics: Analyze Data Using a Spark Pool

by Sucharita Das

SQLServerCentral

Uncategorized

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 […]

Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake

by Sucharita Das

SQLServerCentral

Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creating the Synapse Workspace. In Level 2, we analyzed Data Lake files using the Serverless SQL Pool. In Level 3, we analyzed Data Lake files using the Spark Pool. In Levels 4 and level 5, I will discuss the Delta […]

Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2

by Sucharita Das

SQLServerCentral

Uncategorized

This next article in the Stairway to Synapse looks at Delta tables and processing streaming data.

Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool

by Sucharita Das

SQLServerCentral

This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.

Reflecting on the Mythical Man Month

by Steve Jones

SQLServerCentral

software development

Steve looks back at the Mythical Man Month, a book every software engineer and manager should read.

SQL Automate - A DBA's Time-Saving Toolkit

by Deepam

SQLServerCentral

SQLAutomate is a lightweight PowerShell tool that simplifies SQL Server deployment by automating both installation and post-installation configuration. Whether you're setting up one instance or dozens, this guide shows how to use SQLAutomate to save time and reduce manual work.