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

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 12

Expert Comment

by:Alex Green
1
 
LVL 11

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
Ready to get started with anonymous questions?
LVL 9
Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

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
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.