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.
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…
brentozar.com
Mark Your Calendars: Free Live SQL Server Training Classes in October & November. - Brent Ozar...
This fall, I’m going to teach you the fundamentals of Microsoft database performance tuning, live, for free. The first class is my How to Think Like the Engine class. It’s already free online in both...
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…
towardsaws.com
SQL Triggers with AWS Lambda — Take Your DB to the Next Level
Relational databases are still a powerful and effective tool to define relationships between structured data points. Among all the…
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.
Take a break with A Very Simple Blocking Alert ow.ly/AyiE30rI6lB
sqlservercentral.com
A Very Simple Blocking Alert – SQLServerCentral
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
United States 趋势
- 1. Ryan Clark 2,326 posts
- 2. Prince Andrew 19.3K posts
- 3. $AMZN 44.8K posts
- 4. Scream 7 39.2K posts
- 5. Rhule 5,001 posts
- 6. Somalia 57.1K posts
- 7. #Prop50VoteYes 3,201 posts
- 8. Happy Halloween 271K posts
- 9. Sydney Sweeney 102K posts
- 10. Usha 30.5K posts
- 11. Necas 2,581 posts
- 12. Mikko 2,805 posts
- 13. Andrew Mountbatten Windsor 4,355 posts
- 14. Animal Crossing 29.6K posts
- 15. Poot 8,802 posts
- 16. Buckingham Palace 4,807 posts
- 17. NextNRG Inc 2,191 posts
- 18. 5sos 15K posts
- 19. Billie 45.2K posts
- 20. Vance 321K posts
Something went wrong.
Something went wrong.