Book Announcement – Query Store for SQL Server 2019
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
43 reads
Blog Posts
Book Announcement – Query Store for SQL Server 2019
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
3 reads
Book Announcement – Query Store for SQL Server 2019
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
5 reads
Cool Stuff in Snowflake – Part 10: RATIO_TO_REPORT
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-10-02
10 reads
How to read documentation
I was thinking about a comment I made to my intern last week. She has been studiously attending to all the different things I do in my day (what...
2019-10-02
21 reads
How to test ETL Processes in production
This is the final part in the four-part series into testing ETL pipelines, how exciting!
Part 1 - Unit Testing https://the.agilesql.club/2019/07/how-do-we-test-etl-pipelines-part-one-unit-tests/ Part 2 - Integration Testing https://the.agilesql.club/2019/08/how-do-we-prove-our-etl-processes-are-correct-how-do-we-make-sure-upstream-changes-dont-break-our-processes-and-break-our-beautiful-data/ Part 3...
2019-10-02
8 reads
How to test ETL Processes in production
This is the final part in the four-part series into testing ETL pipelines, how exciting!
Part 1 - Unit Testing https://the.agilesql.club/2019/07/how-do-we-test-etl-pipelines-part-one-unit-tests/ Part 2 - Integration Testing https://the.agilesql.club/2019/08/how-do-we-prove-our-etl-processes-are-correct-how-do-we-make-sure-upstream-changes-dont-break-our-processes-and-break-our-beautiful-data/ Part 3...
2019-10-02
122 reads
Shutting Off PowerShell Warnings–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Not really a SQL Server post, but I...
2019-10-02
16 reads
Speaker at SQL Saturday# 912 – New York 2019
I’m very happy to announce that for the first time, I will be participating as speaker at the SQL Saturday# 912 in New York City! This event will be...
2019-10-02
22 reads
Troubleshooting NUMA Node Inbalance Problems
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-10-02 (first published: 2019-09-23)
722 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kapasari No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasari 81, Kapasari, Kec. Genteng, Kota SBY, Jawa Timur Surabaya, Jawa Timur,...
BCA KCP Kapasan No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasan 155, RT.007/RW.09, Kapasan, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Jembatan Merah Plaza No.Telp 083831617937
Whatsapp.083831617937 Ruko Jembatan Merah Plaza Blok A No. 36-37, 38-39 Surabaya, Jawa Timur, Indonesia...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers