Azure Cosmos DB – Partition and Throughput

In my previous article Introduction to Azure Cosmos DB, I mentioned Partition and Throughput only briefly. Adopting a good partition scheme...

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...

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...

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...

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...

Is Your DR Plan Complete?

Kevin Hill (blog|twitter) posted a thought-provoking item on his blog last week about Disaster Recovery Plans. While I am in the 10% who perform DR tests for basic functionality...

Should You Use Index Hints?

Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...

SQL Reserved vCores

Have you ever heard of SQL Reserved vCores? Well I never until recently.  With this concept you have the ability...

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...