Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties

Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours...

Advance Your Business by Embracing Cloud Technologies

Advance Your Business by Embracing Cloud Technologies In a rapidly shifting economic landscape filled with supposed cost-cutting strategies, no solution...

Dedupe Google Drive with RClone

An issue with duplicates
I migrated from Amazon Cloud Drive to a paid Google Drive account. To facilate this move, I used a paid service called MultCloud. For me, Comcast...

Moneyball And The DBA

“Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the...

Format a Partial Script with #SQLPrompt

SQL Prompt is amazing and it’s my favorite tool. It’s actually what many people want first from Redgate because it...

Performance Basics: Indexed views

Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...

Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'

Error: Generic error:  ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'Resolution:setTimeout the code that is setting the value. In my case,...

Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'

Error: Generic error:  ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'

Resolution:

setTimeout the...

Announcing new Guatemala SQL Server user group

I am very happy to announce that after a long time struggling and filling all the requirements, we were able...

Take the SQLChallenge: Tuning a Stored Procedure

I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...