April 16th, 2009
load2test.com
Published on April 16th, 2009 @ 10:20:44 am , using 3 words, 626 views
load2test.com
April 12th, 2009
Load2Test - great load test product
Published on April 12th, 2009 @ 07:34:55 am , using 113 words, 79 views
Load2Test by DBA InfoPower is a the best for MySQL load testing - they can record actual MySQL production traffic and replay it in staging multiple ways, like "as is", "load parallelization", "think time reduction", etc and generate performance issues root cause analysis on a spot.
I used it with number of my customers and it takes no time to do load testing and get analytics and root cause analysis back (like gathering slow-log data without any impact on a system and more), compare runs, etc
They are small startup that operates "under the radar". I got introduced to this product through the person who works there - and I really like the tool!!!
March 21st, 2009
DBA Tools for RCA and Fast problem identification
Published on March 21st, 2009 @ 05:32:32 am , using 40 words, 2088 views
Download PEi
Performance Explorer-i: performance problem diagnosis for business-critical databases and database clusters
Download DBAct
DBAct: real-time performance problem containment and remediation for business-critical databases
You can request HLC and L2T evaluations, by sending email to support@dbainfopower.com
March 1st, 2009
HLC - High Load Capture, investigate and identify root cause of the performance problems and high-impact performance spikes
Published on March 1st, 2009 @ 09:50:04 pm , using 397 words, 1187 views
DBAip High Load Capture provides DBAs with a great power to investigate and identify root cause of the performance problems and high-impact performance spikes with the second-by-second granularity and sub second precision
DBAip High Load Capture enables DBA with the following advanced real-time root cause analysis and problem identification components:
cross-target (cross-database and cross server) analysis and correlation of second-by-second performance information
Smoothing filters for clear trend identification
SNMP notification on alerts
Ability to capture data under heavy production load without impacting database business activity
Ability to mix captured metrics across databases and database platforms on the same analysis panel
Ability to analyze multiple database servers using standard templates
Simple and effective capture configuration supports database metrics, OS metrics, custom script metrics, business SQL metrics
Effective Connection Manager acting as a single point of control for connection configuration and agent deployment
Cross-platform data acquisition compatibility - data capture agents support Intel Linux, SUN Solaris, IBM AIX and HP/UX platforms
Secured communication with agents over customized SSH/SSL protocol
Portability and support of many hardware platforms - Analysis module is written in Java.
The following is proposed DBAip HLC setup and work flow:
Step1: Identify set of metrics to capture. The following can be done by: a) Selecting prepackaged set of metrics prepared by DBA InfoPower experts
b) Creating custom metric set aligned with the enterprise business usage patterns
c) Utilizing DBAip Performance Explorer-I product to identify performance metrics that are directly associated with database continuity threatening events and therefore good candidates for capturing.
Step 2: Once the metrics to capture identified, a capture configuration file, containing corresponding data captures is created
Step 3: DBAip High Load Capture agent is started in a database server
Step 4: DBAip High Load Capture Console connects to the capture agents to download captured data for the analysis
Benefits of DBAip High Load Capture
Instantly identifies key changes in system performance that endanger database business continuity
Clarifies changes in Database Performance behavior using dynamic smoothing filters (Patent Pending technology)
Analyzes performance behavior across multiple databases and servers and visualizes relative performance across array of databases and servers
Correlates database performance metrics with metrics related to other operational components, such as OS, application servers, network, SAN, etc
Captures multiple streams of performance information in parallel under heavy load
DBAip HLC Visual Analysis Module written in pure Java and runs on any platform that supports JVM (J2SE 1.4+)
March 1st, 2009
DBAct - DBA tool, instantly resolve database problems
Published on March 1st, 2009 @ 09:32:29 pm , using 564 words, 338 views
DBAip DBAct - Provides the DBA with a great power to contain and instantly resolve issues threatening database business continuity. This command-line cross platform module weapons DBA with over 80 actionable functions necessary to identify and automatically or semi-automatically resolve cases of extreme contention and resource consumption.
Benefits of DBAip DBAct
DBAip DBAct - enables deep drill down diagnostics into issues immediately impacting database performance.
Sample areas are:
Latching Investigation
Detailed Transactional locking investigation
Internal DDL Locking and contention
Identification of Top CPU Consuming sessions/machines
Internal Buffer busy waits contention/blocking sessions
Fragmentation of Shared Pool and Shared Pool Free Space
Waits on Segments/Data Blocks
Resource manager performance and contention
DBAip DBAct - enables deep real time performance sampling on most important database dynamics.
Sample areas for dynamic performance snapshot are:
Real time snapshot of most frequently executing SQL
Real time snapshot of most frequently parsing SQL
Real time snapshot of SQL consuming most Buffer Gets (CPU consumption)
Real time snapshot of top machines waiting on provided wait event
Real time snapshot of top machines increasing count of provided statistic
Real time snapshot of Top File System I/O performance
Real time snapshot of Top Datafile I/O performance
DBAip Act - enables low level tracing.
Sample tracing areas are:
10046 level 12 per Machine tracing
10046 level 12 per OS Process Id/Session id
10046 level 12 per Module/Program tracing
10046 level 12 per SQL Tracing
Internal Oracle systemstate/library_cache/heapdump/hanganalyze tracing
DBAip DBAct - enables deep drill down into performance view information and saves DBA from constantly typing SQL during the problem investigation and resolution, when TTR is critical.
Sample areas are: Finding SQL in Shared Pool by pattern
Currently executed SQL
Finding SQL by provided hash value/SQL id
Finding SQL executed by provided OS process id
Creating SQL Plan from provided hash value/SQL id
Creating SQL Plan from provided file
Viewing contents of buffer cache per object
Machines Drill Down Information
-Connection Per machine
-Active SQL Per machine
-Open Cursors and Open Cursors per connection ratio
-...
Information about newly parsed sql in shared pool
Information about running parallel queries/parallel slaves
PGA/SGA drill down Information
Buffer Pools information
DBAip DBAct - enables deep drill down into dictionary information and relives DBA from constantly typing SQL accessing catalog tables during the problem investigation and resolution, when TTR is critical.
Sample areas are:
Fast report on table/index/column level CBO statistics
Fast report on newly created object in the database
Fast report on invalid objects
Detailed information on database users
Detailed information on tablespace, datafiles, used and free space
Detailed information on used space in temp tablespaces per user
Detailed information on Table/Index partitions
Detailed information on table indexes/columns
Detailed information on segment distribution across file systems
Fast access to definition/code of Views/Triggers/PLSQL objects
Fast access to definition/code of internal Oracle x$ Views
Fast access to definition/values of internal Oracle _parameters
DBAip DBAct - provided utility functions that greatly help DBA in problem investigation and resolution.
Sample utility functions are:
Display OS process id for the given session id
Display session id for the given OS process id
Display Machine for the given process id
Display Client process id for the given OS process id/Session id
Decode DBA number into file number, block number, file name and segment name
Convert “dd/mm/yyyy hh24: mi: ss” to redo log dump redo time
January 8th, 2009
Performance Explorer ReadMe
Published on January 8th, 2009 @ 08:00:30 pm , using 1933 words, 212 views
http://www.dbainfopower.com/doc/ora_performance_explorer_readme.pdf
Contents
1 Welcome to Performance Explorer for Oracle
2 System Requirements
3 Installing Performance Explorer for Oracle
4 Launching and Configuring Performance Explorer for Oracle
5 Performance Notes
6 Global Operation
7 For More Information
. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . .
1. Welcome to Performance Explorer for Oracle
Performance Explorer is a powerful root cause analysis tool for Oracle databases. Its unique
analytical capabilities and interface provides you with a clear visualization and root cause of
activity on your database. Snapshots Compare identifies changes that caused changes in
performance on a single or multiple databases, while visual analysis system identifies spikes
and capacity changes in key statistics and metrics.
. . . . . . . .. . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . .
2. System Requirements
You should verify that your system meets the following requirements before installing and runing
Performance Explorer for Oracle.
Hardware requirements
• A Pentium-based or equivalent PC
• 50 megabytes of free disk space should exist on a local disk drive rather than a network drive.
Extra disk space will be required if you choose to save reports and graphs crated from within
Performance Explorer.
• Monitor capable of supporting a resolution of 800x600 or larger Performance Explorer is
designed to run on a desktop area of 800 by 600 pixels or larger. It is best viewed on a desktop
area of 1024 by 1024 pixels. You should also set the display to use the 32bit color palette.
• 256 megabytes of RAM (minimum)
256 megabytes is generally adequate unless many other applications are running.
• CD-ROM drive or Internet connection Performance Explorer can be downloaded from the
Internet or installed from compact disc. The CD-ROM drive should be attached to the PC on
which Performance Explorer is to be installed. A drive mapped to a network device could be
used if a local CD-ROM is not available.
• Printer (optional) Performance Explorer reports can be printed on a laser or bubble jet printer. You
can print graphs in color if your printer provides this capability.
• Mouse
To access all the features of Performance Explorer you should have a mouse installed on your PC.
Software requirements
• Windows 2000, Windows 2003 Server, Windows XP Professional, Linux Red Hat or Linux
SuSe
The following specific requirements exist:
• Windows 2000. Service Pack 4 (or later) must be installed.
• Windows XP. Service Pack 1 (or later) must be installed.
• Red Hat Linux 7.x, 8.x, 9.x (2.4 kernel)
• SUSE Linux 7.0, 8.0, 9.0 (2.4 kernel)
• SQL*Net 2.3.4 or later or Oracle JDBC driver for thin database connection
SQL*Net enables a connection to be established to a database. The database may be local or
remote. Before you start Performance Explorer you must have the SQL*Net or Thin JDBC
connection string for the database.
• Oracle 8.x.x, Oracle 9.x.x , Oracle 10g
You must have the Database Administrator (DBA) user ID and password for the database
you want to diagnose.
• Oracle Statspack / Oracle AWR data
You must have the Oracle Statspack or AWR data in place to be able to analyze and visualize
performance data using Performance Explorer
• Adobe Acrobat 6.0
A copy of the Performance Explorer for Oracle Getting Started Guide is included in the
Performance Explorer installation in portable document format (PDF). You must install
Adobe Acrobat Reader version 6.0 or later to view the PDF files. Adobe Acrobat reader is
available at Adobe’s web site:
http://www.adobe.com/
• SQL Tuning
A SQL Analysis and Tuning module is included in Performance Explorer
. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . .
3. Installing Performance Explorer for Oracle
Performance Explorer for Oracle 4.01 is provided as a stand-alone installer.
Installation of Performance Explorer for Oracle
This procedure outlines how to install Performance Explorer on your PC, and should only take a
few minutes to complete. Close all other applications before loading the CD into your PC. You
can cancel the installation at any time by pressing the Esc key or by clicking the Cancel button.
To install Performance Explorer for Oracle
1 Insert the Performance Explorer CD into your CD-ROM drive or download Performance
Explorer installer from the URL provided by DBA InfoPower Inc. representative
Depending on your system's configuration, the installation program may start
automatically. If this happens, follow the instructions on the screen to complete the
installation.
2 If the installation program does not start, select Run from the Windows Start menu.
3 Type d:\pexplorer_i_401.exe (where d: is the CD-ROM identifier and 401 is the version
number), and click OK.
4 Follow the instructions displayed on the screen.
By default, Performance Explorer for Oracle is installed into the following directory, though
you can choose a different installation path.
C:\Program Files\ DBAip Performance Explorer-i
Multiple installations of Performance Explorer for Oracle
The advanced Performance Explorer installer allows you to install and separately upgrade
multiple versions of Performance Explorer for Oracle on your computer.
. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . .
4. Launching Performance Explorer for Oracle
Performance Explorer for Oracle can be launched in one of two ways, either directly, or via
DBA HeartBeat Console. The simplest way to get started is to launch Performance Explorer
directly.
Launching Performance Explorer directly
To launch Performance Explorer directly:
Via Start menu Performance Explorer for Oracle is placed in the Windows Start menu under:
DBAip Performance Explorer-i > Performance Explorer-i Statspack-AWR, 10g JDBC Driver
Or
DBAip Performance Explorer-i > Performance Explorer-i Statspack-AWR, 9i JDBC Driver
Or
DBAip Performance Explorer-i > Performance Explorer-i Statspack-AWR, 8i JDBC Driver
Launching via DBA HeartBeat Console
When DBA HeartBeat Console is available, you can also launch Performance Explorer
when you select the Root Cause Analysis option from the DBA HeartBeat Console.
Authorizing Performance Explorer for Oracle
If you are a new user of Performance Explorer for Oracle, you will be supplied with a trial period in
order to test the product. When the trial period expires, Performance Explorer for Oracle will stop
functioning.
To maintain full functionality, please contact your DBA InfoPower Software representative for
information on obtaining a full licensed version. For further information see “Product authorization
errors” in the Performance Explorer for Oracle User Guide.
Performance Explorer for Oracle database users and objects
Performance Explorer does not install any database objects into user database. No special database
user needs to be created. The Performance Explorer for Oracle User Guide tells you what database
user access rights are needed to be utilized by Performance Explorer for Oracle.
Setting up remote access to a database machine
Both Tnsnames connections and JDBC thin/OCI connection can be used to connect to remote
databases. When Performance Explorer for Oracle is connected to one or many databases, you can
diagnose the Oracle databases by using the information in the Performance Explorer Quick Tasks and
drilldown the root cause analysis sections.
Downloading Upgrades from the Internet
From time to time, DBA InfoPower, Inc. may make available on the Internet upgrades and patches.
Upgrades will be made available from the DBA InfoPower web site at www.dbainfopower.com.
Instructions for downloading and installing upgrades are provided on the web site.
Uninstalling Performance Explorer for Oracle
To uninstall Performance Explorer for Oracle use the Add/Remove Programs option in the
Windows Control Panel in the Start menu that appears when you click the Start button.
. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . . . .. . . . . .
5. Performance Notes
The following issues and limitations are known to exist in this release of Performance Explorer
for Oracle. They are listed in several sub-sections (General, Operating System, Oracle
(General), Oracle 10g, Oracle 9.2, Oracle 8, and Windows 2000 disk performance issue).
General notes
• Negative value for SQL statistics displayed as a result of the Top SQL Search
The SQL Analysis Top SQL Search component of the Performance Explorer may display a negative
value on a SQL Top Search Statistic or on a displayed SQL ratio. This occurs when in a heavily used
database system the value of the SQL performance statistic counter is growing over 4x10^9 and
becoming negative. This affects all Oracle versions 8i, 9i, and 10g.
Operating System notes
• Failure to startup Performance Explorer after successful install.
Performance Explorer may fail to startup during the installation process if user choose not to install
provided JRE (Java Runtime Environment). It is strongly recommended to use JRE packaged with
Performance Explorer.
• Connection over SSH tunnels
When direct TNS connection from desktop to database is not allowed due to security reasons, you
can create SSH tunnel to connect to a database on a remote host. SSH Tunnel can be created using
"putty", "Secure CRT" or any other SSH software that support tunnel creation.
For example, to set up SSH tunnel for default database listener port 1521:
In Putty: select "SSH->Tunnels" Category, set "Source port to1521" and Destination to
"db_host:1521".
In “Secure CRT”: select "Session Options", "Advanced" , "Port Forwarding" tab, set "Local Port" to
1521, remote hostname to "db_host" and "Remote port" to 1521 as well.
After the SSH tunnel is setup, tnsnames.ora entry needs to be changed to have "127.0.0.1" or
"localhost" instead of
January 8th, 2009
Performance Explorer-i
Published on January 8th, 2009 @ 07:36:39 pm , using 607 words, 155 views
Fast Database Performance Analysis and Problem Diagnosis
Performance Explorer-i delivers rapid performance analysis and diagnosis of performance problems in production databases. Its comprehensive reports, utilities and models utilize patented analytics to bring unprecedented speed, precision and scope to the analysis task, with negligible impact on the systems being analyzed.
Database Problem Diagnosis
Performance spike analysis
Identify areas of performance spikes and degradations using patented analysis technology that reduces analysis time from hours or days to less than a minute.
Change impact analysis
Detailed change impact analysis on cause of performance and availability problems with immediate drilldown into detailed information.
Oracle RAC analysis
Visualize performance metrics across multiple databases or multiple nodes of a RAC cluster. Access DLM statistics, RAC system statistics, or RAC latch information with a single click.
SQL impact analysis
Pinpoint problematic SQL using Advanced Top SQL Search enforced with DML and SQL pattern search filters. Drill Down to the level of individual SQL queries to determine how a change in different SQL characteristics is affecting the system. Similar queries can be aggregated to display cumulated impact on system performance.
Fast navigation of critical performance metrics
Navigate summary and detail information on system statistics, wait events, latches, SQL and other performance data efficiently and effectively. Eliminate painful eyeballing across Statspack and AWR reports when time to resolution is critical.
Cross-database analysis
Analyze heterogeneous database environments with built-in support for multiple commercial database systems and multiple versions of the same commercial DBMS. Perform problem and root cause analysis across multiple instances or multiple databases.
High performance visualization
Visualize tens of thousands of data points in a few seconds. Instantly superimpose current and historical time periods to identify seasonal performance patterns and more.
Integrated trending and forecasting
Clearly identify trends in database performance with smoothing (averaging) filters and linear regression models. Use trending projections to facilitate capacity planning.
Batch analysis generation
Run analysis in batch and in parallel across hundreds of databases.
Database Problem Reporting
Database Performance Overview
Gain a single-page view of the most important database performance metrics. Use the historical data overlay to immediately discover changes in database performance through visual inspection.
Current Database Change Profile
Accelerate your change root cause analysis with this report highlighting recent changes made to the database that may be affecting performance. Performance Explorer-i detects changes from new code deployments and upgrades – official or otherwise.
Real-time Database Check
Determine immediate threats to database stability and potential performance bottlenecks. View excessive active sessions, latch connections, RAC-related resource contention, slow I/O (for both random and sequential data access), and excessive query parallelism in the database.
Snapshot Change Analysis
Gain a holistic view of all changes that occurred over a specific time period, including changes in SQL statistics, newly introduced SQL, changed SQL plans, system statistics, wait events, latches, and more. Customize change reports by selecting time intervals for snapshot and baseline, change thresholds, and report details. Create a library of customized snapshots for fast, single-click generation.
Visual Root Cause Analysis
Find performance problems quickly using your eyes. View graphical representations of changes in key database metrics, including system statistics, wait events, latches, enqueues, segment I/O, datafile I/O, “Undo” tablespace I/O, rollback segments I/O, dictionary cache, library cache, and customer user SQL.
Batch Report Generation
Instantly generate HTML graphical reports using ChartBag Reporting Module. Report Templates can be saved and run in batch mode for continuous web publishing.
Supported Infrastructure
Client Operating Systems
Windows 2000/XP
Windows 2003 Server
Linux
Databases
Oracle 8i, 9i,10g
Oracle RAC 9i,10g
Screenshots are available here: http://www.dbainfopower.com/gallery_pei.htm
Datasheet is here: http://www.dbainfopower.com/col/DBAip-Performance-Explorer-i-DS.pdf
December 29th, 2008
Load2Test is an integrated, extensible load testing framework for performance validation and root cause analysis in development, test and staging environments
Published on December 29th, 2008 @ 09:02:19 pm , using 484 words, 728 views
Load2Test
Integrated, Extensible Load Testing Framework for Multi-tiered Applications
Load2Test is an integrated, extensible load testing framework for performance validation and root cause analysis in development, test and staging environments. Load2Test provides advanced support for load test development, execution, and concurrent root cause analysis. It can be applied to custom, composite, and packaged applications. Customizable reporting and open analytics make short work of test results documentation and sharing. Its unique approach to scalability validation reduces load test development time by 80%, helps development teams identify exact root causes of load test bottlenecks, and accommodates wide ranges of applications, load levels, and environments.
Load Test Development
Network protocol sniffers and parsersLet Load2Test’s library of network protocol sniffers and parsers do the work so you don’t have to. Intelligent parsing of network traffic and database activity reduces test script authoring efforts by as much as 80%.
Non-proprietary scripting languages
Author and extend load test scripts using non-proprietary languages such as Java, Groovy, Ruby, and Python.
No user interface dependencies
Avoid tedious test definition maintenance caused by UI changes because Load2Test definitions have no dependencies on user interface design.
Load Test Execution
Negligible footprint
Minimal overhead during execution makes it safe to apply in any environment.
100% pure Java
Load test execution runs on any platform that supports JVM (J2SE 1.5+) because the execution components are 100% pure Java.
Compatible with custom, composite and packaged applications
Apply to a wide range of application architectures, including web applications, SOAP-based or RESTful web services, and desktop applications. Most architectures can be accommodated because the runtime framework operates at the infrastructural component level.
Concurrent collection of performance data
Collect performance statistics for databases, web servers and application servers concurrent with test execution, so that root cause analysis can be performed the moment a test finishes.
Load Test Root Cause Analysis
Transparent transfer of load test resultsSpend zero time importing performance statistics because no import is necessary; RCA analysis and load test execution are fully integrated.
Advanced, cross-tier root cause analysisIdentify performance limiters down to the level of individual infrastructure components using data and results generated by load test. Visualize and correlate performance behavior across application tiers.
Automatic Bad SQL Identification
Automatic ranking of SQL by performance costs identifies poorly performing SQL code quickly and precisely. Load Test Reporting and AnalyticsLoad Performance ReportingGet immediate feedback on load performance through summary reports and charts of key performance statistics.
Scalability Index Reporting
Automatic calculation, reporting and charting of DBA InfoPower's scalability index for system under test (SUT).
Service Level Agreement (SLA) Compliance Reporting
Automatic calculation, reporting and charting of SLA compliance for system under test (SUT).
Executive-level Summary Report
Automatically generate summary test reports that highlight key findings in a concise format for busy CIOs and CTOs.
Open Data Repository
Apply other analytics tools to data generated by Load2Test. Its open data repository and published schemas enable easy access.
December 29th, 2008
DBA InfoPower - innovative software and services for enterprise performance problem management
Published on December 29th, 2008 @ 08:50:58 pm , using 150 words, 178 views
DBA InfoPower - innovative software and services for enterprise performance problem management.
Upgrade to Enterprise Performance Problem Management
Find and fix performance problems with unprecedented speed, accuracy, precision, and scope
Diagnose performance problems in databases, servers and networks
Assess scalability and validate performance in enterprise applications, web applications, and service-based applications
Protect your business-critical websites, data centers, and data warehouses against unplanned downtime
Explore Our Solutions
UpBeat
A comprehensive software suite for proactive problem identification, real-time performance remediation, and advanced problem diagnosis
Load2Test
An integrated software framework for scalable performance validation and accelerated problem resolution
EPPM
An extensible enterprise performance problem management platform that brings it all together
Explore Our Services
Performance Assessments
Receive recommended changes for applications and environments to optimize performance
Installation Services
Realize value sooner through fast, professional product installation and configuration
Training
Accelerate your learning curve through standard or custom product training delivered to you onsite
December 29th, 2008
Fedora-Hosting
Published on December 29th, 2008 @ 08:46:19 pm , using 25 words, 487 views
| Database Journal News |
|---|
|
September 3, 2010: Identifying and Eliminating the Dreaded Cartesian Product Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever. |
|
September 3, 2010: Top 9 SQL Server Developer Interview Questions The questions you may wish to ask or that will be asked during a SQL Server Developer interview will vary. Deanna Dicken shares the top 9 interview questions she asks when interviewing a potential SQL Server developer. |
|
September 2, 2010: Working with ADO.NET Data Service in a .NET Framework Client Application Learn how to consume and make use of the ADO.NET Data Service in a .NET Framework Client Application. This article demonstrates the process by creating a simple web application that uses an existing ADO.NET Data Service. |
|
September 2, 2010: Introduction to SQL Server Proactive Caching Arshad Ali explores Proactive Caching, available in SQL Server Analysis Services 2005 and later versions. Proactive Caching helps DBAs to better control the cube data automatic refresh frequency. Proactive Caching offers near real time data for reports, while at same time providing a query performance similar to MOLAP storage mode. |
|
September 1, 2010: Oracle Database 11g New Features for Table Partitioning Table partitioning is an option available to DBAs that can help them manage key database performance areas including i/o balancing, contention reduction, SQL statement performance improvements and even data availability. Oracle Database 11g adds some very powerful new table partitioning methods that can be implemented to help to achieve some of these goals. |
|
September 1, 2010: Microsoft Sync Framework Beefs Up Collaboration There is a growing trend to access applications that are not just confined to just the PC but also extend to the other usually connected devices such as mobile phones and Point-of-Sale terminals. Keeping data synchronized across different platforms is a difficult problem to solve and the Microsoft Sync Framework is Microsoft's solution to the problem. |
|
September 1, 2010: Top 5 Oracle Database PL/SQL Job Interview Questions It would be smart to brush up on your SQL when interviewing for a PL/SQL developer position. James Koopmann shares five questions that he has been asked when interviewing for both a DBA position and a PL/SQL developer position. |
|
August 31, 2010: Book Review: Access 2010 Programmer's Reference Back in June we evaluated four great Access 2010 books that had just been released. There's now another volume available written especially for programmers. Danny Lesandrini peeks inside to see if this book lives up to its name. |
|
August 31, 2010: Nine Steps to Troubleshooting SQL Server problems DBAs often have a need to identify why a problem has occurred, or is occurring in their SQL Server database. This article covers some of the tools you can use to look for clues, and the steps you might go through to help troubleshoot a SQL Server problem. |
|
August 30, 2010: CouchDB - The Open Source NoSQL Database CouchDB is a great example of forward-thinking technology that's worth a look even if you're not currently in need of a database solution. This article introduces you to CouchDB, showing you how to get started using this fascinating solution and even integrate it into your PHP website. |