There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-10-02 (first published: 2019-09-23)
804 reads
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
41 reads
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
1 reads
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
4 reads
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
8 reads
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
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
6 reads
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
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
14 reads
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
20 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers