TechRepublic : A ZDNet Tech Community

16 Resources for

benefit and database

  • Subscribe to this listing via:
  • RSS
  • Email
Related Tags: benefit (644 results), employee benefit (2 results), health benefit (2 results), benefit plan (1 results)

TechRepublic Resources

Make data entry in Access easier by changing text boxes to combo boxes
Lookup WizardAlthough the solution presented is serviceable, it would force you to do those same steps on each foreign key you place on each form you build.A more elegant solution would be to open the table in Design View, and use the Lookup Wizard on each foreign key field (RepID...
Tags: combo box, Lookup Wizard, Microsoft Access, ttrollen@..., data entry, RepID, foreign key, software, database, msaccess
Discussion threads 2007-03-07
Capture the reporting benefits of database snapshots in SQL Server 2005
Snapshot vs replicationI can see the advantages of this for reporting purposes. Can a snapshot be located on a mapped remote drive and if so how does the snapshot mechanism compare to replication for creating a remote copy of a database for reporting? I'm thinking mainly of overhead and response...
Tags: benefit, database, iansavell@..., Microsoft SQL Server, Microsoft SQL Server 2005, software
Discussion threads 2007-01-09
Capture the reporting benefits of database snapshots in SQL Server 2005
Database snapshots allow you to create read-only databases for reporting and can also be useful in your data recovery efforts in the event of a disaster. Tim Chapman explores how database snapshots work and provides an example of a snapshot. Database snapshots are yet another great new feature in...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Storage, Databases, benefit, database, database snapshot, data file, source database, SQL Server Newsletter, Data, Snapshot, Size, Hardware, Enterprise Software, Software, Data Management
Technical articles 2007-01-08
Filemaker Pro 8.5 or Alpha Five V7?
I need a powerful yet easy to use database for some projects I'm working on. I worked on Alpha Five several years ago and was happy with the software, but a lot has changed since then. Has anyone worked with both programs, I would like to know which
Tags: Alpha, Alpha 5, byte2hard@..., database, Filemaker Inc., FileMaker Pro, FMP 8.5, programming, software, sql, windows
Discussion threads 2006-11-08
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. Tim Chapman explains the concept of business rule chaining, and provides a very useful example for the implementation. There is an age-old debate about where to store application business logic: the...
Tags: Microsoft SQL Server, Tim Chapman, Storage, Databases, server, business rule, database, SQL Server Newsletter, Solution, Procedure, Idea, Business Logic, Benefit, Business Procedure, RunSequence, Hardware, Enterprise Software, Software, Data Management
Technical articles 2006-10-11
Benefit from SQL Server 2005's new schema convention
Arthur Fuller highlights the benefits of one of his favorite new features in SQL Server 2005: adding the notion of schemas to object names. He notes that you'll really appreciate schemas if you're working with more than 20 tables. One of the coolest features of SQL Server 2005 is...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Arthur Fuller, Figure C, Databases, Storage, benefit, schema, database, SQL Server Newsletter, TechRepublic Inc., Figure B, Enterprise Software, Software, Data Management, Hardware
Technical articles 2006-08-14
Access your MySQL database for maintenance without a password
Vincent Danen tells you how to write a configuration file for a user to perform MySQL database maintenance without a password. MySQL is perhaps one of the most popular database systems currently available. It has a lot of great features, it's open source, and a lot of...
Tags: Microsoft Access, MySQL, Vincent Danen, Storage, Databases, OPEN SOURCE, database, password, Linux Tips Newsletter, Benefit, Hardware, Enterprise Software, Software, Data Management
Technical articles 2006-03-20
Is LINQ the future of database development?
The LINQ (.NET Language Integrated Query) Project is an initiative to standardize data access across data sources and development. Arthur Fuller discusses LINQ and its benefits, and explains why he's not convinced that LINQ will revolutionize database application development. The LINQ (.NET Language Integrated Query) Project is a...
Tags: Arthur Fuller, LINQ, Databases, C#, .NET, Programming languages, Benefits, database, See LINQ, SQL Server Newsletter, Back-end, Development, Benefit, Jury, Storage, Hardware, Enterprise Software, Software, Data Management
Technical articles 2005-10-17
Discover the benefits of using MSDE with SQL
You're mis-informed about the Jet database engine.> Given a query that pulls 100 rows from a table, >Access sends the entire table (or tables where >joins are involved)This is not always true. If the database is properly designed with appropriate indexes on primary and foreign key fields Access sends only...
Tags: access, benefit, database, Jet Database Engine, jet engine, Microsoft Data Engine, Microsoft SQL Server, rkc, software, SQL, SQL Express
Discussion threads 2005-08-20
Discover the benefits of using MSDE with SQL
Microsoft-centric developers now have three database choices: Access, SQL Server, and MSDE. Arthur Fuller examines the performance differences between these databases and discusses when MSDE might be the best choice for your enterprise. Even if you've checked out Microsoft Data Engine's specifications, you might conclude that it's...
Tags: Microsoft SQL Server, SQL, Microsoft Data Engine, Arthur Fuller, Databases, Storage, benefit, database, server, SQL Server Newsletter, TechRepublic Inc., Client, Microsoft Corp., Enterprise Software, Software, Data Management, Hardware
Technical articles 2005-07-25
Master file system security in Windows
In the opening of Chapter 4 of Securing Windows Server 2003, author Mike Danseglio explains, "The use of long-term computer data storage, whose benefits are numerous, raises special security consideration for the system administrator: how do you protect data so that only the intended user has access while ensuring some...
Tags: Microsoft Windows, Microsoft Windows Server, Microsoft Windows Server 2003, permission, security, user access, computer, data storage, database, file system, portable computer, storage, system administrator, Chapter 4, Mike Danseglio, Securing Windows Server 2003, tool, benefit
Download resources 2005-07-13
Achieve the benefits of normalized data even in a small Microsoft Access database
Grow your Microsoft Access skills with TechRepublic's Fast Track: Microsoft Access CD-ROM. Learn to use and maximize all that Microsoft Access has to offer with 75 complete lessons covering Access 97, 2000, and 2002 XP.TechRepublicmember Navjun recently asked the following question in the TechRepublic TechnicalQ&A forum:"I'm making a guest list...
Tags: Text, Ramon Padilla Jr., Microsoft Corp., Microsoft Access, database, benefit, Navjun
Technical articles 2004-08-06
Explore the differences between ISAM and relational databases
File-based databases have been around since the dawn of computing. We've always needed to have a way of storing records of the same kind of information. In the PC world, we ended up with very popular file-based databases. For instance, we've probably all heard of the DBase file format. That...
Tags: database, Indexed Sequential Access Method, Robert L. Bogue, ISAM, RDBMS
Technical articles 2004-02-13
The benefits from using wireless in database administration
It's 2:30 P.M. and you're working on-site for one of your customers. Your pager bleats out an urgent call from a second client across town whose server is down. You can try to help the second client on the phone—a slow, tedious process that may create political issues with the...
Tags: benefit, Bob Watkins, database, server, wireless
Technical articles 2003-01-28
JumpBox for Ruby on Rails Deployment 1.1.4 (Mac)
Ruby on Rails is a framework that allows a web developer to rapidly design web applications which are capable of leveraging database back-ends with minimal effort. Written in Ruby, Rails prefers convention and simple patterns to facilitate rapid development rather than relying on a myriad of complex and intermingling configurations...
Tags: Software, Web, Database, Apple Macintosh, Benefit, Server, Ruby, JumpBox, Ruby On Rails, Channel Management, Scripting Languages, Software/Web Development, Web Development, Marketing
Software downloads 2009-09-14
The Business Value of Microsoft Office Professional 2007: Top 10 Benefits
Office Professional 2007 provides the users with a complete set of productivity and information management tools to accomplish routine tasks quickly, effectively manage customer and contact information in one place, produce professional-quality marketing communications and campaigns in-house, and simplify database creation and reporting. This webcast will review the top ten...
Tags: Information Management, Database, Microsoft Office, Benefit, Microsoft Corp., Office Professional 2007, Strategy, Management
Webcasts 2008-04-09

Additional Resources

Optimize database code to boost performance
Select COUNT(*) - secretSelect COUNT(*) DOES NOT do full table scan if table has a primary key. It counts the Index. Sometimes indexes may be 50MB for a 500MB table and Select COUNT(*) can be very fast! DB optimizition needs knowledge of programmer to get best out of the CBO...
Tags: cursor, database, dept, performance, programming, SELECT, SELECT COUNT, sql erformance, sss@...
Discussion threads 2006-09-27
Combining XML and databases
XML is the new data standard, but relational databases won't be disappearing. See how XML can peacefully coexist with a relational database, and learn when XML databases are appropriate to use.XML has evolved into a viable alternative for representing data. As more applications use XML, the big question becomes how...
Tags: Roy C. Hoobler, XML, XPath, XML Database, database
Technical articles 2002-08-29
Building a reuse environment: Recognize the benefits and overcome the barriers
To build a reuse environment, you need a realistic view of the obstacles you'll encounter--and the tenacity and executive sponsorship to overcome them. See why the challenge is worth undertaking and learn some strategies for avoiding pitfalls.In previous columns, we've discussed the hard work associated with establishing a reuse environment...
Tags: Benefits, Tom Mochal, reuse environment, benefit, barrier
Technical articles 2002-02-04
Speed Oracle database queries with parallel features
How would you like to accelerate your Oracle database queries? Donald Burleson says you can, if you take advantage of parallel features.One of the most exciting, yet most overlooked, features of Oracle databases is the ability to dedicate multiple processors to service an Oracle query. The Oracle database has implemented...
Tags: Processors, Databases, Storage, Donald Burleson, Oracle Corp., processor, database, massively parallel processor, Oracle Database
Technical articles 2000-01-24
  • << Previous
  • page 1 of 1
  • Next >>


IT Help Desk Survival Guide, Third Edition
TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.
Buy Now
Quick Reference: Linux Commands
Reduce stress and speed up resolutions with the easiest command references right at your fingertips. You'll receive a PDF file covering Linux, packed with the most common commands you'll need and use daily.
Buy Now

Popular Sanity Saver Videos