GitHub

BI Developer Portfolio — Fintech

90-day plan to move from financial analysis into BI development in fintech. This repository holds the T-SQL, Power BI, ETL, dbt and Python work produced along the way, committed daily. queries/ T-SQL ...
snowflake

Build a Real-Time BI Dashboard with Interactive Warehouses

Traditional analytical warehouses are optimized for large batch scans. When a dashboard needs to refresh every few seconds and answer sub-second queries at high concurrency, you need a different ...
blog.csdn

SQL Server DATEADD()深度解析：时间位移原理与8大生产场景

本文深入解析SQL Server DATEADD ()函数的本质——非算术加减，而是日历感知的时间坐标位移。重点剖析秒至年的8种时间单位行为差异，揭示精度陷阱、月末回滚、时区处理等底层机制；提供8大生产场景（如API超时告警、会话过期、账单生成）的可复用T-SQL模板；总结8条文档未载的硬核技巧与避坑指南 ...
blog.csdn

SQL Server数据库安全加固实战：账号权限、审计日志与通信加密

这份《Sql Server数据库系统加固规范》不是教你怎么点几下企业管理器就完事的“安全 checklist”，而是一套覆盖账号生命周期、权限边界、通信链路、内核级防护的完整防御体系。