8 posts tagged with sql and databases.
Displaying 1 through 8 of 8. Subscribe:

Help me get a Microsoft DB certification

I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
posted by Mrs. Pterodactyl on Jul 15, 2014 - 3 answers

How do I NoSQL?

My bread and butter is and always has been data stored in relational databases. I keep seeing a lot of material on key-value storage (also known as the NoSQL movement) but haven't had as much success finding resources on how to move from relational to non-relational. Any suggestions? [more inside]
posted by Deathalicious on Jul 10, 2010 - 10 answers

Can I specify the order in an ORDER BY clause in a SQL Statement?

Can I specify the order in an ORDER BY clause in a SQL Statement? If not then what is the best way of doing the following query? [more inside]
posted by xetere on Feb 19, 2009 - 9 answers

MySQL joins

I have a problem joining three tables in MYSQL. [more inside]
posted by dydecker on Aug 21, 2008 - 19 answers

How can I import a 46GB database into MSSQL without ending up with a 46GB transaction log?

I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted by odinsdream on May 29, 2008 - 4 answers

Synchronize databases....3...2...1... NOW!

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

It's not you - my CPU says yes, but my database say no

How many database reads/writes are okay per web page view? Also, what is better, big tables or lots of join tables? [more inside]
posted by markovich on Nov 16, 2007 - 13 answers

How can social scientists learn database skills?

What resources exist for non-techy social scientists who want to use relational databases to store their data, but don't know how? [more inside]
posted by jacobm on Dec 24, 2005 - 7 answers

Page: 1