corpus.blog
41554 blogs · [ { "id": "01a087eb-eea3-7276-b107-75693f20f778", "title": "Runing tSQLt Tests with Claude", "url": "https://the.agilesql.club/2026/01/runing-tsqlt-tests-with-claude/", "published_at": "2026-01-14T19:35:27+00:00" }, { "id": "01a087eb-eea3-7276-b107-75693f53edde", "title": "tSQLt Test Adapter for Visual Studio 2022+", "url": "https://the.agilesql.club/2025/12/tsqlt-test-adapter-for-visual-studio-2022-/", "published_at": "2025-12-30T13:56:27+00:00" }, { "id": "01a087eb-eea3-7276-b107-75693fbee783", "title": "Github Copilot in SSMS can include data in its memory, simple prompt injections ahead", "url": "https://the.agilesql.club/2025/11/github-copilot-in-ssms-can-include-data-in-its-memory-simple-prompt-injections-ahead/", "published_at": "2025-11-15T09:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569408a6360", "title": "Delta Lake over Spark Connect", "url": "https://the.agilesql.club/2025/06/delta-lake-over-spark-connect/", "published_at": "2025-06-18T19:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569409b9da1", "title": "ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish", "url": "https://the.agilesql.club/2025/06/adf-publish-suddenly-includes-everything-where-it-used-to-be-incremental-changes-since-the-last-publish/", "published_at": "2025-06-15T08:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756940ddb1dc", "title": "Spark Connect Dotnet November 2024 Where are we?", "url": "https://the.agilesql.club/2024/11/spark-connect-dotnet-november-2024-where-are-we/", "published_at": "2024-11-16T09:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694174af34", "title": "Spark Connect Dotnet Variant Data Type", "url": "https://the.agilesql.club/2024/10/spark-connect-dotnet-variant-data-type/", "published_at": "2024-10-12T09:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569420b50f9", "title": "Delta Lake from .NET in a Spark Connect gRPC world", "url": "https://the.agilesql.club/2024/02/delta-lake-from-.net-in-a-spark-connect-grpc-world/", "published_at": "2024-02-17T10:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569423156b5", "title": "Apache Spark from PHP - it is not just a .NET thing", "url": "https://the.agilesql.club/2024/02/apache-spark-from-php-it-is-not-just-a-.net-thing/", "published_at": "2024-02-10T07:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569431b159d", "title": "Implementing functions and more fun in Spark Connect using gRPC and .NET", "url": "https://the.agilesql.club/2024/02/implementing-functions-and-more-fun-in-spark-connect-using-grpc-and-.net/", "published_at": "2024-02-10T07:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756943923588", "title": "Moving towards the DataFrame API using the Spark Connect gRPC API in .NET", "url": "https://the.agilesql.club/2024/02/moving-towards-the-dataframe-api-using-the-spark-connect-grpc-api-in-.net/", "published_at": "2024-02-05T07:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569439af329", "title": "Exploring the Spark Connect gRPC API more", "url": "https://the.agilesql.club/2024/02/exploring-the-spark-connect-grpc-api-more/", "published_at": "2024-02-01T07:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756944888bb8", "title": "Exploring the Spark Connect gRPC API", "url": "https://the.agilesql.club/2024/01/exploring-the-spark-connect-grpc-api/", "published_at": "2024-01-26T09:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756944eb3be8", "title": "Using Spark Connect from .NET to run Spark jobs on Databricks", "url": "https://the.agilesql.club/2024/01/using-spark-connect-from-.net-to-run-spark-jobs-on-databricks/", "published_at": "2024-01-23T09:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756945362e9a", "title": "Spark Connect Dotnet First Major Milestone", "url": "https://the.agilesql.club/2024/01/spark-connect-dotnet-first-major-milestone/", "published_at": "2024-01-17T09:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569461f4239", "title": "Using Spark Connect from .NET", "url": "https://the.agilesql.club/2024/01/using-spark-connect-from-.net/", "published_at": "2024-01-17T09:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569462f02a0", "title": "Spark Connect", "url": "https://the.agilesql.club/spark-connect/", "published_at": "2024-01-01T00:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694712c4d7", "title": "Privacy Policy", "url": "https://the.agilesql.club/privacy/policy/", "published_at": "2021-03-17T05:38:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694753b86f", "title": "ADF: Error trying to debug pipeline: BadRequest", "url": "https://the.agilesql.club/2021/03/adf-error-trying-to-debug-pipeline-badrequest/", "published_at": "2021-03-12T20:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569482e8a6c", "title": "ADF: Querying JSON documents", "url": "https://the.agilesql.club/2021/02/adf-querying-json-documents/", "published_at": "2021-02-26T01:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756948c514b9", "title": "ADF, XML objects and XPath in the expression language", "url": "https://the.agilesql.club/2021/02/adf-xml-objects-and-xpath-in-the-expression-language/", "published_at": "2021-02-12T05:30:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569497b790c", "title": "Synapse Analytics and .NET for Apache Spark Example 4 - JOINS", "url": "https://the.agilesql.club/2021/01/synapse-analytics-and-.net-for-apache-spark-example-4-joins/", "published_at": "2021-01-25T18:10:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756949b8958d", "title": "Synapse Analytics and .NET for Apache Spark Example 3 - CTE()", "url": "https://the.agilesql.club/2021/01/synapse-analytics-and-.net-for-apache-spark-example-3-cte/", "published_at": "2021-01-19T16:10:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756949ec2582", "title": "Synapse Analytics and .NET for Apache Spark Example 2 - ROW_NUMBER()", "url": "https://the.agilesql.club/2021/01/synapse-analytics-and-.net-for-apache-spark-example-2-row_number/", "published_at": "2021-01-18T20:10:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694a9dbf24", "title": "Synapse Analytics and .NET for Apache Spark Example 1 - Group By", "url": "https://the.agilesql.club/2021/01/synapse-analytics-and-.net-for-apache-spark-example-1-group-by/", "published_at": "2021-01-18T19:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694adf3793", "title": "How to get data in a DataFrame via .NET for Apache Spark", "url": "https://the.agilesql.club/2021/01/how-to-get-data-in-a-dataframe-via-.net-for-apache-spark/", "published_at": "2021-01-17T19:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694ae7ae59", "title": "Git in 10 commands to do 99% of gitting and keeping out of trouble", "url": "https://the.agilesql.club/2021/01/git-in-10-commands-to-do-99-of-gitting-and-keeping-out-of-trouble/", "published_at": "2021-01-12T18:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694ba4a8e4", "title": "TF-IDF in .NET for Apache Spark Using Spark ML v2", "url": "https://the.agilesql.club/2020/12/tf-idf-in-.net-for-apache-spark-using-spark-ml-v2/", "published_at": "2020-12-19T16:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694bf4b589", "title": "Blog .NET for Apache Spark UDFs Missing Shared State", "url": "https://the.agilesql.club/2020/10/blog-.net-for-apache-spark-udfs-missing-shared-state/", "published_at": "2020-10-29T18:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694cbf9e92", "title": "TF-IDF in .NET for Apache Spark Using Spark ML", "url": "https://the.agilesql.club/2020/07/tf-idf-in-.net-for-apache-spark-using-spark-ml/", "published_at": "2020-07-07T16:10:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694d56ad3f", "title": "Approaches to running Databricks ETL code from Azure ADF", "url": "https://the.agilesql.club/2020/06/approaches-to-running-databricks-etl-code-from-azure-adf/", "published_at": "2020-06-03T20:29:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694e5216b8", "title": "The four tenets of ETL testing", "url": "https://the.agilesql.club/2020/03/the-four-tenets-of-etl-testing/", "published_at": "2020-03-06T20:29:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694ebe8188", "title": "Passing status messages and results back from Databricks to ADF", "url": "https://the.agilesql.club/2020/02/passing-status-messages-and-results-back-from-databricks-to-adf/", "published_at": "2020-02-05T19:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694f7130bf", "title": "Spark Delta Lake, Updates, Deletes and Time Travel", "url": "https://the.agilesql.club/2020/01/spark-delta-lake-updates-deletes-and-time-travel/", "published_at": "2020-01-20T19:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75694fb3541e", "title": "Validating upstream data quality in ETL processes, SQL edition", "url": "https://the.agilesql.club/2019/10/validating-upstream-data-quality-in-etl-processes-sql-edition/", "published_at": "2019-10-28T14:29:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756950091149", "title": "SQLCover 0.5 - Fixes, smaller features and an exciting surprise", "url": "https://the.agilesql.club/2019/10/sqlcover-0.5-fixes-smaller-features-and-an-exciting-surprise/", "published_at": "2019-10-16T19:21:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569506be1e1", "title": "How to test ETL Processes in production", "url": "https://the.agilesql.club/2019/10/how-to-test-etl-processes-in-production/", "published_at": "2019-10-02T03:29:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756950e56fda", "title": "How to connect spark to ms sql server without '[Error] [JvmBridge] java.sql.SQLException: No suitable driver'?", "url": "https://the.agilesql.club/2019/10/how-to-connect-spark-to-ms-sql-server-without-error-jvmbridge-java.sql.sqlexception-no-suitable-driver/", "published_at": "2019-10-01T03:29:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695181d053", "title": "How do test the upstream data is good in an etl process (etl testing part 3)?", "url": "https://the.agilesql.club/2019/09/how-do-test-the-upstream-data-is-good-in-an-etl-process-etl-testing-part-3/", "published_at": "2019-09-30T15:21:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756951b235ac", "title": "Visual Studio tSQLt Test Adapter", "url": "https://the.agilesql.club/2019/09/visual-studio-tsqlt-test-adapter/", "published_at": "2019-09-02T06:29:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756951de0dcb", "title": "Help! My Apache Spark configuration on windows isn't working (I think)", "url": "https://the.agilesql.club/2019/08/help-my-apache-spark-configuration-on-windows-isnt-working-i-think/", "published_at": "2019-08-29T04:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569521d8aee", "title": "How do you debug your spark-dotnet app in visual studio?", "url": "https://the.agilesql.club/2019/08/how-do-you-debug-your-spark-dotnet-app-in-visual-studio/", "published_at": "2019-08-20T14:29:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756952211a74", "title": "How do we prove our ETL processes are correct? How do we make sure upstream changes don't break our processes and break our beautiful data?", "url": "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/", "published_at": "2019-08-13T04:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569525440c7", "title": "spark-dotnet how to manually break a file into rows and columns", "url": "https://the.agilesql.club/2019/08/spark-dotnet-how-to-manually-break-a-file-into-rows-and-columns/", "published_at": "2019-08-06T04:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695307b358", "title": "java.lang.ClassNotFoundException: org.apache.spark.deploy.DotnetRunner with 0.4.0 of spark-dotnet", "url": "https://the.agilesql.club/2019/08/java.lang.classnotfoundexception-org.apache.spark.deploy.dotnetrunner-with-0.4.0-of-spark-dotnet/", "published_at": "2019-08-02T04:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569530db6c5", "title": "How do we test ETL pipelines? Part one unit tests", "url": "https://the.agilesql.club/2019/07/how-do-we-test-etl-pipelines-part-one-unit-tests/", "published_at": "2019-07-25T03:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756953f1ed62", "title": "spark-dotnet examples - reading and writing csv files", "url": "https://the.agilesql.club/2019/07/spark-dotnet-examples-reading-and-writing-csv-files/", "published_at": "2019-07-15T03:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756954b7451d", "title": "spark-dotnet how does user .net code run spark code in a java vm", "url": "https://the.agilesql.club/2019/07/spark-dotnet-how-does-user-.net-code-run-spark-code-in-a-java-vm/", "published_at": "2019-07-14T03:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756955379c84", "title": "Spark and dotnet in a single docker container", "url": "https://the.agilesql.club/2019/07/spark-and-dotnet-in-a-single-docker-container/", "published_at": "2019-07-11T03:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756956360818", "title": "Where do you do your database development? Hopefully not production", "url": "https://the.agilesql.club/2019/07/where-do-you-do-your-database-development-hopefully-not-production/", "published_at": "2019-07-05T04:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756956b4325e", "title": "As a DBA, how do I offload some of my work?", "url": "https://the.agilesql.club/2019/06/as-a-dba-how-do-i-offload-some-of-my-work/", "published_at": "2019-06-13T04:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756956d71341", "title": "What is the key to automated database deployments?", "url": "https://the.agilesql.club/2019/06/what-is-the-key-to-automated-database-deployments/", "published_at": "2019-06-11T05:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569575f5984", "title": "What steps are there to move to safe automated database deployments?", "url": "https://the.agilesql.club/2019/06/what-steps-are-there-to-move-to-safe-automated-database-deployments/", "published_at": "2019-06-10T05:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756957da0b02", "title": "How do you choose which columns to include in your SQL Server clustered index?", "url": "https://the.agilesql.club/2019/06/how-do-you-choose-which-columns-to-include-in-your-sql-server-clustered-index/", "published_at": "2019-06-03T04:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756958bc4051", "title": "Why is my pivot query not returning any data? How to debug a PIVOT query", "url": "https://the.agilesql.club/2019/05/why-is-my-pivot-query-not-returning-any-data-how-to-debug-a-pivot-query/", "published_at": "2019-05-21T20:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-756959609fde", "title": "How to delete a lot of data from a SQL Server database", "url": "https://the.agilesql.club/2019/05/how-to-delete-a-lot-of-data-from-a-sql-server-database/", "published_at": "2019-05-15T06:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695a5f3584", "title": "How to load test a SQL database", "url": "https://the.agilesql.club/2019/05/how-to-load-test-a-sql-database/", "published_at": "2019-05-08T20:45:20+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695af51f60", "title": "Should I pluralize table names, is it Person, Persons, People or People?", "url": "https://the.agilesql.club/2019/05/should-i-pluralize-table-names-is-it-person-persons-people-or-people/", "published_at": "2019-05-02T04:20:15+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695b645ac9", "title": "DacFx how to get the data type from a column a discussion of properties, relationships and the TSqlModel", "url": "https://the.agilesql.club/2019/04/dacfx-how-to-get-the-data-type-from-a-column-a-discussion-of-properties-relationships-and-the-tsqlmodel/", "published_at": "2019-04-17T21:20:15+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695b6cee87", "title": "How can we merge multiple dacpacs into one", "url": "https://the.agilesql.club/2019/03/how-can-we-merge-multiple-dacpacs-into-one/", "published_at": "2019-03-05T19:20:15+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695c3f93c8", "title": "SSDT: Build in VSCode", "url": "https://the.agilesql.club/2019/01/ssdt-build-in-vscode/", "published_at": "2019-01-29T00:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695cb4eb1b", "title": "SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?", "url": "https://the.agilesql.club/2019/01/ssdt-/pallowincompatibleplatform-what-platforms-are-compatible/", "published_at": "2019-01-25T00:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695cfcd3e2", "title": "minikibe on windows, getting stuck on networking issues like cant connect messages?", "url": "https://the.agilesql.club/2018-10-09/minikube-on-windows-getting-stuck-on-networking-issues-like-cant-connect/", "published_at": "2018-10-09T23:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695d49ba28", "title": "TDD for SQL Server using tSQLt course certificates now available", "url": "https://the.agilesql.club/2018/07/tdd-for-sql-server-using-tsqlt-course-certificates-now-available/", "published_at": "2018-07-18T20:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695d841f54", "title": "mentor or mentee be, be both, be neither, be happy", "url": "https://the.agilesql.club/2018/07/mentor-or-mentee-be-be-both-be-neither-be-happy/", "published_at": "2018-07-06T06:10:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695e2efe80", "title": "Deploying to Azure Without Writing JSON Arm Templates", "url": "https://the.agilesql.club/azureazureazure/2018-06-19/arm/deploying-to-azure-without-writing-json-arm-templates/", "published_at": "2018-06-19T22:47:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695e3f4dfd", "title": "Running MySQL on a VSTS build agent", "url": "https://the.agilesql.club/2018/05/running-mysql-on-a-vsts-build-agent/", "published_at": "2018-05-08T22:28:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75695f25a599", "title": "Database testing and ETL processes", "url": "https://the.agilesql.club/2018/05/database-testing-and-etl-processes/", "published_at": "2018-05-01T20:07:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696019b8df", "title": "Interesting Azure ARM \"Make it So\" behaviour", "url": "https://the.agilesql.club/2018/04/interesting-azure-arm-make-it-so-behaviour/", "published_at": "2018-04-05T06:04:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756960c0d288", "title": "Why didnt my Azure ARM deploy work?", "url": "https://the.agilesql.club/2018/04/why-didnt-my-azure-arm-deploy-work/", "published_at": "2018-04-04T18:04:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569615cef17", "title": "VSTS extensions, mixing VSS.require and import ... require", "url": "https://the.agilesql.club/2018/03/vsts-extensions-mixing-vss.require-and-import-...-require/", "published_at": "2018-03-05T21:05:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756961d77bd2", "title": "gdpr - panic part 4", "url": "https://the.agilesql.club/2018/02/gdpr-panic-part-4/", "published_at": "2018-02-08T17:22:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756962a2bce6", "title": "tSQLt Course", "url": "https://the.agilesql.club/2018/02/tsqlt-course/", "published_at": "2018-02-06T17:43:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756963304209", "title": "Re-Imagining an SSIS IDE", "url": "https://the.agilesql.club/2018/02/re-imagining-an-ssis-ide/", "published_at": "2018-02-04T22:37:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756964283058", "title": "gdpr - panic part 3", "url": "https://the.agilesql.club/2018/02/gdpr-panic-part-3/", "published_at": "2018-02-01T23:49:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756964ce05cd", "title": "gdpr - panic part 2", "url": "https://the.agilesql.club/2018/02/gdpr-panic-part-2/", "published_at": "2018-02-01T20:17:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756964e467fe", "title": "gdpr - panic part 1", "url": "https://the.agilesql.club/2018/02/gdpr-panic-part-1/", "published_at": "2018-02-01T13:57:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569655d5406", "title": "Azure ARM template function internals", "url": "https://the.agilesql.club/2017/12/azure-arm-template-function-internals/", "published_at": "2017-12-18T19:24:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569657237bb", "title": "xSQLServer is dead long live SqlServerDsc", "url": "https://the.agilesql.club/2017/12/xsqlserver-is-dead-long-live-sqlserverdsc/", "published_at": "2017-12-15T12:45:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569657e3cc7", "title": "What The Tool? Multiple choice quiz to help you choose a tool for SQL Server", "url": "https://the.agilesql.club/2017/12/what-the-tool-multiple-choice-quiz-to-help-you-choose-a-tool-for-sql-server/", "published_at": "2017-12-14T22:52:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756965b4838b", "title": "My Azure ARM template development workflow", "url": "https://the.agilesql.club/2017/12/my-azure-arm-template-development-workflow/", "published_at": "2017-12-13T22:29:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569661e2a6c", "title": "ARMED - Where is the source?", "url": "https://the.agilesql.club/2017/12/armed-where-is-the-source/", "published_at": "2017-12-09T10:45:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756966840e42", "title": "ARMED - ARM resource dependency graph inside VSCode", "url": "https://the.agilesql.club/2017/12/armed-arm-resource-dependency-graph-inside-vscode/", "published_at": "2017-12-08T23:07:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569675027ad", "title": "ARMED - Azure ARM VS Code extension", "url": "https://the.agilesql.club/2017/12/armed-azure-arm-vs-code-extension/", "published_at": "2017-12-06T22:34:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569680c64e7", "title": "Azure Virtual Machine + Premium Disk Throughput Calculator", "url": "https://the.agilesql.club/2017/12/azure-virtual-machine--premium-disk-throughput-calculator/", "published_at": "2017-12-02T19:55:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569686f1dd5", "title": "Fixing SQL AG Routing \"Cannot find host\" using packet analysis (and a spell checker)", "url": "https://the.agilesql.club/2017/11/fixing-sql-ag-routing-cannot-find-host-using-packet-analysis-and-a-spell-checker/", "published_at": "2017-11-30T13:09:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-756968ecd61c", "title": "\"the input device is not a TTY\" error running docker on VSTS build agent", "url": "https://the.agilesql.club/2017/11/the-input-device-is-not-a-tty-error-running-docker-on-vsts-build-agent/", "published_at": "2017-11-22T05:40:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696920d005", "title": "How do I use VSTS variables in YAML CI Build definitions?", "url": "https://the.agilesql.club/2017/11/how-do-i-use-vsts-variables-in-yaml-ci-build-definitions/", "published_at": "2017-11-21T21:22:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696988c63d", "title": "You have your database in source control now what?", "url": "https://the.agilesql.club/2017/11/you-have-your-database-in-source-control-now-what/", "published_at": "2017-11-16T08:02:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696a3493b9", "title": "Running any AzureRM powershell command tells you to \"Run Login-AzureRmAccount to login.\" even though you are logged in!", "url": "https://the.agilesql.club/2017/11/running-any-azurerm-powershell-command-tells-you-to-run-login-azurermaccount-to-login.-even-though-you-are-logged-in/", "published_at": "2017-11-15T12:40:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696b1ff504", "title": "Watching for powershell changes and running Invoke-Pester", "url": "https://the.agilesql.club/2017/11/watching-for-powershell-changes-and-running-invoke-pester/", "published_at": "2017-11-14T22:16:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696b3f0203", "title": "SSDT How To Fix Error SQL17502", "url": "https://the.agilesql.club/2017/11/ssdt-how-to-fix-error-sql17502/", "published_at": "2017-11-06T06:51:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696b9434db", "title": "A virtualized CPU forced me to eat my lunch early, every day, for weeks", "url": "https://the.agilesql.club/2017/10/a-virtualized-cpu-forced-me-to-eat-my-lunch-early-every-day-for-weeks/", "published_at": "2017-10-21T20:59:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696c077d01", "title": "Where do you install tSQLt?", "url": "https://the.agilesql.club/2017/10/where-do-you-install-tsqlt/", "published_at": "2017-10-19T18:00:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696d0572db", "title": "tSQLt Test Adapter for Visual Studio 2017", "url": "https://the.agilesql.club/2017/10/tsqlt-test-adapter-for-visual-studio-2017/", "published_at": "2017-10-03T19:08:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696e006686", "title": "Learn how to unit test SQL Server T-SQL code", "url": "https://the.agilesql.club/2017/09/learn-how-to-unit-test-sql-server-t-sql-code/", "published_at": "2017-09-05T05:37:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696ea0264a", "title": "SSIS ForEach Enumerator File Order", "url": "https://the.agilesql.club/2017/09/ssis-foreach-enumerator-file-order/", "published_at": "2017-09-04T20:46:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696f6c38fa", "title": "K-SSIS-ed", "url": "https://the.agilesql.club/2017/08/k-ssis-ed/", "published_at": "2017-08-17T16:32:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-75696fb00485", "title": "SQLCover", "url": "https://the.agilesql.club/2017/08/sqlcover/", "published_at": "2017-08-17T16:32:00+00:00" }, { "id": "01a087eb-eea3-7276-b107-7569706f24e4", "title": "SSDT-Dev-Pack", "url": "https://the.agilesql.club/2017/08/ssdt-dev-pack/", "published_at": "2017-08-17T16:32:00+00:00" } ] posts Claim your blog
Back to the.agilesql.club
Blog · corpus.blog/blogs/the.agilesql.club/posts

