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
This article shows how to attach an MDF with or without a log file.
2024-12-23
2,839 reads
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
How to create a connection for StreamLit and Snowflake to upload data for visualization
2024-12-20
1,825 reads
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.
2024-12-20
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
PASS Data Community Summit will return to Seattle next year! Save the date for this incredible in-person event for global data professionals, which will take place at Summit, Seattle Convention Center, from November 17-21, 2025!
2024-12-18
I was asked recently why Halloween Protection was needed for data modification statements that include a self-join of the target table. This gives me a chance to explain, while also covering some interesting product bug history from the SQL Server 7 and 2000 days.
2024-12-18
Keeping track of all the security related logs can be hard. Using your security team to shoulder some of the load can help. Learn how in this article.
2024-12-16
2,735 reads
In this article, we look at how to use Apache Kafka and Zookeeper to process and load streaming data.
2024-12-16
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Comments posted to this topic are about the item Merry Christmas 2025
Comments posted to this topic are about the item The Reindeer Count
I have listed the event names present in my system_health extended event report. Based...
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers