Database Engine
37 Stories
Net Integrator Micro
Reviews Despite its small size, the Net Integrator Micro is well specified and offers a good mix of network productivity applications and security tools.
Microsoft, Satyam to develop BI apps for Asia
News Companies launch centers in Shanghai and Singapore to create and test new business intelligence solutions for the financial services sector.
Tags: Data warehousing/business intelligence, Product development and design
Causes of Access corruption
Insight Anyone who uses Microsoft Access is likely to have had problems with database corruption. The problem with a multiuser environment is that it is distributed, and the MDB file has to be shared between many users in different locations on the network.
Defining SQL Server 2008 policies
Techguide Learn how you can use SQL Server Management Studio to define your own policies.
Tags: Microsoft Windows, Data Management, Microsoft SQL Server, Database, Policy, Microsoft SQL Server Management Studio, stored procedure, database engine, Condition, Facet
MySQL ex-CEO tells EU to let Oracle buy Sun
News Marten Mickos urges EU antitrust regulators to approve Oracle's Sun acquisition, arguing that delay hurts customers and that Oracle won't sink Sun's MySQL group.
Tags: Open source, Business applications, Acquisitions, Regulations, Open Source, Database, Commission, European Commission, Business applications, MySQL ex-CEO
Use Object Dependencies to your advantage in SQL Server
Techguide SQL Server 2008 tracks objects by the name of the object, rather than relying upon the ID. Here’s how it works.
Tags: Databases, App servers, Server platforms, Object, Microsoft SQL Server, Dependency, Database, SQL, stored procedure, SalesHistory
Google's Gears turns one
News The project formerly called 'Google Gears' is increasingly being used to make online apps function when connectivity is unavailable.
Tags: Database management, Web services, Web browsers, Google Gears, Google Inc., Database, software, Mozilla Firefox 3.0, Opera Software, desktop
See performance gains by using indexed views in SQL Server
Techguide When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if indexed views will be beneficial to your database.
Microsoft investigates targeted Word security flaw
News Security risk, stemming from Jet Database, considered low because it requires users to go through multiple steps.
Tags: Microsoft Office, Security
Get your feet wet with Sun's tiny Java DB
Techguide Java DB is a lightweight, standards-based database management system that is written completely in Java and can be embedded into applications.
Tags: Database management, Java
Diagnose performance issues via sp_lock
Techguide A common misconception among IT pros is that "locks are bad", and you must do everything possible to ensure database locking doesn't prevent processes from running.
Tags: Microsoft Server 2003
Microsoft fixes critical holes in Windows, Word, Publisher
News Company's Patch Tuesday release includes fixes for six vulnerabilities, including some critical ones.
Tags: Security, Personal applications, Microsoft Windows, Microsoft Corp., Microsoft Windows Live, Zero-day Bug, Vulnerability, operating system, critical patch, malicious program
Unpatched flaw found in Microsoft software
News Software maker investigates report of hole in Office and Access--and of published exploit code that could let attackers take control of PCs.
Tags: PC security, Security
Use PHP with SQLite database for more possibilities
Techguide This tutorial will show you how to use PHP to interact with an SQLite database, by introducing you to the important methods supported by the SQLite API, and providing a simple script template for you to use in your development.
Two undocumented SQL Server procedures you should know
Techguide Here's a look at how you can use two built-in system stored procedures to iterate through SQL Server tables and databases.
Tags: Servers, Software, Microsoft Corp., Microsoft SQL Server, Backup, Database, Microsoft SQL Server 2000, question mark, stored procedure, Chapman Co.
