Data Base Journal News   ---  

FREE reports on top business
technology priorities

SQL Server - Introduction to Business Intelligence Development Studio

 In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.

SQL Server Indexed Views

 Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.

Oracle Database Archive Logging -- Where are my archive logs?

 Archive log destinations can be tricky when defining or viewing in Oracle Database. Stick to a few common rules and never get lost.

SQL Server 2008 : Accessing Audit Details

 Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.

Using the Sybase ASE Resource Governor

 The Sybase ASE Resource Governor provides you with a mechanism to limit the resources a given process may request or acquire. If you have very heavy resource drains, it may be that adding this tiny bit of overhead can reduce whatever is currently stressing your system.

T-SQL Equivalents for Microsoft Access VBA Functions

 If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL.

SQL Server Column Considerations and Column Placement

 Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.

Oracle Database 11gR2: Installing Grid Infrastructure

 Jim Czuprynski demonstrates how to install and configure a new Oracle Database 11g Release 2 (11gR2) Grid Infrastructure home as the basis for the majority of the grid computing features that were only available in a Real Application Clusters (RAC) clustered database environment in previous releases.

Oracle DBA Job Interview - Nailing a Fairly Common Question

 While not that technical in nature, this one question gives you an opportunity to list reasons or possibilities of a technical nature, which in turn allow you to demonstrate your knowledge and understanding of how Oracle Database works, and perhaps in this case, how it may not be working.

MySQL CASE Statements in Multi-Aggregated Crosstab Columns

 Inserting additional columns to a crosstab query is less straightforward than adding row data, because SQL naturally groups data by rows. Moreover, the efficacy of the CASE statement within an aggregate function decreases in direct proportion to the complexity of the criteria. Read on to learn more...