Blog Posts

In the first two parts of this series (https://the.agilesql.club/2019/07/how-do-we-test-etl-pipelines-part-one-unit-tests/ and 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/), I talked about how to unit test your business logic and integration test your ETL infrastructure code. Having...

2019-09-30

23 reads

How do test the upstream data is good in an etl process (etl testing part 3)?

by Ed Elliott

Ed Elliott's Sql Developer Blog

2019-09-30

4 reads

Restoring Backups from Azure Blob with dbatools

by Anthony Nocentino

Anthony Nocentino Blog

Recently I needed to write a PowerShell script that could build a backup set from a collection of backups stored in Azure Blob Storage without any backup history available...

2019-09-30 (first published: 2019-09-15)

357 reads

See SQL Run 2

by Kenneth Fisher

SQLStudies

Note: I am perfectly aware of my ability as an artist so let the ribbing begin ??

2019-09-30

31 reads

Speaking on New SQL Server Performance Tuning Techniques – SQL User Group

by Prakash Heda

SQLFeatures

Prakash will talk about some of the coolest new features of SQL Server for performance tuning which you can use to quickly troubleshoot & improve performance.

2019-09-30

142 reads

Using the SSIS Error Output On the Data Flow

by Tim Mitchell

Tim Mitchell

When working in the SSIS data flow, you’ll notice that many sources and transformations and some destinations have a built-in output to handle errors. The error output allows the...

2019-09-30

139 reads

Memory Settings for Running SQL Server in Kubernetes

by Anthony Nocentino

Anthony Nocentino Blog

People often ask me what’s the number one thing to look out for when running SQL Server on Kubernetes…the answer is memory settings. In this post, we’re going to...

2019-09-28

22 reads

Memory Settings for Running SQL Server in Kubernetes

by Anthony Nocentino

Anthony Nocentino Blog

People often ask me what’s the number one thing to look out for when running SQL Server on Kubernetes…the answer is memory settings. In this post, we’re going to...

2019-09-28

6 reads

2019-09-26T14:10:42+00:00

by Sheldon Hull

Sheldon Hull

TEST You know you are a dad when you start looking at a minivan as a really cool vehicle and marvel at all the features that have zilch to...

2019-09-27

9 reads

Humbled

by Grant Fritchey

The Scary DBA

I’ve received several notes of thanks over the last couple of weeks. I’m not sure exactly what’s prompted this sudden outpouring because it’s all been about stuff I’ve done...

2019-09-27

38 reads

Blog Posts

How do test the upstream data is good in an etl process (etl testing part 3)?

How do test the upstream data is good in an etl process (etl testing part 3)?

Restoring Backups from Azure Blob with dbatools

See SQL Run 2

Speaking on New SQL Server Performance Tuning Techniques – SQL User Group

Using the SSIS Error Output On the Data Flow

Memory Settings for Running SQL Server in Kubernetes

Memory Settings for Running SQL Server in Kubernetes

2019-09-26T14:10:42+00:00

Humbled

Blogs

Git forked

Setting FK Constraints in Data Modeler

Webinar: Navigating the Database Landscape in 2026

Forums

SSMS 22 Latest Update Crashing

Transactional Replication setup issue

The Power of Data and Privacy

Question of the Day

What's the Date?