Databases

54K

Solutions

38K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am doing a very simple linked database.  I query it to generate a report that is exported.   I need to add a form to  contain the value queried so I can use it to generate the file name.   However all the "create" functions are greyed out and I can't figure out how to add a form.  All my searches talk about not being able to add data which is not my problem.    When I create a new database the functions are there.
0
What does it mean to be "Always On"?
LVL 4
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Used jquery ui sortable function for the first time this week. It was really easy to create a drag and drop list and serializing the order to save in a database was really easy. Not sure why I hadn't tried to use it before.
5
A technology that is kind of a fad,but will probably last but be not as popular are the no sql databases. They have there place for certain applications, but I don't believe they will replace SQL databases. Having to know how you are going to query before you store your data is just not realistic.  
3
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'. (rsInvalidReportServerDatabase) Get Online Help
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi MAGLOCLEN,

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
how can i export oracle 10g database in fronted need code level help how can i do it please help me
0
 
LVL 2

Administrative Comment

by:Allie Watts
Hey Farhad! You made a post instead of a question. In order to get more responses from experts and members of the community on your question, create a question with this content in it! Best of luck getting this issue resolved!
2
SysAdmin Day is this Friday! If you have a story of a time when your technical skill and expertise saved the day comment here. You can also message us!

Looking forward to reading more of your experiences!
3
Installed my first Server with SSD's today.  The HP 400GB SSD's (In as RAID1 to save on costs) are for hosting a Database.

As you can imagine, its like lightening!
5
 
LVL 7

Expert Comment

by:Brian Matis
When I built my latest gaming PC a few years ago, I made sure to use an SSD for the boot volume. Has been great! I'd love to get a larger one in there at some point so I can get more of my games on an SSD as well :-)
0
 
LVL 22

Author Comment

by:David Atkin
I upgraded my gaming PC to an SSD last year.  I purchased a Sandisk 480GB with 10 Years Warranty!

*touch wood* it's never let me down.  The Speed is still fantastic.
1
How to design a Hierarchy based Table Relation?


To give an example: Organizational Chart. I am actually working on a Product based database.  Lacking in the design.
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi chokka,

What you have done is made a "Post" here. To get help from the experts, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
We had a partner replace a drive on the database server, when he resorted the database(s) on Friday all are now in SUSPECT mode and are inaccessible. We are not dba's and need help can anyone please help.  Sql 2012 r2.

Thank you
SORRY I posted this in the incorrect place I will not do this again
0
 
LVL 13

Expert Comment

by:Alex Green
1
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Steven,

What you have done is made a "Post" here.

To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Regards,
Andrew
EE Topic Advisor
1
Yesterday, cyber resilience startup, UpGuard, issued a report that as many as 14 million U.S. Verizon customers have fallen victim to a hack that stole their names, addresses, account details, and PINs. The startup claims to have first notified Verizon on June 13th of the hack, citing a "misconfigured cloud-based file repository" as the cause.

In reply, Verizon has stated that there has been no loss or theft of customer information and that only 6 million customers may be at risk due to an informational cloud storage move where a third-party employee made external access available. Latest reports urge Verizon customers to update their Verizon PINs in order to safeguard their accounts.

Stay tuned for more information on what happened in this attack and how to safeguard your accounts.
5
Will your db performance match your db growth?
LVL 3
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Is there any free offline software for Recruitment managemant database ???
I need inputs like candidate name,CTC,contact number,email,resume upload etc.,
0
 
LVL 66

Expert Comment

by:Jim Horn
None that I'm aware of, but I imagine that this wouldn't be too different from any basic CRM, so if you search for free CRM's you may find some.  Also I'm sure SalesForce.com has some recruiting-specific offerings.

Microsoft Access has some canned database wizards, maybe one of them is a CRM.

Next time please ask this as a question and not in a post.  Thanks in advance.
1
1
Which Database Choose?

This Article about choose the NOSQL database based on application requirement. Different NoSQL DB’s available, there are three primary concerns you must balance when choosing a data management system: consistency, availability, and partition tolerance.

 

* Consistency means that each client always has the same view of the data. * Availability means that all clients can always read and write.

* Partition tolerance means that the system works well across physical network partitions.

 

Chose the Database system based on your application requirement.

 Example Comparing MongoDB and CouchDB.

As you can see in the diagram, MongoDB and CouchDB are built with a slightly different focus. Both scale across multiple nodes easily, but MongoDB favours consistency while CouchDB favours availability.

In the MongoDB replication model, a group of database nodes host the same data set and are defined as a Replica set. One of the nodes in the set will act as primary and the others will be secondary nodes. The primary node is used for all write operations, and by default all read operations as well. This means that replica sets provide strict consistency. Replication is used to provide redundancy - to recover from hardware failure or service interruptions.

CouchDB uses a replication model called Eventual consistency. In this system, clients can write data to one node of the database without waiting for other nodes to come into agreement. The …
0
"IT Certifications are a concrete representation of continual learning on the part of the candidate." If you're looking to get certified, now is the perfect time. Premium and team accounts can enroll in the CompTIA A+ course for free during the month of May. Click here to enroll!

https://www.experts-exchange.com/articles/29383/Should-I-pursue-an-IT-certification.html
4
Was happy to have a tool like www.newrelic.com. Had an issue where only certain users were experiencing a slow load time. Turned to be code executing too many unnecessary queries that was exposed by looking at long transactions on new relic. Made it a lot easier to find something that otherwise might have taken awhile to narrow down.
5
2
Is it just me or is NoSQL Overapplied? It seems like in an effort to be as trendy as possible people shoehorn obviously relational problems into non relational schema. If you have to start throwing foreign keys on your objects I think you need to rethink your solution. Sarah Mei makes a good point about this in her article:

http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/
4
 
LVL 14

Expert Comment

by:Phil Phillips
It was definitely over applied initially. Though, I think it's gotten better over the years. Part of it, too, is that a lot of the relational databases started incorporating NoSQL-like features (i.e. PostgreSQL and their JSON capabilities).
3

Databases

54K

Solutions

38K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.