I confess I use SQL Server more these days than Oracle, but the only possible option I can find that would let you see multiple databases seems to be if you're using something like Enterprise Manager Cloud Control - https://www.mydbaworld.com/extract-databases-server-os-version-of-oem-repository/]">Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository - My DBA World
I'm a new Dev.
I wanted to learn more about how google classrooms database works, Like when a student enters a Code it will then proceed to the classroom and displays all the data on that classroom? I want to learn, how does that work. Would love to hear some suggestions on where to learn more about how it works.
Yes, I understand. One of the most popular arguments for having Data Warehouse is that it should enable the user to access data/information faster.
I have been thinking about these points (Benefits of having a data Warehouse) for a long time now. At the moment we do not have a very large business or production database. The largest of tables transaction log) consist of around 8 million records with 40 fields. So, I don't think speed of access is our problem however, I do agree with some of the other benefits like:
2. Enhances Conformity And Quality Of Data
3. Boosts Efficiency "to have to gather data from multiple sources"
In our case we have many different types of databases (data islands) most of them SQL Server... So, I think that the DW would solve the challenge of bringing everything together in order to give the user a better view of how the business when all data is brought together into one view ("to have to gather data from multiple sources").
Again, thank you for the reply and the information ....
Boosts Efficiency "to have to gather data from multiple sources"
It also lowers frustration!
After I had posted my reply I had to spend (waste?) quite some time combining data from 3 different sources (oh - and we do have a DW here, it's just not comprehensive. So we've introduced a second one on a different platform - you couldn't make this up really)
It's "doable", especially with modern connectors and tools, but a real PITA - I seem to waste more time sourcing data to then be merged, than I do actually doing the analysis to gain insight. Like I said - frustrating.
Perhaps then that is your most compelling argument ... A DW makes it easier and quicker to bring real insight to the business, turn data into information, to drive down costs and raise profitability.
(I'm starting to sound like an advert so I will stop there )
I have Delphi 11 Alexandria Professional edition.
This edition includes Firedac but I can only access local databases (hosted on the same machine that the application executable).
Can I access to MySQL or SQL databases both local or remote using UNIDAC with my Delphi edition?
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
Ive tried the INNER, LEFT, RIGHT join but it doesnt seem as if my tables are connecting. I have tables with different names and none match. I also have a main table(login/register) and want the rest to connect to that. How do I go about doing this?
I'm working on a PHP project, that started in SQL server 2000, and I just upgraded the PHP to support SQL Server 2008. Well now I would like to use OFFSET and FETCH to paginate long lists and I need 2012. I'm wondering if just next functions were added or if I need to change my dates again, CONVERT(char(10) createDate, 126) to another format.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
Well, the major one would be that 2012 (v11) is still supported, while 2008 (10.5) isn't.
I don't remember of breaking changes between those versions, though. A slightly better UI for SSMS, maybe. But nothing about date formats which would have changed. I just remember this was the time I started to install db systems on virtual machines rather than on physical ones.
Regarding the date format you are talking about, the only way to be sure is to install a 2012 instance, copy the database, and test your queries and sp's against the new instance.
"Five fruits and vegetables a day? What a joke!
Personally, after the third watermelon, I'm full."
Last Visit: 31-Dec-99 18:00 Last Update: 30-Sep-23 20:52