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

37 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

37 reads

Download Power BI Audit Logs with the New Get-PowerBIActivityEvents cmdlet

by Aaron Nelson

SQLvariant

Earlier this week a new version of the MicrosoftPowerBIMgmt module was made available on the PowerShell Gallery. Two new cmdlets were included in the module Remove-PowerBIReport and Get-PowerBIActivityEvents. The...

2019-10-07 (first published: 2019-09-30)

641 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

151 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

38 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

14 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-10-04 (first published: 2019-09-28)

919 reads

Pre-Con in Denver

by Steve Jones

The Voice of the DBA

As prep for our pre-con at the PASS Summit, Kendra and I are presenting a pre-con at the Denver SQL Saturday#908, on Friday, October 11, 2019. We’ll be talking...

2019-09-27

77 reads

HammerDB for Azure SQL DB

by John

John Morehouse | Sqlrus.com

Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to...

2019-10-03 (first published: 2019-09-27)

781 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

41 reads

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

See SQL Run 2

Download Power BI Audit Logs with the New Get-PowerBIActivityEvents cmdlet

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

Memory Settings for Running SQL Server in Kubernetes

Pre-Con in Denver

HammerDB for Azure SQL DB

Humbled

Blogs

A New Word: Dorgone

Tell It Once: Setting Up Claude With Skills and MCP Servers

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

Forums

Make It Routine

Finding Gaps in Sequential Data Using SQL Server

Negative and Positive Numbers

Question of the Day

Negative and Positive Numbers