Tagged Questions

2
votes
1answer
70 views

How to swap out a DB from MySQL to SQL Server in a multiple large projects?

Is there a sane way / best practices way to swap out a DB from MySQL to SQL Server in a multiple large projects? Some of the projects are ASP projects, some of them are windows services, some are ...
3
votes
3answers
531 views

Are there any special advantages of SQL Server with Visual Studio?

I have seen the forum dba.StackExchange, but this question involves Visual Studio as well, therefore I wanted to post this question here. One of my old application was built on VS-2008 and MySQL ...
1
vote
2answers
177 views

what is storing data in constant space?

"bloom filter allows us to store data in constant space" Can someone explain what exactly does that sentence means?
1
vote
6answers
510 views

what is the benefit of using key/value stores with respect to database sharding?

What has key/value stores got to do with making database sharding easier? Because if I do not use a key/value store, I can easily shard my database too right? (Like say, I can easily say users with ...
2
votes
3answers
224 views

Is it possible to use MySQL in ASP.NET?

I do not know much about ASP.NET but I may learn it soon and I want to know if it is possible to use the database MySQL with it? and if it is possible does it work fine as SQL Server or does SQL ...
2
votes
5answers
875 views

Which of the following relational database management systems would a company adopt (for migration), if any, MS Access, MS SQL Server or MySQL?

Dear programmers, as part of my final year university project, I am conducting research into relational database management systems such as Microsoft Office Access 2007, Microsoft SQL Server 2008 and ...
5
votes
9answers
861 views

Foreign key restrictions -> yes or no?

I would like to hear some”real life experience” suggestions if foreign key restrictions are good or bad thing to enforce in DB. I would kindly ask students/beginners to refrain from jumping and ...