I met Bryan Oliver of Solid Quality Mentors expecting a proud expert, and found an extremely friendly and knowledgeable person. Some wisdom I learned from him.
SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian
Getting NULL when reading a value from XML? Most of the time the XPath expression is wrong. A guest post by Jacob Sebastian on writing it correctly.
geometry STIsValid: Parsed Shapes Still Need a Validity Check
geometry STIsValid checks whether a spatial instance satisfies the validity rules for its geometry type. I use two parsed lines to separate those questions. Successful construction alone does not establish that a shape is valid.
SQL SERVER – TRANSACTION, DML and Schema Locks
Most candidates in a senior developer interview could not create a scenario that shows schema locks. Here is a simple demo with a TRANSACTION and DML.
How to Learn a New SQL Server Release Quickly
Evaluate new SQL Server features with a focused reading plan, version checks, three relevant experiments, and a record of operational tradeoffs.
Sequence Gaps: Why NEXT VALUE FOR Skips Numbers
Explain sequence gaps, inspect cached values, test rollback behavior, and separate SQL Server identifiers from gapless numbering.
SQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver
SQL Server MVP Madhivanan has left over 1000 helpful comments on this blog. In this interview he talks about his work and his life outside SQL.