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.
Level 2 of the Stairway to Synapse Analytics: Analyze Data in Storage Account using the Serverless SQL pool
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
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
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 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
Reflecting on the Mythical Man Month
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
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.
Stairway to Snowflake Level 7 - Snowflake Tables
In this next level of the Stairway to Snowflake we examine the wide variety of table types that exist in the platform.
Index Scans and Table Scans
There are several things that you can do to improve performance by throwing more hardware at the problem, but usually the place you get the most benefit from is when you tune your queries. One common problem that exists is the lack of indexes or incorrect indexes and therefore SQL Server has to process more data to find the records that meet the queries criteria. These issues are known as Index Scans and Table Scans.
Blogs
The Book of Redgate: Ingeniously Simple
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide
C++ is a highly versatile language for developing console applications, batch processing, and performance-critical...
Easily query your GitHub Contribution activity
By Will Assaf
For a variety of reasons, including your Microsoft MVP activity reports, you might want...
Forums
SQL Automate - A DBA's Time-Saving Toolkit
Comments posted to this topic are about the item SQL Automate - A DBA's...
Reflecting on the Mythical Man Month
Comments posted to this topic are about the item Reflecting on the Mythical Man...
Updating a Data API Builder Connection String
Comments posted to this topic are about the item Updating a Data API Builder...
Question of the Day
Updating a Data API Builder Connection String
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers