Stephen Green

Scot-Canadian living in the USA have traveled the globe. I spend most of my time playing with my dogs, doing kung fu (I teach) and learning lots of SQL work.

[Brent Ozar @BrentO]

Reading: Transact-SQL Formatting Standards (Coding Styles): https://t.co/RLw7OcK5zn Not a set of rigid rules, just a discussion.

[MSSQLTips - Free Daily #SQLServer Tips @mssqltips]

https://t.co/s4TdSQI6BY

[Stephen Green @SQLxStephen]

Can swear by this as well

[Kendra Little @Kendra_Little]

I just learned about AutoHotkey for Windows and how did I not know about this before?!?!?

https://t.co/IdplEuz7FJ

[MSSQLTips - Free Daily #SQLServer Tips @mssqltips]

https://t.co/zvplhuEO2e

[SQLServerCentral @SQLServerCentrl]

Answer today's question: The OPENJSON return schema https://t.co/82SLq7icC3

[Stephen Green @SQLxStephen]

@Kendra_Little @MelisInSQLland Might want to try getting a RoboRock. The 7 just came out and it is truly a wonderful time saving robot vacuum. We have 3 big dogs and my wife absolutely loves how thorough this device is. https://t.co/ARiDPn7Le9

[Stephen Green @SQLxStephen]

@wehackpurple

[Semgrep Community! @semgrepcommunit]

what the lesson here folks?

[SQLServerCentral @SQLServerCentrl]

Check out this book: Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries https://t.co/GirCAqr8mf

[Stephen Green @SQLxStephen]

@SQLBob

[Stephen Green @SQLxStephen]

@BrentO Yes but does that Whale understand window functions?

[Stephen Green @SQLxStephen]

@SqlEmt CTRL+K,CTRL+\ - Removes all white space from the selected text. I am super crazy about formatting, this helps that so much.

[Stephen Green @SQLxStephen]

@Pittfurg Remember to always save some time just for YOU. I have been under that personal/professional gun so many times but sanity stays when you have that calm island that you can retreat to when you really need it.

[Stephen Green @SQLxStephen]

This man is worth the time to listen to especially when it comes to industry jargon put into real world terms. He knows what works for SQL Server. Mark your calendars.

[Brent Ozar @BrentO]

[Blog] Mark Your Calendars: Free Live SQL Server Training Classes in October & November. https://t.co/AvGn9Z56uV

[Steve Stedman @SqlEmt]

Using a CTE in a Function to Split Up a Database Connect String https://t.co/Q74r8P2K4o

[Stephen Green @SQLxStephen]

@BrentO Whatever you do, do not let your wife read/watch Outlander. You'll be moving there next month.

[Stephen Green @SQLxStephen]

Just remember folks that there is a https://t.co/s70iwRh60z reddit group. For those, like me, that enjoy seeing light bulbs go off for people, its a wonderful place to interact.

[Stephen Green @SQLxStephen]

@Kendra_Little Since you are traveling and with the dogs and since you are a dog person my friend sent me this. Its held last weekend every year in Minnesota. Basset hound racing. https://t.co/Pzpyvnhpad

[Stephen Green @SQLxStephen]

Awesome write up on lambdas AWS and postgres. I wish I had known this a year ago. https://t.co/DLTkxkdWhT