คุณอาจชื่นชอบ
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
blogs.oracle.com
Exploring the Nuts and Bolts of DBMS Online Redefinition
Exploring the Nuts and Bolts of DBMS Online Redefinition
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. White House 118K posts
- 2. #pilotstwtselfieday N/A
- 3. NASA 60.7K posts
- 4. #Integra 1,096 posts
- 5. #hoothoot N/A
- 6. Fermin 12.3K posts
- 7. Warner Bros 6,886 posts
- 8. #JUNGKOOKXCALVINKLEIN 48.7K posts
- 9. Rick Scott 1,949 posts
- 10. Kurt Suzuki N/A
- 11. Crosby 3,253 posts
- 12. #3YearsOfMidnights N/A
- 13. NBA IS BACK 26.9K posts
- 14. East Wing 107K posts
- 15. Taco Tuesday 14.1K posts
- 16. Knicks 10.1K posts
- 17. Gucci 30.8K posts
- 18. CARAMELO ON TLMD 25K posts
- 19. Olympiacos 21.8K posts
- 20. Christopher Moynihan 5,943 posts
คุณอาจชื่นชอบ
Something went wrong.
Something went wrong.