내가 좋아할 만한 콘텐츠
Heyy Errbody!! We're back! 👋🏼 Check out what Zaliyah have for us! #infowithii #innotiiveasia #datanuggets #nuggets
As you upgrade from 11g - 12 - 19 - 23c, you WILL encounter our multitenant database architecture. Your 'single instance' is now at least 2 DBs, a container and pluggable(s). If you can't find the schema you're looking for, you're probably in the wrong database (PDB).
#Oracle #Database 23c has TONS of new features. So we'll be doing single-topic, weekly deep dives over the next few months! oracle.com/database/23c/ This Week: Kafka APIs Previously covered topics: SQL Macros JSON Relational Duality Views
Don't make this mistake as a beginner engineer: - Not learning SQL SQL databases have been around for 40+ years for a reason. Instead, focus on the following: - SQL fundamentals - Data modeling - Transactions - Indexing Master relational databases, and you'll grow 10x faster.
"Store" calculated values in Oracle Database with virtual columns CREATE TABLE ... ( ..., virtual_col AS ( <expression> ) ) The database stores the expression as metadata The result is always calculated at runtime - you can never provide your own values
Get a random selection of rows from a table in Oracle Database with SELECT ... FROM ... SAMPLE ( N ) Where N is the percent of rows to get from 0.000001 to 100 This uses statistical sampling so will return approximately N% of the data #SQL
The debut episode of Info with II is here. It's about Microsoft SQL Server 2022. Check out what @GangathrenG has to say about it. #InfoWithII #Microsoft #SQLSERVER2022 #MSSQL #DataNugget #Nuggets #InnotiveAsia
CEIL and FLOOR Support DATE, TIMESTAMP, and INTERVAL Data Types in Oracle Database 23c oracle-base.com/articles/23c/c… @OracleDatabase #oracle #database #23c #SQL
The Views Aren’t The Problem. Your Code Is. brentozar.com/archive/2020/0…
brentozar.com
Your Views Aren't The Problem. Your Code Is. - Brent Ozar Unlimited®
“I hate views,” the DBA said. “They kill performance. And nested views are even worse.” Wrong. I’ll prove it. I’m going to use the 50GB StackOverflow2013 database, and I’ll start by creating a couple...
SQL Server Management Studio 19.1 is out: learn.microsoft.com/en-us/sql/ssms… New features include restores from AWS S3, external browser instead of the built-in one, removed the Vulnerability Assessment from SSMS, pick your version of PowerShell, and more.
Like games? Want to learn #SQL? Play Lost at SQL by @robinlord8 An interactive game where you write SQL statements to escape a sinking ship! lost-at-sql.therobinlord.com
Excellent drill-down from @surajmalli into the nuts and bolts of how @OracleDatabase Online Redefinition works...
Oracle Database Online Redefinition provides a robust and flexible solution for modifying database objects without disrupting the availability and functionality of the system. blogs.oracle.com/maa/post/onlin… @hawkinsg1 @OracleMAA #oracledatabase #maa #developers #onlineredefinition
Warning: if you're running SQL Server 2022 and you enable both Query Store AND Parameter-Sensitive Plan Optimization, you may get memory dumps every 15 minutes. The workaround is to disable one of those two features: feedback.azure.com/d365community/… Related: brentozar.com/archive/2023/0…
brentozar.com
It's Been 6 Months. SQL Server 2022 Still Isn't Ready Yet. (Updated) - Brent Ozar Unlimited®
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still isn’t ready. See, look at the very first hero in their list of 2022’s new features: The very...
🎥 Exciting news! Introducing 'Info with II,' a new video segment all about databases! 🌟 Join us on the new adventure. Please watch this space for the debut episode tomorrow! #InfoWithII #DatabaseExploration #StayInformed
Two important things to know about the DB ranking engine (@DBEngines) db-engines.com/en/ranking_tre…
"If physical location were ever a determining factor for your team, now’s the time to put that idea to bed. Location is absolutely irrelevant." @renniksn shares his tips for #leadership in the age of #remotework: oracl.info/kRZM50zRLr2 #CX
"MEET THE ORACLE MASTERS: THE ONLINE SERIES – Wednesday, June 3, Qualogy is organizing a live, online presentation by Oracle Master Connor McDonald. Register now for his presentation ‘The features of Oracle Database 18c, 19c and 20c’ for free. bit.ly/oracle-masters "
The default filegroup, and why you should care. via @sqlstudent144 #sqlbp #bestpractices #sqlfamily sqlbp.com/sqlserver/the-…
Automate SQL Server error log alerting with Minion Enterprise via @HeyMinionWare #sqlbp #bestpractices #sqlfamily sqlbp.com/sqlserver/auto…
Youtube greatest hits :-) Perhaps we should focus on LESS features not more. youtube.com/watch?v=o7S-HV… #oracle #18c #19c #features
United States 트렌드
- 1. Nuss 4,656 posts
- 2. #AEWCollision 7,754 posts
- 3. Lagway 2,639 posts
- 4. Hawks 15.2K posts
- 5. Cam Coleman 3,732 posts
- 6. Ty Simpson 2,450 posts
- 7. Vandy 5,646 posts
- 8. Iowa 31K posts
- 9. Jeremiyah Love 1,310 posts
- 10. Watford 1,911 posts
- 11. Auburn 15.3K posts
- 12. #UFCVegas111 12.9K posts
- 13. DEANDRE HUNTER N/A
- 14. Bama 10.5K posts
- 15. #Isles 1,939 posts
- 16. Heisman 14.1K posts
- 17. Stoops 1,036 posts
- 18. Rangers 12K posts
- 19. Wisconsin 18.4K posts
- 20. Ace Austin 1,462 posts
내가 좋아할 만한 콘텐츠
Something went wrong.
Something went wrong.