![](http://mssql.fr/wp-content/uploads/2024/12/img_67228dc85b263-150x143.png)
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.
![](http://mssql.fr/wp-content/uploads/2024/04/Brent_Ozar_Shouting_Left-250x245-1-150x150.jpg)
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 …
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 …
Build a Streaming Data Architecture with Apache Kafka and Zookeeper
The post Build a Streaming Data Architecture with Apache Kafka and Zookeeper appeared first on SQLServerCentral.
PASS Summit is going on tour in 2025!
The post PASS Summit is going on tour in 2025! appeared first on SQLServerCentral.
![](http://mssql.fr/wp-content/uploads/2024/12/2024-11_0133-150x150.png)
Getting Started with the Data API Builder
Earlier this year I had a PM at Microsoft reach out and ask me what I thought about the Data API Builder. I hadn’t looked at it, so I made a note to check it out. I hadn’t done that by the time SQL Saturday Denver 2024 occurred, where I saw Jerry Nixon …
![](http://mssql.fr/wp-content/uploads/2024/12/sign-into-ssms-600x307-1-150x150.jpg)
How to Use Github in SSMS v21
SQL Server Management Studio v21 added native Git support, making it easier to use source control natively inside SSMS. This feature is for developers who are already used to working with Github to manage specific object changes as they work, and who a …
![](http://mssql.fr/wp-content/uploads/2024/12/a-blue-and-white-cube-with-a-blue-circle-descript-150x150.jpeg)
TSQL Tuesday #181 – The first SQL Server Feature that made me go “Wow!”
First off, thank you to Kevin Chant for hosting TSQL Tuesday this month. And equally, thank you for not putting a time frame on your request! “My invitation to yourselves is to write about a Microsoft Data Platform announcement that you considere …
[Video] Office Hours in Zhengzhou, China
For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to you from the People’s Park in Zhengzhou, China, which is kinda like the Chicago of China. It’s in the middle of the US, bigger tha …