| 184 Software - DataBase Resources |
| 10 secret MySQL client startup options you should know
|
| The standard MySQL client comes with a large number of startup options, some of which are extremely useful in daily MySQL interaction. Several of the less well-known startup options available for the MySQL client program are explored and explained.
|
| Open |
Open Tab |
|
Provides Information |
| 10 tips for sorting, grouping, and summarizing SQL data
|
| Arranging SQL data so that you can effectively analyze it requires an understanding of how to use certain SQL clauses and operators.
|
| Open |
Open Tab |
|
Provides Information |
| 10+ tips for working efficiently in Access' Query Design window
|
| If you create Access queries, you probably know your way around the Query Design window. But there are some not-so-obvious tricks you can use to work more efficiently, maintain accuracy, and ensure database integrity.
|
| Open |
Open Tab |
|
Provides Information |
| A |
| A Look At April's Mass SQL Injection Attack For ASP.Net / SQL Server SQL Server Environments
|
| What caught my attention was the fact that so far, attackers would go for specific sites. But this time around, they used a sophisticated tool that would scan the entire web for potentially weak sites running ASP.Net and therefore, quite possibly SQL Server and use a generic SQL Server feature on all those sites to wreck serious damage.
|
| Open |
Open Tab |
June 16, 2008 |
Provides Information |
| Achieve high availability with log shipping in SQL Server 2000
|
| Log shipping is a technology in SQL Server that database administrators can use to provide a standby database to failover to in the event of a primary database failure.
|
| Open |
Open Tab |
|
Provides Information |
| Add a calculated field to your Access form
|
| Need to add a calculated field to an Access form? It's easy, and you can do it on the fly. Just add a new text box control with the appropriate formula as its control source.
|
| Open |
Open Tab |
|
Provides Information |
| Add pictures to your Access tab controls
|
| Say it with a picture—by adding a picture to your Access tabs! Mary Ann Richardson explains how you can create visual aids by adding pictures to your Access tabs.
|
| Open |
Open Tab |
|
Provides Information |
| Add some curves to your SQL Server Model database
|
| Find out why Arthur Fuller believes that the Model database is the most overlooked and underused feature in SQL Server. He presents a sample demonstration of how you might use the Model database.
|
| Open |
Open Tab |
|
Provides Information |
| Adobe throws weight behind SQLite
|
| Adobe Systems has confirmed it will help sponsor the work of the SQLite database project, joining a new consortium alongside Mozilla and Symbian.
|
| Open |
Open Tab |
February 26, 2008 |
Provides Information |
| Advanced Oracle Online Training.
|
| Oracle and oracle 8 tutorials are available online for your in home study.
|
| Open |
Open Tab |
|
Provides a Service |
| Amazon set to start testing Web database
|
| Says SimpleDB technology will support fast queries of structured data.
|
| Open |
Open Tab |
December 14, 2007 |
Provides Information |
| Another Amazon 'cloud' database, but this one will be Oracle-compatible
|
| Upstart EnterpriseDB says it will start testing an online version of its software in March.
|
| Open |
Open Tab |
January 29, 2008 |
Provides Information |
| App Server Vendor BEA Systems In Play, Rejects Oracle Offer
|
| The friction in the extremely competitive applications server market turned up considerably this week, as one of the companies perceived as tied for third in market share issued a buyout bid on Tuesday for the company it's tied with.
|
| Open |
Open Tab |
October 12, 2007 |
Provides Information |
| Applied reflection: Write 80 percent less access code when interacting with a database
|
| With databases behind virtually every application, quite a bit of time is spent by application developers writing code to interact with databases. Zach Smith explains how to combine the Microsoft Data Access Block in .NET with custom reflection code to write 80 percent less data access code.
|
| Open |
Open Tab |
|
Provides Information |
| Argentum Software
|
| Argentum Corporation - Cataloging Software, Backup Software, Database Software.
|
| Open |
Open Tab |
|
Provides Products |
| Audit data using SQL Server 2005's COLUMNS_UPDATED function
|
| DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names.
|
| Open |
Open Tab |
|
Provides Information |
| Automate the process of trimming table data in SQL Server 2005
|
| Arthur Fuller recently instructed a colleague on how to automate the process of trimming table data in SQL Server 2005. Find out how he is able to turn an onerous task into a breeze.
|
| Open |
Open Tab |
|
Provides Information |
| B |
| Back to basics for SQL Server 2008
|
| When I asked: "How do we convert more than 12,000 location items - by hand?" we had almost completed the process as part of our move to Microsoft's up-coming SQL Server 2008.
|
| Open |
Open Tab |
February 14, 2008 |
Provides Information |
| Beefing up SQL Server 2005 Express Edition
|
| Get the full benefits of SQL Server 2005 Express Edition by downloading the extended versions from Microsoft's site. If you're still hemming and hawing about whether you need the Express Edition, find out when it may come in handy.
|
| Open |
Open Tab |
|
Provides Information |
| Build a data-bound grid with C# and ADO.
|
| Irina Medvinskaya examines how to access SQL Server-based data using C# and ADO.NET and display the data in a data-bound grid control.
|
| Open |
Open Tab |
|
Provides Information |
| C |
| Calculate columns and averages with SQL Server's HAVING clause
|
| Arthur Fuller gives a brief overview of SQL Server's HAVING clause and provides code examples that demonstrate how to use it. For instance, he shows how to use HAVING to test aggregates based on a child table.
|
| Open |
Open Tab |
|
Provides Information |
| Capture an Oracle 10g audit trail in XML format
|
| Oracle 10g can be configured to write its audit logs to XML files in operating system directories. This tip shows the configuration changes that need to be made, as well as how to access the resulting XML files.
|
| Open |
Open Tab |
|
Provides Information |
| Check out this easy way to find Oracle version information
|
| The PL/SQL package DBMS_DB_VERSION supplies several useful constants that you can use in your code to determine the currently running version of Oracle.
|
| Open |
Open Tab |
|
Provides Information |
| Comparing Oracle 10g column masking to relational views
|
| Thanks to the suggestion of TechRepublic member BrooklynPennyPincher, this Oracle tip compares two approaches to hiding column-level data on a report: the Virtual Private Database and relational views.
|
| Open |
Open Tab |
|
Provides Information |
| Components of a Service Broker application in SQL Server 2005
|
| SQL Server 2005 Service Broker applications provide powerfully robust functionality that allow for scalability and asynchronous processing. Tim Chapman takes a look at how you can use Service Broker to model business processes.
|
| Open |
Open Tab |
|
Provides Information |
| Connect to MySQL in OpenOffice.org
|
| Vincent Danen tells you how easy it is to connect to databases using OpenOffice.org.
|
| Open |
Open Tab |
|
Provides Information |
| Copy legacy Oracle tables with SQL*Plus
|
| Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. Bob Watkins shows you how in this Oracle tip.
|
| Open |
Open Tab |
|
Provides Information |
| Convert databases to different platforms using RMAN
|
| The Oracle Database supports the direct movement of tablespaces from one instance of Oracle to another. In the past, the destination was required to use the same operating system platform as the original. Oracle 10g contains tools in the Recovery Manager (RMAN) to extend these moves to other platforms.
|
| Open |
Open Tab |
|
Provides Information |
| Create a new warning for Access record deletion
|
| If you have started to glaze over the message you get whenever you delete an Access record, you may want to record a message that is more likely to grab your attention.
|
| Open |
Open Tab |
|
Provides Information |
| Create a quick report for a filtered table in Access
|
| Access' table filtering tools are handy, but they can be unwieldy and produce results that look unprofessional. Here's how to use AutoReport to create sharp and specific records based on the data of your choice.
|
| Open |
Open Tab |
|
Provides Information |
| CTP for SQL Server 2008 now available
|
| Its final release has been pushed back to as much as six months after Microsoft's big launch party for it, which is still slated for next week. In the meantime, potential customers are being given a taste of some new and game-changing functionality.
|
| Open |
Open Tab |
February 20, 2008 |
Provides Information |
| Cut development time with SQL Server 2005's synonyms
|
| SQL Server 2005's synonyms allow you to give an alias to an already existing object. Realize the benefits of synonyms by using them as a layer of abstraction between the underlying objects and the synonym.
|
| Open |
Open Tab |
|
Provides Information |
| D |
| Database and Information Systems
|
| research projects involve knowledge discovery, high dimensional access methods.
|
| Open |
Open Tab |
|
Provides Information |
| Database DebunkIing
|
| Site dedicated to dispelling fallacies and misconceptions prevailing in the database industry.
|
| Open |
Open Tab |
|
Provides Information |
| Database gurus slammed for Google post
|
| MapReduce: a "major step backwards".
|
| Open |
Open Tab |
January 24, 2008 |
Provides Information |
| Database Normalization and Table structures
|
| Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form).
|
| Open |
Open Tab |
|
Provides Information |
| Database Research at Waterloo
|
| Research areas include traditional relational database systems, complex objects, geometric data, text, and real-time data.
|
| Open |
Open Tab |
|
Provides Information |
| Database Research Group, University of Maryland
|
| Information on people, projects, courses and database-related events and activities.
|
| Open |
Open Tab |
|
Provides Information |
| Database spin on Sun's Python hires
|
| Sun Microsystems has furthered its ambitions in open source development by hiring top Python developers Ted Leung and Frank Wierzbicki.
|
| Open |
Open Tab |
March 4, 2008 |
Provides Information |
| David Consulting Group
|
| DCG services include software metrics, software process improvement and outsourcing.
|
| Open |
Open Tab |
|
Provides Information |
| Dealing with case and accents in SQL Server
|
| Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation.
|
| Open |
Open Tab |
|
Provides Information |
| Defining SQL Server constraints with TSQL
|
| Take your database administration skills to the next level by learning how to define constraints with TSQL. This advanced skill shows that you don't always rely on graphical interfaces when designing database objects.
|
| Open |
Open Tab |
|
Provides Information |
| Delete rows during updates using Oracle 10g's MERGE statement
|
| In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works.
|
| Open |
Open Tab |
|
Provides Information |
| Detect hierarchy loops with Oracle 10g's new hierarchy pseudocolumns
|
| Hierarchical queries sometimes fail because the data contain rows that reference each other: a loop. Oracle 10g has syntax and two new pseudocolumns to aid in finding such loops.
|
| Open |
Open Tab |
|
Provides Information |
| Display an hourglass while your Access application is running
|
| Access may be loading or executing its macros when opened, but it's often hard to tell where it is in the process. In this tip from Mary Ann Richardson, learn how to set up Access to display an hourglass to let you know when it's safe to begin working.
|
| Open |
Open Tab |
|
Provides Information |
| Don't overlook STATSPACK in Oracle 10g
|
| Bob Watkins passes along a tip from a local Oracle Users Group seminar: don't ignore STATSPACK in Oracle 10g. It's still there, and it has some great new measurements.
|
| Open |
Open Tab |
|
Provides Information |
| E |
| Easily create report snapshots of your Access files
|
| Say cheese! Rather than sending the entire Access file to another user, you can create snapshots of relevant reports. Mary Ann Richardson explains how to do it in a snap.
|
| Open |
Open Tab |
|
Provides Information |
| Easy code archiving in SQL Server 2005
|
| DBA Tim Chapman extols one of the virtues of SQL Server 2005 is the ability to return the entire code of an object from a system function. He notes that this function will make it much easier to archive your procedure code.
|
| Open |
Open Tab |
|
Provides Information |
| Embarcadero Ships SQL IDE
|
| Embarcadero Technologies Inc. has announced a new Eclipse-based SQL development tool, PowerSQL.
|
| Open |
Open Tab |
March 17, 2008 |
Provides Information |
| Enable Change Tracking in Oracle for faster incremental backups
|
| DBAs can do incremental backups made via Recovery Manager significantly faster by enabling a new Oracle 10g feature called Change Tracking.
|
| Open |
Open Tab |
|
Provides Information |
| Encrypt backups using Oracle 10gR2's RMAN
|
| No IT pro wants their company to make headline news because of a data breach. You can make your data less vulnerable to theft by using a new feature in Oracle 10g Release 2 that lets you make encrypted backups via Recovery Manager.
|
| Open |
Open Tab |
|
Provides Information |
| Erlangen University Department of Database Systems
|
| Research projects include data warehousing, scientific database management, workflow management, and distributed data.
|
| Open |
Open Tab |
|
Provides Information |
| Examine user creation scripts before migrating to Oracle 10gR2
|
| Takeaway: Oracle has changed the meaning of the standard CONNECT role in 10g Release 2 (10gR2). Be sure to examine any scripts your organization uses that create new database user accounts before migrating to this version.
|
| Open |
Open Tab |
|
Provides Information |
| Exchange 2007 Exchange System Manager first impressions
|
| One IT pro's first impressions of the new Exchange System Manager which is included in the next version of Exchange.
|
| Open |
Open Tab |
|
Provides Information |
| Exploring the window functions in SQL Server 2005
|
| SQL Server 2005's window functions allow you to look at different levels of aggregation all at one time. Here's to use the OVER(…) clause to gather a collection of statistics.
|
| Open |
Open Tab |
|
Provides Information |
| F |
| Find sequence runs using Oracle's analytic functions
|
| Bob Watkins responds to TechRepublic member Sachin Jayashekhar's question about detecting sequence runs within a group of rows, and provides a sample script that selects the first and last value in each run.
|
| Open |
Open Tab |
|
Provides Information |
| Five useful dynamic management objects in SQL Server 2005
|
| SQL Server 2005 is packaged with new object types known as dynamic management objects. These objects can return the state of the database for a given point in time.
|
| Open |
Open Tab |
|
Provides Information |
| G |
| Gather query tuning data via Oracle's dynamic performance views
|
| The dynamic performance views supplied with the Oracle database include several that make the process of gathering tuning information easier. This tip describes four of them: V$SQL, V$SQLAREA, V$SQLTEXT, and a new one, V$SQLSTATS.
|
| Open |
Open Tab |
|
Provides Information |
| Generate external table definitions from SQL*Loader
|
| External tables in Oracle enable you to query text files with the full power of the SQL language. Here is a quick way to create them using scripts generated by SQL*Loader.
|
| Open |
Open Tab |
|
Provides Information |
| Generate synchronization scripts in SQL Server with TableDiff
|
| TableDiff is a console executable that allows you to compare data between SQL Server tables. Plus, since it is packaged with SQL Server, you don't need to buy additional tools when you want to examine lookup tables in different database environments.
|
| Open |
Open Tab |
|
Provides Information |
| Get more data comparison options in MySQL with operators you may not know
|
| Some of the less well-known data comparison functions and operators in MySQL are examined and how they may be used to compare strings, numbers and dates/times across table fields or user-supplied values are discussed.
|
| Open |
Open Tab |
|
Provides Information |
| Get out of a jam by using SQL Server's DBCC
|
| Arthur Fuller reveals why you should get to know the database consistency check (DBCC). He also explains how to run DBCC and how to use five of its extensions.
|
| Open |
Open Tab |
|
Provides Information |
| Google gets jiggy with MySQL
|
| MySQL and Google have quietly tied up a coding deal seen as an integral part of the open source database firm's software roadmap for the next few years.
|
| Open |
Open Tab |
October 25, 2007 |
Provides Information |
| H |
| Hackers Exploit Access Database Flaw
|
| A hole in Microsoft's Access database permits hackers to install software on vulnerable systems, the US-CERT team warns.
|
| Open |
Open Tab |
December 12, 2007 |
Provides Information |
| Half Million Database Servers Lack Firewall Security
|
| Think your database server is safe? You may want to double-check. According to security researcher David Litchfield, there are nearly half a million database servers exposed on the Internet, without firewall protection.
|
| Open |
Open Tab |
November 14, 2007 |
Provides Information |
| Hide sensitive data with Oracle 10g column masking
|
| Oracle 10g's Virtual Private Database (VPD) feature has the ability to automatically mask out (set to NULL) certain columns in the results of a query on a row-by-row basis. This tip shows how to create a VPD policy that requests the column masking option.
|
| Open |
Open Tab |
|
Provides Information |
| How do I… Install, configure and integrate PHP and MySQL on Windows?
|
| PHP and MySQL are a powerful combination when it comes to providing dynamic content to your user base. Get the step-by-step instructions for installing and configuring these products in a Microsoft Windows environment.
|
| Open |
Open Tab |
|
Provides Information |
| How do I... Obtain and use information about runtime errors in Access applications?
|
| To make sure a runtime error doesn't derail your Access applications, you should include error handling that ignores or fixes the error and continues processing, requests information from the user and then uses that information to continue processing, or terminates the current process without crashing the database.
|
| Open |
Open Tab |
|
Provides Information |
| How much will Oracle put up to regain its database stronghold?
|
| Oracle may be willing to spend a record sum -- over $6 billion -- to acquire a middleware provider it believes will give it a permanent leg up on Microsoft's SQL Server.
|
| Open |
Open Tab |
December 21, 2007 |
Provides Information |
| How to Deal with Oracle Licenses
|
| Oracle customers got some advice on how to get the best deal and protect themselves while licensing software from the enterprise software giant.
|
| Open |
Open Tab |
February 6, 2008 |
Provides Information |
| HP Simplifies Database Archiving Deployments
|
| Enhanced software supports customer compliance and e-discovery initiatives.
|
| Open |
Open Tab |
May 15, 2008 |
Provides Information |
| I |
| IBM buys in-memory database company Solid
|
| Solid makes an embedded database with an in-memory database engine, which means it can store and retrieve data from main memory, giving faster performance than traditional disk-based systems.
|
| Open |
Open Tab |
December 21, 2007 |
Provides Information |
| IBM says it has 'no plans' to open-source DB2 database
|
| Published report quotes U.K. exec on possible move due to changing market conditions.
|
| Open |
Open Tab |
June 16, 2008 |
Provides Information |
| IBM to Acquire Data Management Specialist
|
| IBM is buying Princeton Softech, a privately held company specializing in data archiving, test data management, data privacy, and data classification and discovery software.
|
| Open |
Open Tab |
August 3, 2007 |
Provides Information |
| Inside the Windows 2008 stack experience
|
| The project is using nothing less than upgrades to a trio of big-ticket products from Microsoft - Visual Studio 2008, Windows Server 2008, and SQL Server 2008 - that are due next month.
|
| Open |
Open Tab |
January 24, 2008 |
Provides Information |
| Installing SQL 2000 and SQL 2005 on the same server
|
| In case you were wondering, yes it is possible to install SQL 2000 and SQL 2005 (even the free Express version) on the same server, without conflicts. This article assumes you already have SQL 2000 installed, and want to install SQL 2005 Express next to it.
|
| Open |
Open Tab |
July 16, 2008 |
Provides Information |
| Introduction to message-based applications in SQL Server 2005
|
| Tim Chapman discusses the concept of message-based applications, and the new foundation for building these applications included in SQL Server 2005.
|
| Open |
Open Tab |
|
Provides Information |
| Is Oracle really the next Microsoft?
|
| The gobbling-up by Oracle of BEA, the last significantly-sized independent middleware vendor, is another sign of the trend we are seeing towards increasing consolidation in the IT industry. It leads to obvious questions about customer choice, disruption, and protection of investment that will sound very familiar to those impacted by previous acquisitions, such as Oracle’s less than harmonious takeover of PeopleSoft in the ERP space.
|
| Open |
Open Tab |
January 24, 2008 |
Provides Information |
| It doesn't take much to master MySQL
|
| MySQL is commonly used within web applications and acts as a database component of the LAMP, MAMP and WAMP platforms.
|
| Open |
Open Tab |
November 5, 2007 |
Provides Information |
| L |
| Look inside ASM disk groups with Oracle 10gR2's ASMCMD
|
| In Oracle 10g Release 2, Oracle introduced a new command line tool called ASMCMD that lets you look inside Automatic Storage Management (ASM) volumes. Get an overview of the ASMCMD commands, and learn about a few of the tool's quirks.
|
| Open |
Open Tab |
|
Provides Information |
| M |
| Massive Attack: Half A Million Microsoft-Powered Sites Hit With SQL Injection
|
| A new SQL injection attack aimed at Microsoft IIS web servers has hit some 500,000 websites, including the United Nations, UK Government sites and the U.S. Department of Homeland Security. While the attack is not necessarily Microsoft's fault, it is unique to the company's IIS server.
|
| Open |
Open Tab |
April 28, 2008 |
Provides Information |
| Microsoft and HP tackle SQL-injection scourge
|
| With successful attacks against websites reaching epidemic levels, Microsoft and HP have released a free set of tools that help developers check their web applications for the mistakes that leave them open to exploits that can steal sensitive information and harm visitors.
|
| Open |
Open Tab |
June 26, 2008 |
Provides Information |
| Microsoft delays SQL Server 2008 release again
|
| Redmond has scaled back its ambitious plans to get the server party started by sidelining its 2008 version of sequel server – which was originally supposed to hit manufacturing at the end of last year – to the third quarter.
|
| Open |
Open Tab |
January 28, 2008 |
Provides Information |
| Microsoft Demos SQL Server 2008
|
| The next version of the database should be shipped on the three-year refresh schedule.
|
| Open |
Open Tab |
September 25, 2007 |
Provides Information |
| Microsoft denies a link between IIS and SQL injection attacks
|
| An apparent rash of SQL injection attacks on Web sites was reported by a Finnish security firm late last week, though a case of "guilt by implication" led to speculation that a privilege escalation vulnerability was the cause.
|
| Open |
Open Tab |
April 28, 2008 |
Provides Information |
| Microsoft gets more pro-active against SQL injection attacks
|
| Turning up the volume on its vigilance against perhaps the easiest exploit in the world, Microsoft yesterday unveiled a new beta of an overdue security tool for IIS 7, bolstered by two new SQL injection vulnerability seeker tools.
|
| Open |
Open Tab |
June 25, 2008 |
Provides Information |
| Microsoft Gives Scientists Data-Mashing Tips
|
| The American Geophysical Union got a peek at techniques and tools from Microsoft Research's eScience group.
|
| Open |
Open Tab |
December 16, 2007 |
Provides Information |
| Microsoft prepares to sell SQL Server 2008
|
| Microsoft's SQL Server 2008 appears ready to go after months of delay, as the company is taking steps to begin selling the database.
|
| Open |
Open Tab |
July 9, 2008 |
Provides Information |
| Microsoft Releases Another SQL Server 2008 CTP
|
| This third update includes compatibility with Windows Vista and the upcoming Windows Server 2008.
|
| Open |
Open Tab |
November 12, 2007 |
Provides Information |
| Microsoft reveals its database for the cloud
|
| It was a curious move for an offering that, as Microsoft's database service for the internet, marks the company's foray into database-based utility computing and promises an architecture that extends Microsoft's popular SQL Server database.
|
| Open |
Open Tab |
March 10, 2008 |
Provides Information |
| Microsoft snags Google-thrashing data pioneer
|
| Microsoft has recruited database guru David DeWitt to head up a new database research lab. Based at the University of Wisconsin, Madison, where DeWitt was until recently professor of computing sciences, the new lab will focus on advanced data-management techniques.
|
| Open |
Open Tab |
April 28, 2008 |
Provides Information |
| Microsoft talks Sync and BI for SQL Server 2008
|
| Microsoft used its TechEd Developer Conference in Barcelona Monday to announce details of new features in SQL Server 2008, due next February.
|
| Open |
Open Tab |
November 5, 2007 |
Provides Information |
| Microsoft to Offer SQL Server 2005 SP3
|
| Microsoft will release a third service pack for SQL Server 2005, just before the next version of the server software comes out.
|
| Open |
Open Tab |
April 16, 2008 |
Provides Information |
| Minimize the size of tempdb in SQL Server
|
| These tips will help you optimize your system's use of tempdb.
|
| Open |
Open Tab |
|
Provides Information |
| Mixing the bill of materials formula with SQL Server
|
| Question: What do you get when you combine SQL Server, bill of materials, and cooking? Answer: A useful tip for figuring out what recipes you can make based on the ingredients you have on hand.
|
| Open |
Open Tab |
|
Provides Information |
| Modifying execution context in SQL Server 2005
|
| Tim Chapman outlines how you can use the EXECUTE AS clause to change execution context in SQL Server 2005. He then shows how you can use this clause to impersonate the owner of a table in a schema.
|
| Open |
Open Tab |
|
Provides Information |
| Move SQL Tuning Sets between Oracle instances
|
| SQL Tuning Sets (STS) capture the workload of an Oracle instance. Starting in Oracle 10g Release 2, these tuning sets can be transported from one instance to another to facilitate testing.
|
| Open |
Open Tab |
|
Provides Information |
| MySQL loses joint custody of SAP database
|
| MySQL today stopped being a reseller for MaxDB, the database formerly known as SAP DB. MySQL, best known for its eponymous open source database software, had been a reseller and developer of MaxDB since 2003.
|
| Open |
Open Tab |
October 3, 2007 |
Provides Information |
| MySQL Releases Database Connector Beta
|
| A beta version of MySQL Connector/ODBC 5.1 is available, with Unicode support.
|
| Open |
Open Tab |
December 14, 2007 |
Provides Information |
| MySQL Remains 'Fully Functional and Open Source'
|
| When Sun announced it would offer certain plugins and features for enterprise customers only, and maybe even make them closed-source, the open source community was up in arms. It seems that MySQL and Sun have listened to the criticism, as these plans are now off the table. In fact, these plans did not originate within Sun in the first place.
|
| Open |
Open Tab |
May 8, 2008 |
Provides Information |
| MySQL tries twice to clarify its commercial software stance
|
| You actually need a reliable database to keep track of the multitude of permutations deriving from MySQL executives' recent comments defending their company's right to make money off of its product.
|
| Open |
Open Tab |
May 7, 2008 |
Provides Information |
| N |
| New buffer overrun exploit threatens old Jet database engine on XP
|
| A few weeks after a security laboratory found what it claimed to be an unchecked relationship between an old database provider and Word, Microsoft indicated that someone out there may still be trying this old attack vector.
|
| Open |
Open Tab |
March 24, 2008 |
Provides Information |
| No Price Hike for SQL Server
|
| Microsoft's updated server database will support new data types and schema, but not a new price.
|
| Open |
Open Tab |
September 29, 2007 |
Provides Information |
| O |
| On deck from Oracle: 45 critical database, server patches
|
| Database server giant Oracle plans to ship patches for a total of 45 security vulnerabilities on Thursday (July 17), bringing the vulnerability count for 2008 to a whopping 112.
|
| Open |
Open Tab |
July 14, 2008 |
Provides Information |
| Open-Source Databases MySQL, PostgreSQL, Adoption Rising
|
| Open-source databases MySQL and PostgreSQL are gaining steam, but rip-and-replace situations where MySQL and PostgreSQL replace Oracle Database, IBM DB2 or Microsoft SQL Server databases remain rare.
|
| Open |
Open Tab |
July 21, 2008 |
Provides Information |
| Optimize database code to boost performance
|
| Tony Patton offers .NET developers a few guidelines for developing efficient database code. For instance, he explains when to use the WHERE clause and reveals what code to avoid.
|
| Open |
Open Tab |
|
Provides Information |
| Oracle Behind Microsoft on Patch Management
|
| Database expert says Oracle has something to learn from Microsoft about patch management.
|
| Open |
Open Tab |
March 13, 2008 |
Provides Information |
| Oracle CEO Touts Fusion Applications
|
| Oracle CEO Larry Ellison didn't display much of his traditional flamboyance Wednesday at Oracle's OpenWorld conference, but he did preview the company's next-generation Fusion Applications and said its Unbreakable Linux offering has met with initial success.
|
| Open |
Open Tab |
November 15, 2007 |
Provides Information |
| Oracle Database 11g Ready for Linux
|
| Oracle made three versions of Oracle Database 11g available for Linux x86: Enterprise Edition, Standard Edition and Standard Edition One. Pricing for Oracle Database 11g editions and existing options remains unchanged from the cost of 10g. Prices are available online.
|
| Open |
Open Tab |
August 14, 2007 |
Provides Information |
| Oracle database roadmap builds over Raw Iron
|
| Oracle has acknowledged past mistakes by laying out a database development roadmap intended to make high-end capabilities more generally available.
|
| Open |
Open Tab |
November 13, 2007 |
Provides Information |
| Oracle Embraces Web 2.0 Technologies
|
| The software vendor looks to wikis, social networking and tagging in its application development.
|
| Open |
Open Tab |
November 14, 2007 |
Provides Information |
| Oracle Expands Access to Key Database Feature
|
| Oracle has extended support for Real Application Testing, a key option in its 11g database, to all 10g releases and 9i Release 2.
|
| Open |
Open Tab |
July 10, 2008 |
Provides Information |
| Oracle fixes critical flaws in quarterly update
|
| 26 fixes made; nine repair flaws that can be exploited remotely.
|
| Open |
Open Tab |
January 16, 2008 |
Provides Information |
| Oracle Issues 41 Security Fixes in Latest CPU
|
| Oracle plugs a critical security hole in Oracle Application Server in its latest round of patches.
|
| Open |
Open Tab |
April 15, 2008 |
Provides Information |
| Oracle launches data-integration suite
|
| Oracle Corp. on Monday launched Oracle Data Integration Suite, which combines traditional data-integration capabilities with an array of middleware and tools for constructing a service-oriented architecture (SOA).
|
| Open |
Open Tab |
February 6, 2008 |
Provides Information |
| Oracle names 11g Database price
|
| Oracle has finally unveiled pricing for its long-awaited next database running on Linux, and it's mixed news for users.
|
| Open |
Open Tab |
August 14, 2007 |
Provides Information |
| Oracle Patches 45 Security Holes in Database, App Server and More
|
| The Oracle Patch Update includes 45 security fixes, including 11 for the Oracle Database. Also included are nine security fixes for Oracle Application Server, seven for Oracle WebLogic Server, two for Oracle Enterprise Manager, six for Oracle E-Business Suite and Applications, and seven for Oracle PeopleSoft Enterprise products.
|
| Open |
Open Tab |
July 15, 2008 |
Provides Information |
| Oracle Readies Next Step in AIA Strategy
|
| The rollout in February of Oracle's Foundation Pack could blur the line between Fusion Middleware and the new application integration platform.
|
| Open |
Open Tab |
February 5, 2008 |
Provides Information |
| Oracle reveals BEA roadmap
|
| Oracle presented on Tuesday a comprehensive roadmap for its recently acquired BEA Systems middleware technologies, making BEA's application server Oracle's strategic Java container and pledging continued support for BEA customers.
|
| Open |
Open Tab |
July 1, 2008 |
Provides Information |
| Oracle Security Update to Plug 51 Holes
|
| Twenty-seven of the fixes address issues in Oracle's database products.
|
| Open |
Open Tab |
October 11, 2007 |
Provides Information |
| Oracle Sees 65 Percent Growth in App Licenses
|
| Oracle's 11g database helps fuel a 23 percent jump in license revenues for database and middleware products.
|
| Open |
Open Tab |
September 21, 2007 |
Provides Information |
| Oracle Ships 11g Database for Windows
|
| Along with assorted performance improvements, the Windows release features beefed-up integration with Microsoft's platform on both the administrative and developer levels.
|
| Open |
Open Tab |
October 24, 2007 |
Provides Information |
| Oracle Ships Critical Update
|
| Oracle Corp. released its latest critical patch update on Wednesday, fixing 51 vulnerabilities in a range of products, including its flagship database line.
|
| Open |
Open Tab |
October 17, 2007 |
Provides Information |
| Oracle Still Top Dog in Tough Database Market
|
| The field of commercial relational database vendors is a lot less crowded than it used to be, and it's no surprise, considering the players have to contend with a massive software juggernaut like Oracle. According to the latest numbers from research firm IDC, Oracle still ruled the roost in databases in 2007, capturing in excess of 44 percent of the overall market.
|
| Open |
Open Tab |
June 29, 2008 |
Provides Information |
| Oracle to Buy Interlace Systems
|
| The acquisition, Oracle's 10th this year, will add to its enterprise performance management suite.
|
| Open |
Open Tab |
October 24, 2007 |
Provides Information |
| Oracle to Charge for Database Add-Ons
|
| A month after launching its 11g enterprise database, Oracle has announced mix-and-match pricing.
|
| Open |
Open Tab |
August 15, 2007 |
Provides Information |
| Oracle to Release 45 Security Fixes
|
| A total of 11 security fixes in the company's upcoming Critical Patch Update address issues in Oracle database products.
|
| Open |
Open Tab |
July 11, 2008 |
Provides Information |
| Oracle users fear forced migration from acquired products
|
| User group survey finds just over half plan to install Fusion within two years.
|
| Open |
Open Tab |
January 29, 2008 |
Provides Information |
| Oracle`s Second Attempt to Acquire BEA Succeeds for $8.5B
|
| As it turns out Oracle is in fact the best buyer for BEA. After Oracle's first overtures for BEA in October 2007 -- followed by a heated battle between Oracle, BEA and its biggest shareholder Carl Icahn -- both companies announced Jan. 16 that they have agreed to merge.
|
| Open |
Open Tab |
January 16, 2008 |
Provides Information |
| P |
| Preserve log table entries using autonomous transactions in Oracle
|
| Developers can use autonomous transactions in Oracle to "step outside" the main transaction and do work that commits independently.
|
| Open |
Open Tab |
|
Provides Information |
| Primary Databases Getting Bloated, Analysts Say
|
| A recent study by Enterprise Strategy Group found that databases used for daily processing tasks are ballooning at a double-digit rate each year, and may contain piles of inactive data to boot.
|
| Open |
Open Tab |
March 18, 2008 |
Provides Information |
| Process non-consecutive array items in FORALL
|
| Prior to Oracle 10g, the FORALL statement only accepted a consecutive range of index values for processing. Starting with Oracle 10g, the INDICES OF and VALUES OF clauses can be added to support non-consecutive processing of elements in a collection.
|
| Open |
Open Tab |
|
Provides Information |
| Q |
| Questions to ask a SQL Server database developer applicant
|
| Tim Chapman presents his standard set of baseline technical questions he asks SQL Server database developers during an interview. These questions will help you weed out less-qualified candidates.
|
| Open |
Open Tab |
|
Provides Information |
| R |
| Resize BIGFILE tablespaces directly using ALTER TABLESPACE
|
| Database administrators can now resize Oracle datafiles at the tablespace level using the BIGFILE tablespace feature in 10g. Bob Watkins explains how in this Oracle tip.
|
| Open |
Open Tab |
|
Provides Information |
| Resolving SQL Server data in different databases
|
| One all-too-common problem that data modelers and DBAs face is how to resolve SQL data in different databases.
|
| Open |
Open Tab |
|
Provides Information |
| Running totals in SQL Server queries
|
| Arthur Fuller demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements.
|
| Open |
Open Tab |
|
Provides Information |
| Running totals in SQL Server queries
|
| Two advantages to such a query include: You don't have to store the results, and you end up with a transaction log that can be inspected row by row.
|
| Open |
Open Tab |
|
Provides Information |
| S |
| SAP Buys Business Objects for $6.78 Billion
|
| The merged product offerings challenges Oracle, but is a switch from SAP's aversion to acquisitions.
|
| Open |
Open Tab |
October 8, 2007 |
Provides Information |
| SAP to shut down TomorrowNow; Oracle gets its sacrifice
|
| SAP's purchase of TomorrowNow in 2005 sounded like a great idea: Undercut Oracle on support and squeeze your biggest rival. And then came Oracle's lawsuit.
|
| Open |
Open Tab |
July 21, 2008 |
Provides Information |
| Scaling out with distributed partitioned views in SQL Server 2005
|
| A distributed partitioned view joins data from one or more SQL Server databases. You can design these views in such a way that the query optimizer will know which table to pull data from in your query.
|
| Open |
Open Tab |
|
Provides Information |
| Scaling your SQL Server system
|
| When your database servers become busy and performance deteriorates, the fix may be as straightforward as taking another look at your current application and query designs. Here's a comparison of scaling up vs. scaling out your SQL Server systems.
|
| Open |
Open Tab |
|
Provides Information |
| See performance gains by using indexed views in SQL Server
|
| 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.
|
| Open |
Open Tab |
|
Provides Information |
| Sending E-mail with Database Mail in SQL Server 2005
|
| In part one of his series, Tim Chapman described how to set up Database Mail in SQL Server 2005. Now he explores some of the more advanced functionality of sending Database Mail e-mails, such as formatting your message body as HTML.
|
| Open |
Open Tab |
|
Provides Information |
| Setting up Database Mail in SQL Server 2005
|
| SQL Server 2005's Database Mail is completely SMTP based, allowing you to send e-mails with attachments, format HTML e-mails, and more. Tim Chapman fills you in on the advantages of Database Mail and explains how to set it up in your environment.
|
| Open |
Open Tab |
|
Provides Information |
| Shred XML data with XQuery in SQL Server 2005
|
| Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains.
|
| Open |
Open Tab |
|
Provides Information |
| Simplify your code with MySQL transactions and prepared queries, and the Perl DBI
|
| Most database systems (including MySQL) support prepared queries and transactions, and most scripting languages (like PHP and Perl) come with built-in functions to access these database features. The Perl DBI functions supporting transactions and prepared queries in MySQL are explored with a view to explaining how they work and how you can use them in your own applications.
|
| Open |
Open Tab |
|
Provides Information |
| Size matters: Yahoo claims 2-petabyte database is world's biggest, busiest
|
| Year-old database processes 24 billion events a day.
|
| Open |
Open Tab |
May 22, 2008 |
Provides Information |
| SQL Server 2008 to be delayed anyway despite February launch
|
| In a bizarre and embarrassing development at the same time, Microsoft's server and tools division found itself announcing a delay for the RTM of SQL Server 2008 of up to six months. Despite that, its launch party will go on.
|
| Open |
Open Tab |
January 25, 2008 |
Provides Information |
| SQL Server 2008, at last, attains Release Candidate status
|
| Although there have already been public betas of Microsoft's new relational database, most notably one launched last February, the latest release candidate lets you reliably test the development environment's most critical new feature.
|
| Open |
Open Tab |
June 10, 2008 |
Provides Information |
| Startup launches 'Internet-scale' database
|
| Aster Data Systems' nCluster breaks up the various components of a data-analysis workload into multiple tiers, providing greater efficiency.
|
| Open |
Open Tab |
May 20, 2008 |
Provides Information |
| Stupid Holes Reported in Oracle 11g
|
| A security expert has found programming errors in Oracle 11g that left security vulnerabilities.
|
| Open |
Open Tab |
September 3, 2007 |
Provides Information |
| Sun completes purchase MySQL, sets sights on Microsoft and Oracle
|
| Sun Microsystems today confirmed it has completed its acquisition of MySQL, and announced all MySQL products are now part of the Sun worldwide sales and support network.
|
| Open |
Open Tab |
February 26, 2008 |
Provides Information |
| Sun does Google's dirty work on MySQL
|
| Sun Microsystems will fine tune MySQL for some big-name customers unwilling to get their hands dirty supporting the open source database themselves.
|
| Open |
Open Tab |
February 29, 2008 |
Provides Information |
| Sun may shut off high-end MySQL features
|
| Pay-to-play fires up grassroots hoots.
|
| Open |
Open Tab |
April 17, 2008 |
Provides Information |
| Sun Microsystems Announces Agreement to Acquire MySQL, Developer of the World's Most Popular Open Source Database
|
| Sun Growth Strategy Accelerates With New Position in $15 Billion Database Market.
|
| Open |
Open Tab |
January 16, 2008 |
Provides Information |
| Sybase Ready to Take On Oracle in Databases
|
| Sybase CEO John Chen says the company will focus on technology to differentiate itself in the database market.
|
| Open |
Open Tab |
August 9, 2007 |
Provides Information |
| Symantec Builds Out DLP Technology to Aid Data Discovery
|
| Symantec has added native support for SQL databases in a push for Storage DLP.
|
| Open |
Open Tab |
June 25, 2008 |
Provides Information |
| T |
| Take advantage of replication options in SQL Server 2000
|
| Copying data from your production databases to other database servers in the enterprise can be advantageous for a variety of reasons.
|
| Open |
Open Tab |
|
Provides Information |
| Temporal Database Concepts
|
| Defines a wide range of terms and concepts specific to the temporal database research community.
|
| Open |
Open Tab |
|
Provides Information |
| Ten thousand servers hit in SQL injection hack
|
| A brute force SQL injection onslaught that began on May 13 has infected a reported 10,000 servers, infecting thousands of Chinese and Taiwanese sites with malware.
|
| Open |
Open Tab |
May 19, 2008 |
Provides Information |
| Test the SQL Server business rule chaining method
|
| Chaining database stored procedures is an interesting and effective way to execute business logic in your database.
|
| Open |
Open Tab |
|
Provides Information |
| Test XML queries interactively in Oracle 10gR2 SQL*Plus
|
| The SQL*Plus program can now process XML (and SQL) queries using the XQUERY command added in Oracle 10gR2. This tip shows you some of the possibilities.
|
| Open |
Open Tab |
|
Provides Information |
| Three easy ways to optimize your MySQL queries
|
| Database applications likes MySQL come with tools to aid in the optimization of queries. Three of the more common tools include using indexes, analyzing queries with EXPLAIN, and adjusting MySQL's internal configuration.
|
| Open |
Open Tab |
|
Provides Information |
| Three ways to avoid Case Not Found errors in PL/SQL
|
| Unlike some languages, PL/SQL's CASE statement generates an error if none of the cases are matched. Bob Watkins presents three ways to code around this error.
|
| Open |
Open Tab |
|
Provides Information |
| Trade risk for speed with Oracle 10g's asynchronous COMMIT
|
| A new option to the COMMIT statement in Oracle 10g can defer the writing of committed data to the online redo log files. This involves a risk of data loss, but it speeds up the transaction response time. Find out more details in this tip.
|
| Open |
Open Tab |
|
Provides Information |
| Tune your service oriented applications with SQL
|
| Performance is one of the more insidious problems that a developer can face. We don't seem to have time for it with all work just getting an application's functionally correct.
|
| Open |
Open Tab |
November 19, 2007 |
Provides Information |
| Two tips to make your forms run faster in Access
|
| Make your Access forms leaner and meaner—and faster. By giving your form less data to digest, you can make it run faster and more efficiently.
|
| Open |
Open Tab |
|
Provides Information |
| U |
| Unsure what properties your fields should have? Let Access 2007's field list set them for you
|
| With a variety of built-in fields, Access 2007 makes it easy for you to design a table for your database. Here's how to use the intuitive features of the latest version of Access to make your job easier.
|
| Open |
Open Tab |
|
Provides Information |
| Update to the support policy for SQL Server 7.0
|
| Effective December 31, 2005, support for all versions of Microsoft SQL Server 7.0 will transition from Mainstream Support to Extended Support.
|
| Open |
Open Tab |
|
Provides Information |
| Use a sample record to create an online form in Access 2007
|
| No need to have your users fill out multiple sheets of paper -- build an online form in Access 2007 and have your employees enter the data for you.
|
| Open |
Open Tab |
|
Provides Information |
| Use Excel's MS Query Wizard to query Access databases
|
| Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard.
|
| Open |
Open Tab |
|
Provides Information |
| Use logon triggers to initialize user sessions in Oracle
|
| Application contexts enable you to store data in memory for applications to use. The After Logon database trigger is a convenient way to initialize a user session by setting application context values for it.
|
| Open |
Open Tab |
|
Provides Information |
| Use multiple dump files for large Oracle exports
|
| Even as far back as Oracle 8i, the Export utility could handle large exports by splitting them into multiple output files. Bob Watkins reviews how this is done prior to Oracle 10g and what changes are necessary for 10g and later.
|
| Open |
Open Tab |
|
Provides Information |
| Use MySQL GUI tools remotely and securely
|
| Vincent Danen looks at MySQL GUI tools for database-driven Web applications. Here are his tips for getting the most of the GUI tools, even while connecting remotely, without compromising security.
|
| Open |
Open Tab |
|
Provides Information |
| Use Oracle 10g's DBMS_SCHEDULER to control batch job resources
|
| Unlike the older DBMS_JOB package, DBMS_SCHEDULER in Oracle 10g is integrated with Resource Manager to give you precise control over the resources consumed by batch jobs.
|
| Open |
Open Tab |
|
Provides Information |
| Using common table expressions in SQL Server 2005 queries
|
| Common table expressions (CTEs), a powerful and slick new feature in SQL Server 2005, make your SQL more readable and easier to maintain.
|
| Open |
Open Tab |
|
Provides Information |
| Using Oracle's COALESCE function as a quick CASE statement
|
| In this Oracle tip, Bob Watkins explains how you can use the COALESCE function in lieu of the more wordy CASE statement when testing for null results in multiple expressions.
|
| Open |
Open Tab |
|
Provides Information |
| Using SQL Server JOINs for easy range lookups
|
| Arthur Fuller goes beyond the traditional use of JOINs to link two tables on equal values. In this tip, he illustrates how to perform a range lookup using a JOIN.
|
| Open |
Open Tab |
|
Provides Information |
| W |
| Welcome to the Exchange 2007 Availability Service
|
| One of Outlook's most useful features is the capability of providing you with free/busy information for everyone in your organization. It appears to the user to be something that "just works." But it's more complicated than that.
|
| Open |
Open Tab |
|
Provides Information |
| Will Other Major Database Vendors Follow Microsoft into the Cloud?
|
| Microsoft's SQL Server Data Services takes data storage and query processing to the Web, but it's uncertain whether IBM and Oracle will follow suit.
|
| Open |
Open Tab |
March 7, 2008 |
Provides Information |
| With Drizzle, Sun's MySQL gets skinnier, forgoing features for speed
|
| "Drizzle," a recently announced offshoot of MySQL, is taking the open source database in a wholly different direction than the bigger, feature-full database widely foreseen since Sun's MySQL buyout.
|
| Open |
Open Tab |
July 22, 2008 |
Provides Information |
| Write less code with PIVOT queries in SQL Server 2005
|
| SQL Server 2005's PIVOT operator allows you to rotate row level data into tabular data without the use of the CASE statement.
|
| Open |
Open Tab |
|
Provides Information |
| Working with nested subqueries in SQL Server
|
| Arthur Fuller provides an example that demonstrates the power of nested subqueries. He notes that nested subqueries can help you find the answers you need when the pieces are scattered across a number of tables.
|
| Open |
Open Tab |
|
Provides Information |