[Video] Office Hours in Kyoto, Japan
My Asian vacation continues in Kyoto, the City of a Thousand Temples. They’re not playing around – the town is chock full of gorgeous historic temples, and it was tough to pick a scene for today’s Office Hours. Let’s go through …
Convert Excel Workbooks to CSV with Microsoft Fabric
The post Convert Excel Workbooks to CSV with Microsoft Fabric appeared first on SQLServerCentral.
The Ebb and Flow of AI
It’s the end of the year. Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, and talk big picture industry stuff. You and me, our weirdo jobs involve: Databases – which is already unusual, and most …
Frappe’s Configuration vs Laravel’s Code-Centric Customisation
This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database management, and API development. While Laravel’s popularity lies in its code-centric approach to web development, Frappe simpl …
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Introduction In SQL Server, the transaction log file is essential for keeping your database reliable and durable. It tracks every change and transaction, which is crucial for recovering data if something goes wrong. Unfortunately, there are times when …
Connecting Streamlit to Upload Data to Snowflake
Introduction We often see and think of reporting as visualizing the already available data from a database and process it on to a business intelligence tool. In today’s world where data is the unlock to major decisions, reporting can no longer stay one …
Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimension Tables
The post Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimension Tables appeared first on SQLServerCentral.
The ROI of SQL Prompt
The post The ROI of SQL Prompt appeared first on SQLServerCentral.
[Video] Office Hours in Osaka, Japan
Kon’nichiwa! My vacation tour continues in Osaka, Japan, a city famous for its street food, nightlife, and host and hostess clubs. I’m usually the kinda guy who does classy dinners at 5PM and then hits the sack by 9PM at the latest, so you …
How to Explain What We Do
One of my favorite uses for AI is to ask it to explain a concept using wildly unusual points of view. Well, we’re going to be seeing various family members and friends for the holidays, and we’ll get endless questions of, “So, what is …
Why a Self-Join Requires Halloween Protection
The post Why a Self-Join Requires Halloween Protection appeared first on SQLServerCentral.
Save the date for PASS Summit 2025!
The post Save the date for PASS Summit 2025! appeared first on SQLServerCentral.
Are You Underpaid? Let’s Find Out! My Annual Salary Survey is Open.
Every year, I run a salary survey to help folks have better discussions with their managers about salaries, benefits, and career progression. Take the survey now here. The anonymous survey closes Sunday, January 12th. On Tuesday the 14th, I’ll pu …
When Should You Employ Snowflake Materialized Views?
I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place and it’s on us to determine when to use them based on what they offer. This guide will help you in understanding how views and materialized vie …
Feed SQL Server logs into SIEM
We sometimes complain that the Security Operations Center (SOC) doesn’t spot cyber-attacks on time, but maybe we’re not giving them critical information they need to do their job. SIEM stands for Security Information and Event Management; it encompasse …