Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...
2023-12-01 (first published: 2023-11-17)
242 reads
A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....
2023-12-01 (first published: 2023-11-20)
337 reads
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...
2023-11-29 (first published: 2023-11-15)
209 reads
This is not a “clickbait” title, but an important consideration when it comes to developing technical solutions. Let me give you an example between two questions for SQL Server...
2023-11-29 (first published: 2023-11-17)
241 reads
Force parameterization in Microsoft SQL Server is a feature designed to optimize query performance by converting literal values in Transact-SQL statements into parameters. This process helps in plan reuse,...
2023-11-27 (first published: 2023-11-13)
371 reads
With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and...
2023-11-27 (first published: 2023-11-16)
570 reads