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

31 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)

370 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

32 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

149 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

142 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

33 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

9 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

Interview with Greg Low

by damianwidera

Coding Family

This is the sixth interview we have done. This time our guest is Greg Low! I bet you know Greg as he is one of the most recognizable person...

2019-09-27 (first published: 2019-09-17)

243 reads

Blog Posts

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

Interview with Greg Low

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

The Book of Redgate: Taking Breaks

Database AI Agents: The Read-Only Rule

Forums

Liability for AI Errors

Running a Parameter-Sensitive Stored Procedure on a Secondary Replica

Pro SQL Server Internals

Question of the Day

Running SQLCMD II