DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz
In this first article, get an introduction to DAX, it's uses, and the basics of a DAX query as compared to a T-SQL query.
2025-01-01 (first published: 2020-03-26)
24,922 reads
Articles
The Data Center that Exploded
A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!
2025-01-01 (first published: 2014-10-31)
10,375 reads
GUID in SQL Server
This tip's objective is to present and describe several T-SQL examples for creating, using, and analyzing GUIDs and assessing their uniqueness.
2024-12-30
How to Repair Corrupt MySQL Tables
In the modern world, the companies are not solely dependent on a specific database server platform. There are many database platforms available that are adequate to handle moderate workload and client requirements of high availability and disaster recovery. MySQL is one of those database platforms which provides a lot of features and high performance. Just […]
2024-12-27
1,273 reads
SQL Server Forced Plans Overwite the Query Hash
A 16-year old SQL Server bug that means 'forced plans' have the query plan hash in place of the expected query hash. Includes an explanation and discussion of the term 'morally equivalent plan'.
2024-12-27
Convert Excel Workbooks to CSV with Microsoft Fabric
For my new mission, I set out to convert a list of files from Excel to comma-separated values (CSV). We upload the original Excel files to a Data Lake in Fabric. We then need to convert a specific worksheet and move the CSV files to a different folder in Data Lake.
2024-12-25
A gentle introduction to dbt
Over the past years, the tool dbt – short for data build tool – has become quite popular in the data engineering world for handling such an ELT process. dbt takes on the role of the “T”, meaning it’s responsible for transforming the data in a certain data store.
2024-12-23
Connecting Streamlit to Upload Data to Snowflake
How to create a connection for StreamLit and Snowflake to upload data for visualization
2024-12-20
2,504 reads
Data Warehouse Considerations - SCD Type 2 vs Overwrite Dimension Tables
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.
2024-12-20
The ROI of SQL Prompt
Find your personal ROI in under 1 minute. And see how many working days you and your team could save in coding time with SQL Prompt!
2024-12-20
Blogs
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Forums
SQl Server 2014 linked server remote server
Hello all, I have a linked server created on an instance which only has...
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers