Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code
In this step-by-step article, learn how to quickly install Python and start writing Python code using Jupyter Notebooks or Visual Studio Code.
2024-04-05
Articles
Use Fabric Data Factory to Load Data From a CSV File in Azure Blob Storage to Azure SQL DB
Andy Leonard discusses and demonstrates using Fabric Data Factory to load a CSV file stored in Azure Blob Storage to Azure SQL DB.
2024-04-03
Custom Statistics Distributions in SQL Server 2022
You can create custom statistics distributions, sampling, and histograms in SQL Server 2022 with a new trace flag
2024-04-01
1,409 reads
Choosing Between SSIS vs ADF: What You Need to Know
In this article, we look at how you might go about choosing whether to use SSIS or ADF for your next ETL/ELT project.
2024-04-01
2024-03-29
8,391 reads
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution plan (then executes <500ms) if multiple SPIDS all submit that query (different param values) when there’s no plan at start, does each SPID calc the execution plan, one after the other after waiting for the prior SPID to finish?
2024-03-29
Server Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can customize them. Another article will cover the Database dashboards. […]
2024-03-28 (first published: 2024-01-29)
3,934 reads
A First Look at SSMS 20
Recently Microsoft released SQL Server Management Studio (SSMS) v20.0, which is a major release of the primary tool that many of us use to work with SQL Server. Over the last few years, the tools team at Microsoft has worked to separate the tools from the various editions, giving us separate SSMS downloads. There have […]
2024-03-27
15,316 reads
Managing Files and Folders with Python – Data Engineering with Fabric
In this article, learn how you can manage files and folders for both full and incremental loading situations.
2024-03-27
3,690 reads
What is Eventstream in Microsoft Fabric? - Part 1
Learn about Eventstream in Microsoft Fabric to ingest, transform, and route real-time data to certain destinations in a low-to-no-code SaaS fashion.
2024-03-27
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?