the.agilesql.club

the.agilesql.club

2026

Runing tSQLt Tests with Claudeoriginal ↗
14 Jan 2026

2025

tSQLt Test Adapter for Visual Studio 2022+original ↗
30 Dec 2025
Github Copilot in SSMS can include data in its memory, simple prompt injections aheadoriginal ↗
15 Nov 2025
Delta Lake over Spark Connectoriginal ↗
18 Jun 2025
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publishoriginal ↗
15 Jun 2025

2024

Spark Connect Dotnet November 2024 Where are we?original ↗
16 Nov 2024
Spark Connect Dotnet Variant Data Typeoriginal ↗
12 Oct 2024
Delta Lake from .NET in a Spark Connect gRPC worldoriginal ↗
17 Feb 2024
Apache Spark from PHP - it is not just a .NET thingoriginal ↗
10 Feb 2024
Implementing functions and more fun in Spark Connect using gRPC and .NEToriginal ↗
10 Feb 2024
Moving towards the DataFrame API using the Spark Connect gRPC API in .NEToriginal ↗
5 Feb 2024
Exploring the Spark Connect gRPC API moreoriginal ↗
1 Feb 2024
Exploring the Spark Connect gRPC APIoriginal ↗
26 Jan 2024
Using Spark Connect from .NET to run Spark jobs on Databricksoriginal ↗
23 Jan 2024
Spark Connect Dotnet First Major Milestoneoriginal ↗
17 Jan 2024
Using Spark Connect from .NEToriginal ↗
17 Jan 2024
Spark Connectoriginal ↗
1 Jan 2024

2021

Privacy Policyoriginal ↗
17 Mar 2021
ADF: Error trying to debug pipeline: BadRequestoriginal ↗
12 Mar 2021
ADF: Querying JSON documentsoriginal ↗
26 Feb 2021
ADF, XML objects and XPath in the expression languageoriginal ↗
12 Feb 2021
Synapse Analytics and .NET for Apache Spark Example 4 - JOINSoriginal ↗
25 Jan 2021
Synapse Analytics and .NET for Apache Spark Example 3 - CTE()original ↗
19 Jan 2021
Synapse Analytics and .NET for Apache Spark Example 2 - ROW_NUMBER()original ↗
18 Jan 2021
Synapse Analytics and .NET for Apache Spark Example 1 - Group Byoriginal ↗
18 Jan 2021
How to get data in a DataFrame via .NET for Apache Sparkoriginal ↗
17 Jan 2021
Git in 10 commands to do 99% of gitting and keeping out of troubleoriginal ↗
12 Jan 2021

2020

TF-IDF in .NET for Apache Spark Using Spark ML v2original ↗
19 Dec 2020
Blog .NET for Apache Spark UDFs Missing Shared Stateoriginal ↗
29 Oct 2020
TF-IDF in .NET for Apache Spark Using Spark MLoriginal ↗
7 Jul 2020
Approaches to running Databricks ETL code from Azure ADForiginal ↗
3 Jun 2020
The four tenets of ETL testingoriginal ↗
6 Mar 2020
Passing status messages and results back from Databricks to ADForiginal ↗
5 Feb 2020
Spark Delta Lake, Updates, Deletes and Time Traveloriginal ↗
20 Jan 2020

