Weekly reading #27
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-01
27 reads
Blog Posts
Why Does Everyone Have More Friends Than You?
No, the answer isn’t because you’re a DBA. This isn’t a technical post about databases, but rather a discussion of a statistical paradox that I read about recently. Statistics...
2019-10-01
40 reads
DBA Myths: CHECKDB runs on startup.
If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for ... Continue reading
2019-09-30 (first published: 2019-09-16)
581 reads
Download Power BI Audit Logs with the New Get-PowerBIActivityEvent cmdlet
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-PowerBIActivityEvent. The...
2019-09-30
13 reads
Download Power BI Audit Logs with the New Get-PowerBIActivityEvent cmdlet
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-PowerBIActivityEvent. The...
2019-09-30
296 reads
How do test the upstream data is good in an etl process (etl testing part 3)?
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
6 reads
How do test the upstream data is good in an etl process (etl testing part 3)?
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
24 reads
Restoring Backups from Azure Blob with dbatools
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)
359 reads
2019-09-30
32 reads
Speaking on New SQL Server Performance Tuning Techniques – SQL User Group
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
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
What Are You Waiting For?
Comments posted to this topic are about the item What Are You Waiting For?
BCA KCU KELAPA GADING Tlpn/Wa:628213111185
Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1, 9...
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers