“The right tool for the right job.” If such wisdom holds true anywhere, it certainly holds true with the choice of database a developer picks for a given application. Document databases, one of the family of data products collectively referred to as “NoSQL,” are for developers who want to focus on their application rather than the database technology.With a document database, data is not stored in tables with distinct column types. Instead, it is stored in freeform “documents” with any number of fields and any number of nested structures. Such documents are typically represented as JSON, and updated either by way of APIs or by sending JSON to a REST endpoint. Most every modern programming language supports JSON and REST, so working with a document database feels more like working natively with those data structures than working with a traditional database.This schemaless design, as it is called, has its limitations. A developer must do more work to … [Read more...] about NoSQL standouts: The best document databases
Sql 2003 standard
The next version of Microsoft's SQL Server relational database management system is now available, and along with it comes a special offer designed specifically to woo Oracle customers. Until the end of this month, Oracle users can migrate their databases to SQL Server 2016 and receive the necessary licenses for free with a subscription to Microsoft's Software Assurance maintenance program. Microsoft announced the June 1 release date for SQL Server 2016 early last month. Among the more notable enhancements it brings are updateable, in-memory column stores and advanced analytics. As a result, applications can now deploy sophisticated analytics and machine learning models within the database at performance levels as much as 100 times faster than what they'd be outside it, Microsoft said. The software's new Always Encrypted feature helps protect data at rest and in memory, while Stretch Database aims to reduce storage costs while keeping data available for querying in Microsoft's Azure … [Read more...] about Microsoft rolls out SQL Server 2016 with a special deal to woo Oracle customers
Q. How do I execute a SQL script (.sql file) on my MS-SQL database server under Windows Sever 2003?A. You can easily run any .sql file on MS-SQL database server using the Query Analyzer tool. How can I execute a SQL script (.sql file) on my SQL Server ? Open the Query Analyzer by visiting Start â†’ Programs â†’ MS SQL Server â†’ Query Analyzer Once opened, connect to the database that you are wish running the script on. Next, open the SQL file using File â†’ Open option. Select .sql file. Once it is open, you can execute the file by pressing F5. Posted by: Vivek Gite The author is the creator of nixCraft and a seasoned sysadmin, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter. … [Read more...] about MS-SQL: Run a SQL Script on Database Server
Q. Can you tell me more about MS SQL Server 2008? What’s new in MS-SQL Server 2008?A. Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query languages are MS-SQL and T-SQL. The latest version of SQL Server, SQL Server 2008 (code-named “Katmai”) and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 include support for: Structured and semi-structured data Examples: digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them. SQL Server 2008 can be a data storage backend for different varieties of data: XML, email, time/calendar, file, document, … [Read more...] about What’s New in MS-SQL 2008
When faced with the question of which is the best-selling phone, most of you probably think "iPhone". Hehe! Not even close! Although Apple's crown jewel does sell in cosmic quantities, the iPhone 6 having sold 71.5 million units in about three months, this lucky champ has nothing going on the Nokia 1100.The Nokia 1100 is an entry level basic handset which hit the market in late 2003. It didn't have two front cameras or a curved screen, but it did have a torch light, a pair of no-slip grips, and a dust-proof case. A classic Nokia badass that the then thriving Finns designed for the growing Chinese market and other regions that smelled of cash!How did that go for Nokia? Well, in about five years, the 1100 sold some 250 million units, becoming not only the world's best selling phone, but the best selling consumer electronics device in the world, period. In fact, Nokia's one billionth phone sold was a 1100 purchased in Nigeria in 2005!So, what it is that made people in developing countries … [Read more...] about Did you know that the Nokia 1100 is the world’s best-selling handset?