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
25 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
33 reads
SQL Homework – October 2019 – Code review (self and peer)
Every database person I’ve ever met writes at least some code at some point in their career. That code might ... Continue reading
2019-10-14 (first published: 2019-10-02)
536 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
8 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
13 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
43 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
10 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
135 reads
Why Does Everyone Have More Friends Than You?
No, the answer isn’t because you’re a DBA. This isn’t a technical post about databases, but rather a discussion of a statistical paradox that I read about recently. Statistics...
2019-10-01
43 reads
We Thought That Sean McCown’s SMO Tutorial Was So Good, It Needed To Be A Video In It’s Own Right
Back in February, Sean McCown joined us on the Undercover podcast and presented a brilliant tutorial on the SMO. We thought that it was so good that we’ve decided...
2019-10-01
58 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers