Idera, a provider of Microsoft SQL Server management and administration tools, announced SQL virtual database 1.3, the latest release for this solution that enables backup files to look and act just ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale. One of the most fundamental choices to make when developing an ...

Microsoft Corp. has released a 64-bit database and claims that the new system features performance rivaling that of Unix-based systems yet offers greater ease of use and at a lower cost. In ...

The next version of SQL Server, Microsoft’s flagship database product, will launch on June 1, the company announced today. The release follows Microsoft’s usual round of public previews and release ...

The better your SQL database performs, the more effectively it will fulfill its purpose of providing information to the apps and services that rely upon it to function. Optimizing database performance ...

Microsoft announced a roadmap shift, indicating that it will focus on supporting Open Database Connectivity for SQL Server application programming interfaces in the near future. The shift is of ...

RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...