Optimization

The world of Database Management Software (DBMS) is an industry that has turned on its head in the last ten years. A space that was once dominated by the big software conglomerates now is joined by a number of free and open source options. With so many solutions out there, paid and free, it can be an…

SQL is a standard language for accessing and manipulating databases. What is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases SQL is an ANSI (American National Standards Institute) standard What Can SQL do? SQL can execute queries against a database SQL can retrieve…

It allows us to state what we want to select, insert, update or delete from our graph data without requiring us to describe exactly how to do it. Nodes Cypher uses ASCII-Art to represent patterns. We surround nodes with parentheses which look like circles, e.g. (node). If we later want to refer to the…

This article provides a brief overview of databases — what they are, why you might want to use one, and what the different parts of a database do. The terminology is geared toward Microsoft Access databases, but the concepts apply to all database products. What is a database? A database is a tool for…

The latest version of Microsoft SQL Server Database Engine Tuning Advisor (DTA) supports two new features: (a) Ability to recommend columnstore indexes in addition to rowstore indexes, and (b) Ability to automatically select a workload to tune from the Query Store. These new features are available when…

We are happy to announce a number of significant improvements to elastic database query in Azure SQL Database. Most notably, elastic database query now supports querying across databases in Azure SQL Database. This makes possible common cross-database querying tasks like selecting from a remote table…

Those of you that made it to the demo grounds at Oracle Open World this year (it’s still just about 2015) will have had the chance to chat with the Oracle developers and throw lots of difficult questions at them! For everyone in the Optimizer development team it was a great opportunity to get lots of…

Client database headings are key to making them useful. Polka Dot RF/Polka Dot/Getty Images If you can use a simple spreadsheet, you can create a valuable and powerful business tool for managing your business s clients. A client database can be more than just a list of customers’ names, titles and contact…

Magento s use of data models provide a great way to access and modify data. Using aptly named methods and clever abstraction, Varien hide away the complex SQL needed to perform data operations. While this makes learning models easier, it often impacts the speed of the operation and therefore the responsiveness…