Unit testing is a core fundamental aspect of application development. But unit testing can and should be utilized when developing databases as well, to verify that changes have not regressed database functionality. Visual Studio 2013 provides SQL Server database unit tests as part of the testing infrastructure and in SQL …
This short video compares MongoDB and Couchbase for implementing big data project. MongoDB and Couchbase are two open-source NoSQL databases.
Cloning datasets locally, munging them into the format that you need and then indexing and querying are parts of the complex workflow of working with data that hasn’t yet been made easy to capture and share.
Troubleshooting MySQL doesn’t need to involve trial-and-error, and it doesn’t need to take a long time. You need only two things: a good process and good tools. This session will show you an approach that the speaker has used to solve many frustrating problems quickly, and open source tools that …
This video explores key best practices for PL/SQL development and learn how they fit into a development workflow that produces high quality code. This episode discusses coding standards and naming conventions.
How did Pinterest, the social platform that allows users to create themed “pin boards” where they can “pin” pictures they find online or upload from their computers or phones, build a site that seamlessly allows millions of users to upload millions more pictures a day?
