I’ve been discussing the “schemaless” view of NoSQL with some fellow developers and have been tweeting a bit about it and yesterday I started to read a new book: “NoSQL Distilled – A brief guide to the emerging world of polygot persistence, Pramod J.Sadalage & Martin Fowler (2013)” (Sadalage &am…
Daniel Wertheim
This is a scary T-SQL post with some ugly code and unfriendly variables as the result of a quick hack to answer a StackOverflow question [http://stackoverflow.com/questions/13761768/how-to-find-column-and-table-name-using-columns-value-in-sql-server/13763701#13763701] : > In T-SQL, if just know…
Daniel Wertheim
This week I saw a tweet from Julie Lerman [https://twitter.com/julielerman/status/273811980660404224] (@julielerman) which caught my interest: The error report found here [http://connect.microsoft.com/VisualStudio/feedback/details/772444/sql-server-object-explorer-locks-databases#tabs] , says: &…
Daniel Wertheim
> The N+1 is evil. I want referential integrity. I want... "Hold it right there Mr!" A document-oriented Db (DOD) is not an RDBMS! If you are having an N+1 scenario or feeling a pain with references, you should probably first have a look at your model and your chosen data-persistence…
Daniel Wertheim
Now it’s time to have a quick peak on this whole “schema-less” thing that NoSQL products offer. We will of course focus on MongoDB when we compare a document-oriented DB against a more traditional, relational DB commonly found in RDBMS like SQL Server. Previous articles are: * Getting started (ag…
Daniel Wertheim