We are at PASS Summit 2018 in Seattle, and I will write a bit about each day I’m here, just because it might be useful. Or, in a year or two, nostalgic. Or just to have something like letters from camp: “Hi there, internet friends, today at camp it rained some more, and I talked to 30 new friends, and I got a squishy stress ball from the vendor in the next booth…”
Author: Jen McCown
Regular Expressions: tagging expressions
I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take a minute to define regular expressions, explain tagged expressions, and then show you how to use it in the same line. But first, XKCD: Regular Expressions defined “A regular expression, regex or regexp [is]… a sequence of characters that define a search pattern. Usually this pattern […]
sqlhelp: limit the x-axis of a geometry line graph
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide a range for the X-axis, for a large variance of Y-axis values. Is there a way to limit the X-axis range? Update: We have an answer! Thanks MJ! Yeah, the spatial results tab is pretty […]