2019

Validating upstream data quality in ETL processes, SQL editionoriginal ↗
28 Oct 2019
SQLCover 0.5 - Fixes, smaller features and an exciting surpriseoriginal ↗
16 Oct 2019
How to test ETL Processes in productionoriginal ↗
2 Oct 2019
How to connect spark to ms sql server without '[Error] [JvmBridge] java.sql.SQLException: No suitable driver'?original ↗
1 Oct 2019
How do test the upstream data is good in an etl process (etl testing part 3)?original ↗
30 Sept 2019
Visual Studio tSQLt Test Adapteroriginal ↗
2 Sept 2019
Help! My Apache Spark configuration on windows isn't working (I think)original ↗
29 Aug 2019
How do you debug your spark-dotnet app in visual studio?original ↗
20 Aug 2019
How do we prove our ETL processes are correct? How do we make sure upstream changes don't break our processes and break our beautiful data?original ↗
13 Aug 2019
spark-dotnet how to manually break a file into rows and columnsoriginal ↗
6 Aug 2019
java.lang.ClassNotFoundException: org.apache.spark.deploy.DotnetRunner with 0.4.0 of spark-dotnetoriginal ↗
2 Aug 2019
How do we test ETL pipelines? Part one unit testsoriginal ↗
25 Jul 2019
spark-dotnet examples - reading and writing csv filesoriginal ↗
15 Jul 2019
spark-dotnet how does user .net code run spark code in a java vmoriginal ↗
14 Jul 2019
Spark and dotnet in a single docker containeroriginal ↗
11 Jul 2019
Where do you do your database development? Hopefully not productionoriginal ↗
5 Jul 2019
As a DBA, how do I offload some of my work?original ↗
13 Jun 2019
What is the key to automated database deployments?original ↗
11 Jun 2019
What steps are there to move to safe automated database deployments?original ↗
10 Jun 2019
How do you choose which columns to include in your SQL Server clustered index?original ↗
3 Jun 2019
Why is my pivot query not returning any data? How to debug a PIVOT queryoriginal ↗
21 May 2019
How to delete a lot of data from a SQL Server databaseoriginal ↗
15 May 2019
How to load test a SQL databaseoriginal ↗
8 May 2019
Should I pluralize table names, is it Person, Persons, People or People?original ↗
2 May 2019
DacFx how to get the data type from a column a discussion of properties, relationships and the TSqlModeloriginal ↗
17 Apr 2019
How can we merge multiple dacpacs into oneoriginal ↗
5 Mar 2019
SSDT: Build in VSCodeoriginal ↗
29 Jan 2019
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?original ↗
25 Jan 2019

