DatabaseJournal.com Staff

By Jeffrey R. Garbus It’s that time again; Sybase (now an SAP company!) has added a suite of enhancements as an intermediary release (an “IR” rather than a full release), and it’s decision time. Do you upgrade? For most, an upgrade to an IR is not automatic; you either need the features that are coming […]

>>Script Language and Platform: T-SQL This script looks for all failed jobs in the last day. Author: Akhamie Patrick /*The next Script performs the same function as the one above but it displays failure date, job name, step id, step name and error message. I personally like this one alot, plus, to modify the timeline, […]

>>Script Language and Platform: SQL Server This script will create the base table, stored procedures, set up alert, Job for the dead lock. The output will send both xml and xdl file. XDL file is the deadloack graph that can be opened in SSMS. Author: Sathiyamoorthy Kunchithapatham –Enable the traceflag and server configuration dbcc traceon(1222,-1) […]

>>Script Language and Platform: Oracle Uploading a flat file into an Oracle database. Author: Lynette load data infile “F:Land BankIssues and Actions.csv” badfile “info.bad” discardfile “info.dis” into table issues_actions fields terminated by “,” ( section, issue, action, responsible, meeting ); sqlldr username/password@server control=info.ctl Disclaimer: We hope that the information on these script pages is valuable […]

»Database News » Current News » Archives »DBA Videos » Intro to VSTS-DB Edition » Intro to Databases » Access Database » Data Binding to Forms Made Simple in .Net 2.0 »Resources » Scripts » Links »Database Articles » Microsoft SQL Server » Oracle » DB2 » Microsoft Access » MySQL » PostgreSQL » PHP […]

LINBIT has announced their partnership with SkySQL; announcing their support and inclusion in the SkySQL reference architecture and aligning its offering through ongoing collaboration with SkySQL. Together, LINBIT and SkySQL bring a highly sophisticated HA database setup to customers at a low cost; delivering complete HA support for MySQL database deployments.

AppDynamics announces major release of Appdynamics 3.2, an application performance management (APM) for Big Data technologies. Along with the ability to help agile teams manage release cycles, the new release gives application owners a powerful solution for reducing problem resolution cycles from hours to minutes. Included with Appdynamics 3.2, Appdynamics offers big data performance monitoring, […]

Couchbase recently went through a merger with Membase and has, this April 2011, been recognized as a “Cool Vendor” by Donald Feinberg and Eric Knipp of Gartner, Inc. within Infrastructure management. Couchbase products are a comprehensive family of NoSQL database solutions and built on Apache CouchDB, Membase, and Memcached open source software.

Solix’s Enterprise Data Management Suite (EDMS) 4.5.1 has achieved Oracle validation Integration with Oracle’s PeopleSoft enterprise 9.1; making it possible to build criteria based business rules, policies, and retention periods into configurations as well as managing data growth, archive inactive data, and maintain access to data.

Precise has announced new capabilities for monitoring Java clusters; giving application owners and Java administrators the ability to quickly and easily find root causes for problems in clustered applications with Precise version 9.0 . With Precise 9.0, users can automatically analyze load balancing patterns, find tuning opportunities, and detect new JVMs that have been added; […]

Application Security, Inc’s TeamSHATTTER again gains creditability through the discovery of two-thirds of the disclosed database flaws in recent Oracle Critical Patch Update (CPU). Noteworthy is TeamSHATTER researcher Esteban Martinez Fayo who was is credited for four of the six database vulnerabilities. Specifically CVE-2011-0785, CVE-2011-0787, CVE-2011-0793, and CVE-2011-0806.

Talend and Ingres partnership benefits data management professionals by certifying their data management solutions to VectorWise; giving data management professionals out-of-the-box data integration and data quality for an industry database for business intelligence reporting and analytics. The partnership will give IT and data management professionals to integrate data from their systems and provide users with […]