Oracle 11g Application editions are a very useful addition to an already world-class database, allowing developers to make changes to existing tables and schemas without affecting current users in the testing environment. Read on to learn more...
SQL Server 2008 R2 brought several new features into SQL Server Reporting Services, including three additional ways to display, visualize, and analyze data in the reports. Arshad Ali shows you how to create map reports to analyze your data against a geographical background.
MySQL Access Control is not just about giving your users access to the database by adding their login credentials to the User table. Beyond that there's another layer of access control, based on user privileges. Follow along as Rob Gravelle explains stage 2 of MySQL access control.
SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.
SQL Server 2012 included Analysis Service PowerShell provider also known as SQLAS provider. MAK shows you how to navigate, administer and query an Analysis Services object from Windows PowerShell.
Learn different ways to use the OUTPUT clause on an INSERT, UPDATE, DELETE or MERGE statement to expose the records that go into the INSERTED, and DELETED pseudo tables to your application or T-SQL code.
Robert Schneider explains how Sybase Adaptive Server Enterprise (ASE) has been augmented with a series of capabilities designed to deliver better performance and scalability through its hybrid-threaded kernel.
There are many ways to safely store passwords in MySQL. This article covers a few different encryption algorithms supported in MySQL that will help you make a sound decision as to which suits your needs best.
Marcin Policht discusses the steps required to install and configure Integration Services incorporated into the soon-to-be released SQL Server 2012.
Indexes are interesting objects -- they can dramatically improve performance but their management can be tricky. Let's take an example through a number of iterations and see what Oracle does with the index, and explain why the results shouldn't be unexpected.