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.
Вам может понравиться
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...
mssqltips.com
Verbose Truncation Warnings for INSERT Statements in SQL Server 2019
Learn about the more useful and helpful truncation error messages available in SQL Server 2019 when trying to insert data into a table.
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.
Answer today's question: The OPENJSON return schema ow.ly/LfsO30rUwa5
what the lesson here folks?
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…
the guy she told you not to worry about
"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 Тренды
- 1. Halloween 2.27M posts
- 2. YouTube TV 74.8K posts
- 3. ESPN 72.3K posts
- 4. JESSICA LANGE 13.9K posts
- 5. Hulu 23K posts
- 6. Grier 12.5K posts
- 7. Evan Peters 9,302 posts
- 8. YTTV 1,767 posts
- 9. ryan murphy 2,813 posts
- 10. Trick 615K posts
- 11. Ridiculousness 3,262 posts
- 12. McDaniel 13.2K posts
- 13. coven 4,777 posts
- 14. Fubo 2,901 posts
- 15. Travis Hunter 3,090 posts
- 16. Dearborn 13.6K posts
- 17. Elmo 17.6K posts
- 18. #FursuitFriday 12.2K posts
- 19. Auda City 3,917 posts
- 20. DirecTV 1,610 posts
Something went wrong.
Something went wrong.