- Subscribe to this page:
- RSS
- Email Alert
database management
(139 results)-
Downloads
10 ways to prevent Access database corruption
Apr 2008
Nothing frustrates Access users like a corrupted database. With a little know-how, you might get lucky enough to repair the database or at least recover the data. Sometimes, a third-party product...
Provided by Susan Harkins
-
Downloads
Microsoft Express
Oct 2010
A free and feature-rich database for developing and deploying desktop, web, and small server applications.
Provided by Microsoft
-
Book chapters
Learn basic SQL commands
Dec 2005
This sample chapter, taken from Sams Teach Yourself PHP, MySQL and Apache All in One, 2nd Edition, teaches you the basics of SQL, from table creation to manipulating records. Learn the core SQL...
Provided by Sams Publishing
-
Downloads
Microsoft Access Help Desk Database
Jul 2004
Use this sample Microsoft Access Help Desk database as a simple substitute for commercial help desk software. It provides pertinent customer information with tabs to track call details as well as...
Provided by TechRepublic
-
Downloads
Smart Tools to Keep Your Data Clean
May 2012
This toolkit of programming APIs for .NET will verify addresses, phone numbers and email addresses at point of entry or in batch so you have clean contact data to power your applications, reduce...
Provided by Melissa Data Corp
-
Downloads
Preparing for Exchange Server 2010
Dec 2009
This table is a companion piece to Scott Lowe's column, "Preparing for Exchange Server 2010's hardware and software requirements." The table provides you with a starting point in your Exchange RAM...
Provided by Scott Lowe
-
Downloads
10 common SQL Server problems and solutions
Dec 2005
This list outlines 10 common SQL Server problems and solutions. This handy two-page list outlines 10 familiar SQL Server problems and an assortment of solutions. From "Out of Space" errors to a...
Provided by TechRepublic
-
Downloads
10 things you should know about NoSQL databases
Aug 2010
The relational database model has prevailed for decades, but a new type of database -- known as NoSQL -- is gaining attention in the enterprise. Here's an overview of its pros and cons.This...
Provided by Guy Harrison
-
Downloads
Lunch and Learn: Microsoft Access 2007 Intermediate Skills
Sep 2007
This Microsoft Access 2007 Intermediate Skills presentation provides a preformatted presentation for helping staff better leverage the database application's capabilities. It covers such things as...
Provided by TechRepublic Pro
-
Downloads
Simply a better NAS - Virtual Cloud File Server
Oct 2010
Nasuni's elegant cloud file server turns cloud storage from providers like Amazon, AT&T, Iron Mountain, Rackspace, Nirvanix or Windows Azure into an advanced NAS. The Nasuni Filer is the easiest,...
Provided by Nasuni
-
Downloads
Achieve better database design by understanding MySQL data types
Dec 2005
This document outlines the most important data types supported by MySQL and describes when and how each should be used. All data is not the same—especially when it comes to storing it in a...
Provided by TechRepublic
-
Book chapters
Plan and create a custom database with Microsoft Access 2007
Oct 2007
Learn how to create a custom database from scratch while taking full advantage of the tools that Access provides in this chapter download from Microsoft Office Access 2007 on Demand. Mastering...
Provided by Que Publishing
-
Downloads
Lunch and Learn: Microsoft Access 2007 Basics
Sep 2007
The Microsoft Access 2007 Basics presentation is a prepackaged solution designed to help familiarize attendees with the database program's basic functions. The presentation contains everything you...
Provided by TechRepublic Pro
-
Book chapters
Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills
Apr 2006
This sample chapter, taken from Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills, explains the basics of Microsoft Access' pivot tables and pivot charts. Pivot tables...
Provided by Addison Wesley Professional
-
Downloads
10+ tips for designing flexible and efficient Access tables
Mar 2007
The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access...
Provided by Susan Harkins
-
Downloads
A simple solution for tracking changes to Access data
Mar 2007
When you have a lot of users changing data, it's easy for things to go wrong. But if you keep an audit trail of data input changes, you'll be able to determine which operators are consistently...
Provided by Susan Harkins
-
Book chapters
Create and manipulate Microsoft Access forms with VBA
Nov 2005
This sample chapter, taken from Automating Microsoft Access with VBA, discusses how manipulate Microsoft Access forms with VBA. Learn how to use VBA to work with forms in Microsoft Access.This...
Provided by Que Publishing
-
Downloads
Task sheet: Create calculated fields for Access queries
Mar 2005
Depending on the situation, you may benefit from using calculated fields in a database instead of consuming disk space with stored values. Here's a simple technique for creating your own...
Provided by TechRepublic
-
Downloads
Managing MySQL with MySQL Workbench
May 2010
Vincent Danen gives an overview of a graphical tool for working with MySQL databases, available for Linux, Mac, and Windows.
Provided by Vincent Danen
-
Downloads
70+ Keyboard shortcuts to move faster in Microsoft Access
Jul 2005
This handy, two-page table lists more than 70 keyboard shortcuts and their corresponding functions for Microsoft Access. Download and print this time-saving document and post it near your keyboard...
Provided by TechRepublic
-
Downloads
10 tips for securing a Microsoft Access database
Feb 2009
A few best practices can go a long way toward protecting your Access data from careless or overly curious users. Here are some simple ways to add a few layers of security to a database.This...
Provided by Susan Harkins
-
Downloads
Electronic Data Retention Policy
Feb 2012
TechRepublic's Electronic Data Retention Policy will help you define requirements and implement practices for ensuring electronic data is properly safeguarded in compliance with federal, state,...
Provided by TechRepublic Pro
-
Downloads
100 things you should know about handling net admin tasks more effectively
Nov 2005
This comprehensive collection of tactical information and best practices encompasses IT tasks ranging from working with routers to managing projects to configuring a secure WLAN. It may seem like...
Provided by TechRepublic
-
Downloads
How do I... Configure transactional replication between two SQL Server 2005 systems?
Aug 2007
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, redundancy, and other typical...
Provided by Josh Hoskins
-
Downloads
10 tricks for handling null values in Microsoft Access
Oct 2006
Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you...
Provided by Susan Harkins
-
Downloads
SharePoint 2007 Reference Guide
Dec 2009
Any enterprise platform needs to be able to adjust, grow, and scale out to fit the needs of a changing organization. SharePoint is no exception to this rule. This reference guide is a collection...
Provided by TechRepublic Pro
-
Downloads
How do I... Set up replication between Microsoft SQL Server 2000 and MySQL
Aug 2007
While data replication between Microsoft SQL Server 2000 and MySQL databases is not technically supported by either application, it is possible if you follow the correct steps. This TechRepublic...
Provided by Josh Hoskins
-
Downloads
Control Excel data entry with these five powerful tips
Nov 2005
This download provides five powerful tips to help you control Excel data entry and improve accuracy. Using Microsoft Excel, you can store and analyze financial information, statistical data,...
Provided by TechRepublic
-
Downloads
Designing database applications for optimal performance
Jun 2009
In his book review of Prentice Hall's The Data Access Handbook, TechRepublic blogger Justin James notes that chapter two provided him with more information about database connectivity than he...
Provided by Prentice Hall PTR
-
Downloads
10 ways to begin a data warehouse project
Oct 2006
IT departments typically launch data warehouse projects without input from business partners, explaining DW concepts to the uninitiated and building the business case themselves. But what steps...
Provided by Jeff Relkin
-
Downloads
How do I... Display summary values in Microsoft Access using UNION?
Aug 2006
SQL's UNION operator lets you combine data from two or more tables or queries--but that's not all it can do. Database expert Susan Harkins demonstrates several techniques for using UNION to...
Provided by Susan Harkins
-
Downloads
How do I... Query foreign data using SQL Server's linked servers?
Jul 2007
Sometimes, the data you need is in a non-database format or resides on a different server. Fortunately, SQL Server is flexible enough to offer a number of ways to get it. One of the easiest...
Provided by Susan Harkins
-
Downloads
Sample Active Directory User Database
Nov 2003
You can use this sample database to maintain user information in Access. Then you can import and export that information into Active Directory.
Provided by TechRepublic
-
Book chapters
Integrate Microsoft Excel and Access with VBA to create sophisticated applications
Feb 2006
There are numerous situations when VBA is not only the preferred way to obtain data, but the only way. This chapter excerpt from Integrating Excel and Access explains when VBA is required and how...
Provided by O'Reilly Media
-
Book chapters
Learn to use MySQL column types
Oct 2005
This sample chapter, taken from Sams' MySQL Language Reference, offers an overview of column types in MySQL. Learn about the different column types in MySQL, including numeric types, date and...
Provided by Sams Publishing
-
Downloads
Monitoring MySQL with mytop
Jun 2010
Vincent Danen tells you how to use mytop to monitor MySQL threads and database performance. Here are a few pointers about configuration and getting started.
Provided by Vincent Danen
-
Downloads
Database design: Development and implementation of a master data management system
Feb 2005
The key facet of the master data management system (MDMS) is to have a single system as a point of reference for all commonly used items of data within a company. Each consumer system could then...
Provided by TechRepublic
-
Downloads
How do I... Install, configure, and use LiteSpeed for database backups?
Nov 2007
LiteSpeed by Quest software is an enterprise level backup solution for MS SQL Server. This solution includes several powerful features that increase the ease and efficiency of database archiving...
Provided by Josh Hoskins
-
Book chapters
Achieve Microsoft SQL Server High Availability with data replication
Nov 2005
This sample chapter, taken from Sams' Microsoft SQL Server High Availability, discusses how you can use data replication as a high availability solution. Data replication is a powerful feature of...
Provided by Sams Publishing
-
Downloads
Better database design with foreign keys and referential integrity in MySQL
Feb 2006
Recent versions of MySQL have implemented support for foreign keys through the new InnoDB table engine. This document explains how it works. Referential integrity refers to a state when all the...
Provided by TechRepublic
-
Downloads
Smart Tools to Keep Your Data Clean
May 2012
This toolkit of programming APIs for .NET will verify addresses, phone numbers and email addresses at point of entry or in batch so you have clean contact data to power your applications, reduce...
Provided by Melissa Data Corp
-
Downloads
Electronic Data Retention Policy
Feb 2012
TechRepublic's Electronic Data Retention Policy will help you define requirements and implement practices for ensuring electronic data is properly safeguarded in compliance with federal, state,...
Provided by TechRepublic Pro
-
Downloads
Microsoft Express
Oct 2010
A free and feature-rich database for developing and deploying desktop, web, and small server applications.
Provided by Microsoft
-
Downloads
Simply a better NAS - Virtual Cloud File Server
Oct 2010
Nasuni's elegant cloud file server turns cloud storage from providers like Amazon, AT&T, Iron Mountain, Rackspace, Nirvanix or Windows Azure into an advanced NAS. The Nasuni Filer is the easiest,...
Provided by Nasuni
-
Downloads
10 things you should know about NoSQL databases
Aug 2010
The relational database model has prevailed for decades, but a new type of database -- known as NoSQL -- is gaining attention in the enterprise. Here's an overview of its pros and cons.This...
Provided by Guy Harrison
-
Downloads
Monitoring MySQL with mytop
Jun 2010
Vincent Danen tells you how to use mytop to monitor MySQL threads and database performance. Here are a few pointers about configuration and getting started.
Provided by Vincent Danen
-
Downloads
Managing MySQL with MySQL Workbench
May 2010
Vincent Danen gives an overview of a graphical tool for working with MySQL databases, available for Linux, Mac, and Windows.
Provided by Vincent Danen
-
Downloads
Work on remote Subversion repositories locally with Git
Apr 2010
Vincent Danen explains how you can use Git version control on a converted Subversion repository and push your changes back to Subversion.
Provided by Vincent Danen
-
Downloads
Take a Test Drive Down the Road to Better BI
Feb 2010
Sybase PowerDesigner is the industry's leading data modeling tool. But it can do so much more—improving business and IT alignment to boost productivity, providing customized options to enforce...
Provided by Sybase
-
Downloads
Preparing for Exchange Server 2010
Dec 2009
This table is a companion piece to Scott Lowe's column, "Preparing for Exchange Server 2010's hardware and software requirements." The table provides you with a starting point in your Exchange RAM...
Provided by Scott Lowe
-
Downloads
Sophos Free Encryption - Free Tool
Dec 2009
Sophos Free Encryption is a free tool lets you secure your data easily and quickly without any central infrastructure in place. Individuals and businesses alike can easily protect selected files...
Provided by Sophos
-
Downloads
SharePoint 2007 Reference Guide
Dec 2009
Any enterprise platform needs to be able to adjust, grow, and scale out to fit the needs of a changing organization. SharePoint is no exception to this rule. This reference guide is a collection...
Provided by TechRepublic Pro
-
Downloads
EventSentry Light - Real-Time Event Log, File, System Health & Network Monitoring
Jan 2009
EventSentry is the free edition of EventSentry, an event log and network monitoring suite. EventSentry sends alerts through a variety of notifications, and includes one of the most advanced...
Provided by Netikus.Net
-
Downloads
Designing database applications for optimal performance
Jun 2009
In his book review of Prentice Hall's The Data Access Handbook, TechRepublic blogger Justin James notes that chapter two provided him with more information about database connectivity than he...
Provided by Prentice Hall PTR
-
Downloads
10+ ways to keep your Access database in tiptop shape
Apr 2009
A sluggish database can cost your money and waste users' time. Here are some maintenance tasks and general best practices to ensure your database is healthy and operating at peak efficiency.This...
Provided by Susan Harkins
-
Downloads
How do I... Configure SQL Mail in SQL Server 2000?
Mar 2009
SQL Mail is a component of SQL Server that allows you to send and receive e-mail by working side by side with a mail server. Steven Warren describes the possibilities of SQL Mail and explains how...
Provided by Steven Warren
-
Downloads
10 tips for securing a Microsoft Access database
Feb 2009
A few best practices can go a long way toward protecting your Access data from careless or overly curious users. Here are some simple ways to add a few layers of security to a database.This...
Provided by Susan Harkins
-
Downloads
Improve MySQL performance with MySQLTuner
Oct 2008
Vincent Danen covers the basics of the MySQL Tuner tool, which analyzes your configuration and suggests changes that will boost the performance of your MySQL installation.
Provided by Vincent Danen
-
Downloads
10+ reasons to use Access (and a few reasons not to)
Aug 2008
Microsoft Access may not be the king of databases, but it does offer a number of advantages over solutions like SQL Server and Oracle in certain situations. Access guru Susan Harkins counts the...
Provided by Susan Harkins
-
Downloads
10+ tips for upsizing an Access database to SQL Server
Jul 2008
When the time comes to migrate your Access database to SQL Server, you could be in for a bumpy ride. These suggestions will help you sidestep problems -- or at least wrestle them into...
Provided by Susan Harkins
-
Downloads
How do I... Identify and delete duplicates from SQL Server tables?
Jun 2008
Duplicate records in a database are bad. You can't tolerate them. At the very least, they'll produce misleading analysis. At the worst, they'll totally wreck everything. The good news is that...
Provided by Susan Harkins
-
Downloads
IT Hiring Kit: SQL Server Database Administrator
Apr 2008
New version designed especially for SQL Server DBAs! The IT Hiring Kit for SQL Server Database Administrators will help you interview, evaluate, and select suitable candidates for a DBA...
Provided by TechRepublic Pro
-
Downloads
IT Hiring Kit: Oracle Database Administrator
Apr 2008
New version designed especially for Oracle DBAs! The IT Hiring Kit for Oracle Database Administrators will help you interview, evaluate, and select suitable candidates for a DBA position. This...
Provided by TechRepublic Pro
-
Downloads
10 ways to prevent Access database corruption
Apr 2008
Nothing frustrates Access users like a corrupted database. With a little know-how, you might get lucky enough to repair the database or at least recover the data. Sometimes, a third-party product...
Provided by Susan Harkins
-
Downloads
Lunch And Learn: Get Up To Speed On OpenOffice Base
Mar 2008
This is a prepackaged presentation designed to be given in a classroom or conference room setting to help attendees become familiar with the database component of OpenOffice - Base. Everything is...
Provided by TechRepublic Pro
-
Downloads
How do I... Install and configure Spotlight on SQL Server?
Dec 2007
For database administrators, peak performance of their SQL Servers is always a priority. Spotlight on SQL Server from Quest Software is a tool to help SQL Server DBA's monitor the performance of...
Provided by Josh Hoskins
-
Downloads
How do I... Install, configure, and use LiteSpeed for database backups?
Nov 2007
LiteSpeed by Quest software is an enterprise level backup solution for MS SQL Server. This solution includes several powerful features that increase the ease and efficiency of database archiving...
Provided by Josh Hoskins
-
Downloads
Microsoft Access 2007 Advanced Functionality Lunch And Learn
Jan 2008
This Microsoft Access 2007 - Advanced Functionality presentation is a preformatted solution for training staff to maximize Microsoft Access's more advanced functions. The accompanying reference...
Provided by TechRepublic Pro
-
Book chapters
Plan and create a custom database with Microsoft Access 2007
Oct 2007
Learn how to create a custom database from scratch while taking full advantage of the tools that Access provides in this chapter download from Microsoft Office Access 2007 on Demand. Mastering...
Provided by Que Publishing
-
Downloads
How do I... Transfer logins from one SQL Server 2005 instance to another?
Sep 2007
In a previous download, Steven Warren described how to restore a SQL Server to a new server. That download lead to some questions regarding how to move SQL Server logins from one SQL Server...
Provided by Steven Warren
-
Downloads
How do I... Configure transactional replication between two SQL Server 2005 systems?
Aug 2007
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, redundancy, and other typical...
Provided by Josh Hoskins
-
Downloads
Lunch and Learn: Microsoft Access 2007 Intermediate Skills
Sep 2007
This Microsoft Access 2007 Intermediate Skills presentation provides a preformatted presentation for helping staff better leverage the database application's capabilities. It covers such things as...
Provided by TechRepublic Pro
-
Downloads
Lunch and Learn: Microsoft Access 2007 Basics
Sep 2007
The Microsoft Access 2007 Basics presentation is a prepackaged solution designed to help familiarize attendees with the database program's basic functions. The presentation contains everything you...
Provided by TechRepublic Pro
-
Downloads
How do I... Set up replication between Microsoft SQL Server 2000 and MySQL
Aug 2007
While data replication between Microsoft SQL Server 2000 and MySQL databases is not technically supported by either application, it is possible if you follow the correct steps. This TechRepublic...
Provided by Josh Hoskins
-
Book chapters
Use the QtSql module to build Qt applications that work with various relational database management systems
Jul 2007
Nowadays, it's difficult to imagine many applications being able to function without relational databases to back them up. For this reason, Qt provides a range of classes in the QtSql module that...
Provided by No Starch Press
-
Downloads
TechRepublic's Access 2003 Lunch and Learn collection
Jul 2007
You can use this collection of TechRepublic Lunch and Learns to get users up to speed quickly on Microsoft Access 2003. This download contains the following five Lunch and Learn presentations: ...
Provided by TechRepublic Pro
-
Downloads
How do I... Query foreign data using SQL Server's linked servers?
Jul 2007
Sometimes, the data you need is in a non-database format or resides on a different server. Fortunately, SQL Server is flexible enough to offer a number of ways to get it. One of the easiest...
Provided by Susan Harkins
-
Downloads
A couple of MySQL stored procedures myths get busted
Jun 2007
Two often repeated myths about MySQL stored procedures include (1) MySQL does not support stored procedures and (2) MySQL stored procedures are too difficult to work with under typical...
Provided by Edmond Woychowsky
-
Downloads
How Do I... Restore a SQL Server database to a new server?
Jun 2007
As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out...
Provided by Steven Warren
-
Downloads
Lunch and Learn: Get up to speed on Microsoft Access 2007
Apr 2007
This is a prepackaged presentation designed to be given in a classroom or conference room setting to help attendees become familiar with Access 2007. Everything is ready to be used even if you...
Provided by TechRepublic Pro
-
Downloads
How do I... Install SQL Server 2005 Express Edition and SQL Server Management Studio Express?
Aug 2006
With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own...
Provided by Scott Lowe
-
Book chapters
Use Visual Basic 2005 Express Edition to develop custom applications that link to an SQL Server Express database
Nov 2006
SQL Server Express is an innovative database product that combines power, flexibility, ease of use, and no cost, as well as the ability to develop custom applications using Visual Basic Express....
Provided by Sybex
-
Downloads
EventSentry Light - Real-Time Event Log, File, System Health & Network Monitoring
Jan 2009
EventSentry is the free edition of EventSentry, an event log and network monitoring suite. EventSentry sends alerts through a variety of notifications, and includes one of the most advanced...
Provided by Netikus.Net
-
Downloads
SharePoint 2007 Reference Guide
Dec 2009
Any enterprise platform needs to be able to adjust, grow, and scale out to fit the needs of a changing organization. SharePoint is no exception to this rule. This reference guide is a collection...
Provided by TechRepublic Pro
-
Downloads
Sophos Free Encryption - Free Tool
Dec 2009
Sophos Free Encryption is a free tool lets you secure your data easily and quickly without any central infrastructure in place. Individuals and businesses alike can easily protect selected files...
Provided by Sophos
-
Downloads
Take a Test Drive Down the Road to Better BI
Feb 2010
Sybase PowerDesigner is the industry's leading data modeling tool. But it can do so much more—improving business and IT alignment to boost productivity, providing customized options to enforce...
Provided by Sybase
-
Book chapters
Ensure your SQL Server 2005 environment is secure by design, default, and in deployment
Jan 2006
This sample chapter, taken from Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition), discusses security enhancements that make SQL Server 2005 secure by design,...
Provided by Sams Publishing
-
Downloads
Return more relevant results using full-text search in MySQL
Mar 2006
This document will show you how to perform full-text searches in MySQL. In many cases, a full-text search of a database will return better results then a similar search using a LIKE clause in a...
Provided by TechRepublic
-
Downloads
Web services B2B implementation demonstration: Database design
Sep 2003
Download these two Visio diagrams to generate application databases for John and Tom as part of Builder.com's Web services B2B implementation demonstration: Database design.
Provided by TechRepublic
-
Downloads
Work on remote Subversion repositories locally with Git
Apr 2010
Vincent Danen explains how you can use Git version control on a converted Subversion repository and push your changes back to Subversion.
Provided by Vincent Danen
-
Book chapters
Import and export data in MySQL
Feb 2006
This sample chapter, taken from MySQL 5.0 Certification Study Guide, discusses how to use MySQL to perform bulk data import and export operations. Learn how to perform bulk data import and export...
Provided by Sams Publishing
-
Downloads
How to use default values with database columns
Jun 2005
When you create a database table in Oracle 9i, you have the option to specify a DEFAULT value. Using default values on database columns helps to insulate database design issues from application...
Provided by TechRepublic
-
Downloads
Make the jump from SQL Server 2000/7 to SQL Server 2005 with these notes and tips
Feb 2006
There are a number of changes you should understand before you begin planning the leap from SQL Server 2000 or SQL Server 7 to the recently released SQL Server 2005. Migrating from SQL Server...
Provided by TechRepublic
-
Downloads
10 things you should know about Microsoft's SQL Server 2005
Aug 2005
There's plenty of hype about the new SQL Server 2005. Here's a list what's important about the pending release, and what you can plan on using SQL Server for in the near future. Microsoft's...
Provided by TechRepublic
-
Book chapters
Secure your databases with cryptography
Nov 2005
This sample chapter, taken from Cryptography in the Database: The Last Line of Defense, discusses different types of cryptology and how they can be used to protect the confidentiality of your data...
Provided by Addison Wesley Professional
-
Downloads
Achieve better SQL Server performance with Profiler and Query Analyzer
Apr 2005
The overall performance of Microsoft's SQL Server can only be as good as the queries that are sent to it. The automated query optimizer does the best it can to make the queries as efficient as...
Provided by TechRepublic
-
Downloads
Uncover the hidden capabilities of MySQL with these 10 power tips
Dec 2005
This document looks under the hood to introduce you to some of the less well-known capabilities of MySQL. While MySQL is certainly a well-known and very popular database, it also has a history...
Provided by TechRepublic
-
Downloads
Microsoft SQL Server: Lock it down in 10 steps
Mar 2005
IT departments sometimes have a habit of setting up Microsoft SQL Server systems and then not not giving them much attention. That can result in servers that aren't properly updated and aren't...
Provided by TechRepublic
-
Book chapters
Learn to use PHP and PostgreSQL to deliver dynamic Web content
Dec 2005
This chapter from Sams' PostgreSQL shows how you can use PHP to interact with a database to produce dynamic results. PHP and PostgreSQL combine with your Web server to create a system that...
Provided by Sams Publishing
-
Book chapters
Optimize MySQL with these powerful tips
Nov 2005
This sample chapter, taken from MySQL Administrator's Guide, explains various ways to optimize MySQL. Speed up your system by utilizing MySQL optimization techniques.This sample chapter, taken...
Provided by Sams Publishing
-
Downloads
Gather Windows system details and store in SQL Server 2005 Express with this VBScript
Feb 2006
This VBScript gathers system information from Windows Server 2003, Windows XP and Windows Vista machines and stores the data in a SQL Sever 2005 Express Edition database. Monitoring your servers...
Provided by TechRepublic
-
Downloads
Backing up and restoring MySQL databases in three easy steps
Apr 2005
It is an inevitable fact of life for any database administrator—the hardware that supports your database application is going to fail in some way. This is why database backups are so vital....
Provided by TechRepublic
-
Book chapters
Optimize and tune MySQL
Dec 2005
This sample chapter, taken from Sams Teach Yourself PHP, MySQL and Apache All in One, 2nd Edition, teaches you how to properly optimize your MySQL server. Proper care and feeding of your MySQL...
Provided by Sams Publishing
-
Downloads
A free fully functional database application is yours with SQL Server 2005 Express
Feb 2006
SQL Server Express is available free from Microsoft. This document examines the requirements and the limitations of this free database application. Taking a page from the shareware and open...
Provided by TechRepublic
-
Downloads
Back up and restore PostgreSQL databases with these built-in tools
Aug 2005
If your data is stored in a PostgreSQL table, you can prevent mishaps by regularly backing up your databases. This document shows you the built-in commands that simplify the process. Data is the...
Provided by TechRepublic
-
Book chapters
Achieve Microsoft SQL Server High Availability with data replication
Nov 2005
This sample chapter, taken from Sams' Microsoft SQL Server High Availability, discusses how you can use data replication as a high availability solution. Data replication is a powerful feature of...
Provided by Sams Publishing
-
Book chapters
SQL Building Blocks and Server Settings
Mar 2005
This hefty (200-page) chapter, taken from the comprehensive Transact-SQL Desk Reference: For Microsoft SQL Server, looks at the building blocks that database designers and users have available for...
Provided by Prentice Hall PTR
-
Downloads
Gather hard disk utilization data and store in SQL Server 2005 Express with this VBScript
Mar 2006
This VBScript gathers hard disk utilization information from Windows Server 2003, Windows XP and Windows Vista machines and stores the data in a SQL Sever 2005 Express Edition database. The...
Provided by TechRepublic
-
Book chapters
MySQL best practice techniques for efficient data retrieval and optimal data modification
Dec 2005
This chapter excerpt from MySQL Database Design and Tuning describes how to create the best possible SQL queries for MySQL databases by focusing on two major subtopics: efficient data retrieval...
Provided by Sams Publishing
-
Downloads
Optimize an Oracle database with advanced wait detail analysis
Mar 2005
System-wide tuning of an Oracle database often requires the retrieval of detailed event-based information from the data dictionary. The query presented in this PDF file joins the v_$session_event...
Provided by TechRepublic
-
Downloads
Two scripts to help you maintain and secure an Oracle database
Mar 2005
For Oracle DBAs, scripts, and the time they save, are invaluable for the maintenance and security of enterprise data. The scripts found in this downloadable PDF document automate several...
Provided by TechRepublic
-
Book chapters
Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills
Apr 2006
This sample chapter, taken from Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills, explains the basics of Microsoft Access' pivot tables and pivot charts. Pivot tables...
Provided by Addison Wesley Professional
-
Book chapters
Explore enterprise database management with SQL Server 2005
May 2006
This sample chapter from SQL Server 2005 fills a coverage gap in published guides since the SQL Server 2005 release, covering what's new in enterprise database administration with an emphasis on...
Provided by Addison Wesley Professional
-
Downloads
Quick Reference: Microsoft Access Pack
Jun 2005
If your organization is like most, its business decisions are largely driven by the data it collects. To help ensure that your enterprise's critical data is stored and retrieved as effectively as...
Provided by TechRepublic Pro
-
Downloads
Microsoft SQL Server Resource Guide - ISO
Jan 2005
Burn your own CD version of TechRepublic's Microsoft SQL Server Resource Guide CD-ROM. This download is a complete image of the CD available formerly for sale in our TechRepublic catalog. Whether...
Provided by TechRepublic Pro
-
Downloads
Network Administrators' SQL Server Quick Guide PDF
Sep 2004
This 30-page PDF covers the pressing issues facing IT professionals working with SQL Server, including performance, availability, and security. You'll learn how to set up SQL Server Alerts,...
Provided by TechRepublic Pro
-
Downloads
TechRepublic Pro FastAnswer: Learning basic Microsoft Access keyboard shortcuts - PDF
Apr 2005
GUIs make applications like Microsoft Access much easier to learn, but having to reach for the mouse can actually be counter productive. Knowing a few keyboard shortcuts can save you some time....
Provided by TechRepublic Pro
-
Downloads
SQL Server Survival Guide for Network Administrators
Oct 2004
This resource will guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon to perform; Transact-SQL...
Provided by TechRepublic Pro
-
Book chapters
Evolutionize your database design
Jun 2006
This sample chapter from Refactoring Databases: Evolutionary Database Design argues that evolutionary approaches to development that are iterative and incremental in nature are the de facto...
Provided by Addison Wesley Professional
-
Downloads
Simply a better NAS - Virtual Cloud File Server
Oct 2010
Nasuni's elegant cloud file server turns cloud storage from providers like Amazon, AT&T, Iron Mountain, Rackspace, Nirvanix or Windows Azure into an advanced NAS. The Nasuni Filer is the easiest,...
Provided by Nasuni
