DatabaseJournal.com Staff

[From SearchWinIT] SQL Server and Microsoft Office SharePoint Server 2007 are intricately connected with SQL Server as the back-end data repository for Office SharePoint Server 2007. Administrators sometimes have difficulty understanding this relationship, which can prevent them from having a full appreciation for it. One of the main challenges faced by SharePoint administrators when managing […]

[From Linux Magazine] In the last year a handful of MySQL and memcached appliances have appeared on the market. These tend to be 2U rackmount servers that you treat as a black box (or something approaching one) and reap some sort of substantial performance benefit along the way. Most of these appliances have a mix […]

>>Script Language and Platform: Oracle In one of our applications, a tool dumps few hundred files into a directory with extension *.dat everyday. Inside each file, the 3rd pattern “<>” in the lines that contain the word “jp_directory” is left blank. I need to come up with a shell script to go through each file […]

[From PRWeb] Jerusalem, Israel (PRWEB) July 29, 2009 — DBSophic, a developer of innovative software solutions for database performance optimization, today announced the launch of its new Trace Analyzer tool for Microsoft SQL Server. This innovative tool, which can be downloaded from the company’s web site, free of charge, allows users to instantly find out […]

by JP Vijaykumar Many times readers send questions about how to handle foreign key constraints, when the primary key constraints on the parent tables have been altered. Some readers asked for scripts to disable and re-enable foreign key constraints on all of the tables in a schema, as full/partial schema refreshes across environments are a […]

>>Script Language and Platform: SQL From an idea of MAK’s, [Muthusamy Anantha Kumar] this procedure deletes files that are older than a certain period from a folder and (optional) files inside a subfolder if oldest. Author: CHM Download Script: delete-files-and-subfolder.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your […]

[From AvePoint, Inc.] AvePoint, provider of infrastructure management software solutions for Microsoft SharePoint, today announced the free release of the DocAve SQL Restore Controller. This tool enables the full fidelity, item-level restoration of SharePoint content from native SQL database backups, as well as databases restored by any third-party SQL backup tool, including Microsoft’s Data Protection […]

[From SAP] PALO ALTO, Calif. and WALLDORF, Germany – July 20, 2009 – SAP AG today announced enhancements to SAP BusinessObjects Data Services and SAP BusinessObjects Data Federator software, part of SAP BusinessObjects information management (IM) solutions. These solutions support both SAP and non-SAP IT environments, and today have expanded support for SAP customers with […]

[From PublicTechnology.net] The hacker attacks on Web sites in South Korea – which spilled over to selected US government sites last week – were almost certainly orchestrated by hackers sympathetic to North Korea, but the attacks could have been organized by anyone with a modest budget, says Imperva, the data security specialist. A raft of […]

[From Microsoft] Wednesday, July 29, 2009 10:00 AM Pacific Time The latest Microsoft MapPoint add-in connects Microsoft SQL Server spatial data directly to MapPoint. Now, MapPoint can now act as an easy, quick, powerful visualization tool for geographic and spatial data stored in SQL Server, which gives both SQL Server and MapPoint a competitive edge […]

[From Computerworld Blogs] Yahoo just added insert, update and delete capability to YQL, its SQL-like query language for data on the Web. This will let YQL be used in applications that do things like create Twitter tweets or update social media status information — pretty much anything you can do now via a Web-based form, […]

[From eWeek] VMware is hoping to entice Virtual Iron customers away from Oracle, which bought Virtual Iron in May. Oracle reportedly is telling Virtual Iron partners that it is halting development of Virtual Iron products and will integrate the technology into its own Oracle VM platform. VMware is offering discounts on products, including its new […]