2018

minikibe on windows, getting stuck on networking issues like cant connect messages?original ↗
9 Oct 2018
TDD for SQL Server using tSQLt course certificates now availableoriginal ↗
18 Jul 2018
mentor or mentee be, be both, be neither, be happyoriginal ↗
6 Jul 2018
Deploying to Azure Without Writing JSON Arm Templatesoriginal ↗
19 Jun 2018
Running MySQL on a VSTS build agentoriginal ↗
8 May 2018
Database testing and ETL processesoriginal ↗
1 May 2018
Interesting Azure ARM "Make it So" behaviouroriginal ↗
5 Apr 2018
Why didnt my Azure ARM deploy work?original ↗
4 Apr 2018
VSTS extensions, mixing VSS.require and import ... requireoriginal ↗
5 Mar 2018
gdpr - panic part 4original ↗
8 Feb 2018
tSQLt Courseoriginal ↗
6 Feb 2018
Re-Imagining an SSIS IDEoriginal ↗
4 Feb 2018
gdpr - panic part 3original ↗
1 Feb 2018
gdpr - panic part 2original ↗
1 Feb 2018
gdpr - panic part 1original ↗
1 Feb 2018

2017

Azure ARM template function internalsoriginal ↗
18 Dec 2017
xSQLServer is dead long live SqlServerDscoriginal ↗
15 Dec 2017
What The Tool? Multiple choice quiz to help you choose a tool for SQL Serveroriginal ↗
14 Dec 2017
My Azure ARM template development workfloworiginal ↗
13 Dec 2017
ARMED - Where is the source?original ↗
9 Dec 2017
ARMED - ARM resource dependency graph inside VSCodeoriginal ↗
8 Dec 2017
ARMED - Azure ARM VS Code extensionoriginal ↗
6 Dec 2017
Azure Virtual Machine + Premium Disk Throughput Calculatororiginal ↗
2 Dec 2017
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)original ↗
30 Nov 2017
"the input device is not a TTY" error running docker on VSTS build agentoriginal ↗
22 Nov 2017
How do I use VSTS variables in YAML CI Build definitions?original ↗
21 Nov 2017
You have your database in source control now what?original ↗
16 Nov 2017
Running any AzureRM powershell command tells you to "Run Login-AzureRmAccount to login." even though you are logged in!original ↗
15 Nov 2017
Watching for powershell changes and running Invoke-Pesteroriginal ↗
14 Nov 2017
SSDT How To Fix Error SQL17502original ↗
6 Nov 2017
A virtualized CPU forced me to eat my lunch early, every day, for weeksoriginal ↗
21 Oct 2017
Where do you install tSQLt?original ↗
19 Oct 2017
tSQLt Test Adapter for Visual Studio 2017original ↗
3 Oct 2017
Learn how to unit test SQL Server T-SQL codeoriginal ↗
5 Sept 2017
SSIS ForEach Enumerator File Orderoriginal ↗
4 Sept 2017
K-SSIS-edoriginal ↗
17 Aug 2017
SQLCoveroriginal ↗
17 Aug 2017
SSDT-Dev-Packoriginal ↗
17 Aug 2017
Next