Stephen Green
@SQLxStephen
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.
You might like
Reading: Transact-SQL Formatting Standards (Coding Styles): red-gate.com/simple-talk/da… Not a set of rigid rules, just a discussion.
red-gate.com
Transact-SQL Formatting Standards (Coding Styles)
How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How should lists be lined up? SQL is one of those languages that will execute anyway...
Can swear by this as well
I just learned about AutoHotkey for Windows and how did I not know about this before?!?!? autohotkey.com
mssqltips.com
SQL SELECT INTO Advanced Topics
In this article we look at more ways to create a new SQL Server table using SELECT INTO as well as some specific nuances you should be aware of.
Check out this book: Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries ow.ly/2qKb30rTcrK
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.
[Blog] Mark Your Calendars: Free Live SQL Server Training Classes in October & November. brentozar.com/archive/2021/0…
Using a CTE in a Function to Split Up a Database Connect String ift.tt/3jKhoaT
Just remember folks that there is a reddit.com/r/IWantToTeach/ reddit group. For those, like me, that enjoy seeing light bulbs go off for people, its a wonderful place to interact.
Awesome write up on lambdas AWS and postgres. I wish I had known this a year ago. towardsaws.com/sql-triggers-w…
"Hey, why is your keyboard covered with blood?"
Job Duties for Database Developers, Development DBAs, and Production DBAs: brentozar.com/archive/2018/0… When I hear people say "the cloud is replacing DBAs," folks are usually referring to the production DBA role.
Hey, Stalwarts! #DPS2021 price increases in 24 hours. Kindly RT to help us spread the word. Book a Training Class and get the Summit pass complimentary. bit.ly/dps_2021 Also, get all the recordings (Summit Sessions + Class). #Analytics #datascience #AzureSQL #PowerBI
mssqltips.com
Getting Started with Azure Data Factory - Part 1
In this article we walk thru steps of how to get started with Azure Data Factory and build a simple pipeline in ADF.
Wondering if anyone has a link to a good walkthrough on consuming and API through SSIS that uses Oauth2 and outputs to a table in SQL Server.
United States Trends
- 1. Halloween 3.03M posts
- 2. #DoorDashTradeorTreat 1,487 posts
- 3. #sweepstakes 2,582 posts
- 4. #smackoff 1,941 posts
- 5. #SwapSilently 8,524 posts
- 6. Jessica Lange 37.7K posts
- 7. Disney 99.8K posts
- 8. YouTube TV 80.5K posts
- 9. ESPN 79.9K posts
- 10. Hulu 23.7K posts
- 11. Monangai 1,399 posts
- 12. Trick or Treat 442K posts
- 13. Coven 11.9K posts
- 14. Candy 247K posts
- 15. YTTV 2,464 posts
- 16. Mark in Hollywood N/A
- 17. Julia Fox 2,082 posts
- 18. Fubo 3,970 posts
- 19. Sicario 3,836 posts
- 20. #jimromeonx N/A
Something went wrong.
Something went wrong.