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.
Talvez você curta
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 Tendências
- 1. Game 7 1,054 posts
- 2. Halloween 3.43M posts
- 3. Glasnow 4,455 posts
- 4. Barger 4,841 posts
- 5. Ja Morant 2,944 posts
- 6. Bulls 28.6K posts
- 7. Roki 6,947 posts
- 8. #LetsGoDodgers 10.1K posts
- 9. Mookie 13.5K posts
- 10. Clement 4,919 posts
- 11. Yamamoto 28K posts
- 12. #BostonBlue 4,483 posts
- 13. Teoscar 2,339 posts
- 14. #SmackDown 24.4K posts
- 15. GAME SEVEN 5,409 posts
- 16. Grizzlies 5,949 posts
- 17. Rojas 9,784 posts
- 18. Springer 10.8K posts
- 19. Joe Carter 1,288 posts
- 20. #DodgersWin 4,569 posts
Something went wrong.
Something went wrong.