A Fine Slice Of SQL Server
Osheen MacOscar forces me into alliteration:
So far, in the previous blog we covered creating our package with Poetry, managing our development environment and adding a function. In the current blog post we’ll be covering the next steps with package development including documentation, testing and how to publish to PyPI.
Read on for several tips on making Python code package-ready and then how to distribute it via PyPi.
Leave a CommentJon Vöge declares a hostile takeover:
Now, how you best maintain multiple copies/variants of the same Semantic Model is a whole other discussion but as a one-off, I was asked to merge the Measures of the two models.
Initially, the question actually stumped me as my usual tool of choice for external manipulation of semantic models Tabular Editor does not have a great native way to solve this.
Jon lists a variety of options and then gets the job done with ALM Toolkit.
Leave a CommentKoen Verbeeck tries out a function:
I have data coming into my SQL Server database as JSON. Before I start parsing it which is quite intensive, I need to check if some values are present in the JSON. Is there a function I can use to do this? Let’s see what the new JSON_CONTAINS function in SQL Server 2025 can do.
Read on to see how it works.
Leave a CommentJeremy Schneider doesn’t wait for a response:
Postgres database-level “synchronous replication” does not actually mean the replication is synchronous. It’s a bit of a lie really. The replication is actually – always – asynchronous. What it actually means is “when the client issues a
COMMITthen pause until we know the transaction is replicated.” In fact the primary writer database doesn’t need to wait for the replicas to catch up UNTIL the client issues aCOMMIT…and even then it’s only a single individual connection which waits. This has many interesting properties.
Click through for the pros and cons of this technical decision.
Leave a CommentSteve Jones says better late than never:
I hosted this month, late as it turns out, but we still had a few entries. Here’s a look at the blogs people published.
Read on for links to the half-dozen entrants this month, who talked about string parsing in SQL Server.
Leave a CommentRecently, I thought a database query in a plan was straightforward. It looked innocent until I noticed strange behavior. The deeper I dug, the more I realized many people might be running into the same issue with ORM queries.
Click through for a toy version of the scenario, as well as two common problems with ORM tuning: blind index acceptance (which, admittedly, is a problem with or without ORMs) and implicit conversion on filters.
Leave a Comment