T-SQL Tuesday # 156 Invitation: Production Code

#tsql2sday

https://straightforwardsql.com/posts/production-code/

Gino Time in the Garden. ☘
#Celtics

Finish them!
#Celtics

Halftime at TD Garden.
#Celtics

Successful volleyball weekend. 😊

Question for my tech/Microsoft friends: does the (male) coach remind you of anyone?

#Celtics

#UCF ranked 25th after beating Cincinnati

https://www.orlandosentinel.com/sports/ucf-knights/os-sp-ucf-knights-football-ap-top-25-poll-cincinnati-bearcats-gus-malzahn-20221030-cicdddsxgngafivmjj7ncztnk4-story.html

Hello, fellow volleyball parents.

Macho Man and Hulk Hogan at the #UCF game today.

There's usually a number of things to analyze and unpack after a #Celtics loss. For the last 4-5 seasons, I keep coming back to this.

Great 2nd quarter for the #Celtics. ☘

If you haven't already, check out #OstrichMode for #CoSo.

https://counter.social/settings/preferences

Wow. That was unexpectedly fast. I got my Twitter archive within 24 hours. That's much faster than it's been with previous requests.

Shamelessly stolen from Twitter.

Anyone else have a #CoSo logo on their website? No? Just me? 😎

I've added a link to my #CoSo profile on #LinkedIn.

Haaa! There's more!

The mystery character is only visible while creating/editing the gist. Upon saving, it's no longer visible. Not even when viewing Raw.

Ah, I stand corrected. I couldn't see the character in Slack, but I can see it in a Github gist.

Still, I still think that first character should be a '?'...not a mystery red dot.

How weird. A dev is trying to query a table using a string literal in a WHERE clause. But no rows are returned.

I suspected a non-printable ASCII character (codes 0 - 31) might be the issue. I copied/pasted the string literal into SSMS.

There's definitely an extra character at the left side of the string. But SQL thinks it's a question mark character, which is ASCII code 63. That's a 'visible' character...but I can't see it in SSMS, a browser, or Notepad.

I took a lot of photos over the weekend. I gotta sing the praises of the CPL filter again. It's an easy 'tech' improvement for your photos that doesn't require any special skill or talent.

*Circular Polarizing Lens
#Photography