News & Opinion
So, uh, you can, like, draw me in SSMS.
Adrian Sullivan and Michael J. Swart have way too much time on their hands, because Adrian just posted this T-SQL gist, which draws … me:
It uses the spatial results feature in SSMS. My mind is blown. I’m totally going to use that in a demo. Thanks, Adrian!
I’m already envisioning all kinds of crazy ways I could use this, like…if you completely pass sp_Blitz with flying colors, hahaha.
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.
That’s awesome, but I got this error when Always Encrypted was enabled: Line 1, column 1
The current script is too large for Parameterization for Always Encrypted, please disable Parameterization for Always Encrypted in Query Options (Query > Query Options > Execution > Advanced). Maximum allowable length: 300000 characters, Current script length: 847259 characters
John – ok, give me a minute while I open the SQL Server source code and fix that for you.
Oh wait I forgot. I’m not Microsoft! Silly me. I make that mistake all the time. My bad. When you hit a bug in SQL Server, your best bet is to work with the blue badge folks. 😉
Brent – I just thought it was interesting and was sharing. I’m not worried about the bug.
Awesome work, fixed case-sensetive insance and add some formating in code (replace double spaces, aligen keywords, added semicolons) https://gist.github.com/ktaranov/0d739625aad6a48a9e32c8987e60b91c
Some might think this is a waste of time. But it got me to review the Spatial data types in Sql and do a review of Geography data type and functions. Thank you!
Great work
Here’s a link to the process I followed to generate this.
https://www.linkedin.com/pulse/simple-guide-drawing-sql-server-ssms-technical-article-sullivan
Redid Brent as well, and added to Github, https://github.com/SQLAdrian/drawingWithSSMS