Data Base Journal News   ---  

FREE reports on top business
technology priorities

Looking at Memory Usage for Oracle Processes

 When an Oracle instance starts, or an application uses the Oracle database, the associated Oracle processes are allocated and consume memory. Learn how to use the V$PROCESS view and V$PROCESS_MEMORY to look at this memory usage. -  more information

SQL Server Profiler Part 2

 Part 1 of this series discussed the difference between a Trace and Profiler. This installment examines additional preconfigured templates, how to synchronizing Profiler and Perfmon and how to run Profiler as a scheduled task. -  more information

Check your SQL Server using Windows PowerShell – Part II

 Part two of this series illustrates how to access the Windows service on a remote machine using Windows PowerShell and WMI-Object to see if all of the windows services related to SQL Server are up and running. -  more information

Oracle Database 11g: Database Replay, Part 3

 The final article in this series illustrates how to use Oracle Database 11gR1's new Database Replay (DBR) features to capture and prepare a workload from a current Oracle 10gR2 single-instance database environment and then replay that identical workload in an Oracle 11gR1 Real Application Clusters (RAC) testing environment. -  more information

Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part II

 BI Architect Bill Pearson continues his hands-on demonstration of an approach to the parameterization of the highly useful LastPeriods() function. -  more information

SQL Server 2008 Date Functions, Part 2

 To manage and use the new date data types introduced in SQL Server 2008, Microsoft has provided a number of new system functions. In this article, Greg Larsen explores the new system functions and some of the old date functions that were available in older releases of SQL Server. -  more information

Product Review – Toad Data Modeler 3

 Quest Software has hit the ball out of the park with its Toad Data Modeler 3 (TDM) application. Ease of use, a huge amount of functionality, and an outstanding support base all combine to make TDM a superb product. Read on to learn more… -  more information

Enhancement in variable declaration – SQL Server 2008

 Enhanced variable declaration, one of the many enhancements that Microsoft added to SQL Server 2008 allows you to declare and initialize a value at the same time. This article shows you how to do it. -  more information

Implementing Upgrade of SQL Server 2005 Express Edition

 In the previous installment of our series, we presented a variety of reasons that might influence your decision to upgrade a full-fledged member of the SQL Server 2005 family. This article discusses the actual implementation of this process, pointing out additional factors that might affect its complexity. -  more information

Intrinsic Member Properties: The MEMBER_KEY Property

 Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists. -  more information