![]() |
Live Webcast: Ensuring Continuity of Operations
Disasters come in all shapes and sizes and you never really know exactly when or how they're going to happen. Unfortunately, they are most likely going to happen at some...
Sponsored by: TechRepublic
Date: August 2008 |
|
- Showing items 1-40 of 250
- « Previous | Next 40 »
![]() |
10+ tips for upsizing an Access database to SQL Server
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 wres...
Company: Susan Harkins
Date: July 2008 |
Susan Harkins |
![]() |
How do I... Reseed a SQL Server identity column?
Microsoft SQL Server's identity column generates sequential values for new records using a seed value. You can control the column's first and subsequent values, by spe...
Company: Susan Harkins
Date: July 2008 |
Susan Harkins |
![]() |
How do I... Identify and delete duplicates from SQL Server tables?
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 everythin...
Company: Susan Harkins
Date: June 2008 |
Susan Harkins |
![]() |
IT Hiring Kit: SQL Server Database Administrator
New version designed especially for SQL Server DBAs!
The IT Hiring Kit for SQL Server Database Administrators will help you interview, evaluate, and select ...
Company: TechRepublic Pro
Date: April 2008 |
TechRepublic Pro |
![]() |
IT Hiring Kit: Oracle Database Administrator
New version designed especially for Oracle DBAs!
The IT Hiring Kit for Oracle Database Administrators will help you interview, evaluate, and select suitable...
Company: TechRepublic Pro
Date: April 2008 |
TechRepublic Pro |
| More Search Results Below | ||
![]() |
10 ways to prevent Access database corruption
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. Sometim...
Company: Susan Harkins
Date: April 2008 |
Susan Harkins |
![]() |
Lunch And Learn: Get Up To Speed On OpenOffice Base
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 OpenOf...
Company: TechRepublic Pro
Date: March 2008 |
TechRepublic Pro |
![]() |
TechRepublic's Updated VISIO Rack Diagram Stencil
Download TechRepublic's Visio stencil for rack diagramming of common servers, networking equipment, and power management equipment.
We have updated basic server typ...
Company: TechRepublic Pro
Date: January 2008 |
TechRepublic Pro |
![]() |
How do I... Reject alpha characters in a SQL Server character column?
Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data fr...
Company: Susan Harkins
Date: January 2008 |
Susan Harkins |
![]() |
Microsoft Access 2007 Advanced Functionality Lunch And Learn
This Microsoft Access 2007 - Advanced Functionality presentation is a preformatted solution for training staff to maximize Microsoft Access's more advanced functions. The...
Company: TechRepublic Pro
Date: January 2008 |
TechRepublic Pro |
![]() |
How do I... Install and configure Spotlight on SQL Server?
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...
Company: Josh Hoskins
Date: December 2007 |
Josh Hoskins |
![]() |
How do I... Install, configure, and use LiteSpeed for database backups?
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 effic...
Company: Josh Hoskins
Date: November 2007 |
Josh Hoskins |
![]() |
Plan and create a custom database with Microsoft Access 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 A...
Company: Que Publishing
Date: October 2007 |
Que Publishing |
![]() |
How do I... Transfer logins from one SQL Server 2005 instance to another?
In a previous download, Steven Warren described how to restore a SQL Server to a n...
Company: Steven Warren
Date: September 2007 |
Steven Warren |
![]() |
10 things you should cover in your business continuity plan
Business continuity is much more than just a fancy word for "backup" -- although some organizations treat it that way. A comprehensive business continuity plan (BCP) prov...
Company: Deb Shinder
Date: September 2007 |
Deb Shinder |
![]() |
Lunch and Learn: Microsoft Access 2007 Intermediate Skills
This Microsoft Access 2007 Intermediate Skills presentation provides a preformatted presentation for helping staff better leverage the database application's capabilities...
Company: TechRepublic Pro
Date: September 2007 |
TechRepublic Pro |
![]() |
Lunch and Learn: Microsoft Access 2007 Basics
The Microsoft Access 2007 Basics presentation is a prepackaged solution designed to help familiarize attendees with the database program's basic functions. The presentati...
Company: TechRepublic Pro
Date: September 2007 |
TechRepublic Pro |
![]() |
How do I... Configure transactional replication between two SQL Server 2005 systems?
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, re...
Company: Josh Hoskins
Date: August 2007 |
Josh Hoskins |
![]() |
Best storage strategies for the multimedia PC
The modern PC has become the storage and entertainment hub of the home for many consumers, and some people are gobbling up terabytes of data per year storing their DVD li...
Company: George Ou
Date: August 2007 |
George Ou |
![]() |
Master the use of custom functions in FileMaker 9
Just as any writer needs a dictionary, both beginning and seasoned FileMaker developers can always use a handbook of time-tested FileMaker solutions to use as refer...
Company: Que Publishing
Date: August 2007 |
Que Publishing |
![]() |
How do I... Set up replication between Microsoft SQL Server 2000 and MySQL
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 corre...
Company: Josh Hoskins
Date: August 2007 |
Josh Hoskins |
![]() |
IT Manager's Tool Kit, Third Edition
Make better use of your time. Leverage the grassroots advice and proven time-saving tools collected in TechRepublic's IT Manager's Tool Kit, Third Edition. Proven peer-au...
Company: TechRepublic Pro
Date: August 2007 |
TechRepublic Pro |
![]() |
How do I... Install, configure, and use Microsoft's iSCSI initiator?
No longer is shared storage a niche enjoyed by only large, wealthy corporations. Internet SCSI is leveling the playing field by making shared storage available at a re...
Company: Scott Lowe
Date: July 2007 |
|
![]() |
Use the QtSql module to build Qt applications that work with various relational database management systems
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 c...
Company: No Starch Press
Date: July 2007 |
No Starch Press |
![]() |
TechRepublic's Access 2003 Lunch and Learn collection
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 an...
Company: TechRepublic Pro
Date: July 2007 |
TechRepublic Pro |
![]() |
How do I... Query foreign data using SQL Server's linked servers?
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....
Company: Susan Harkins
Date: July 2007 |
Susan Harkins |
![]() |
A couple of MySQL stored procedures myths get busted
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 w...
Company: Edmond Woychowsky
Date: June 2007 |
Edmond Woychowsky |
![]() |
How Do I... Restore a SQL Server database to a new server?
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 y...
Company: Steven Warren
Date: June 2007 |
Steven Warren |
![]() |
Streamline Exchange management with Microsoft Operations Manager 2005 and the Exchange Management Pack
When you import the Exchange Management Pack into Microsoft Operations Manager 2005 (MOM), groups of rules, performance counters, interfaces, reports, and other featu...
Company: Syngress
Date: May 2007 |
Syngress |
![]() |
SolutionBase: Simplify SMB backups using Iomega Rev Disks
First there was the ZIP disk, and then the JAZ. Iomega has recently taken removable disk storage to a new level with the Iomega Rev disk. Here's how you can use it as a t...
Company: Erik Eckel
Date: May 2007 |
Erik Eckel |
![]() |
Lunch and Learn: Get up to speed on Microsoft Access 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...
Company: TechRepublic Pro
Date: April 2007 |
TechRepublic Pro |
![]() |
Use the GROUP BY clause to aggregate data in MySQL
SQL is a compact and powerful language for working with databases, and MySQL offers a SQL dialect with particular power. SQL for MySQL Developers: A Comprehensiv...
Company: Addison Wesley Professional
Date: April 2007 |
Addison Wesley Professional |
![]() |
TechRepublic's Backup and Update Schedule form
Backup schedules can sometimes conflict causing backups to fail or to overlap. Also, sometimes automatic updates are scheduled to occur at the same time as your backups, ...
Company: TechRepublic Pro
Date: April 2007 |
TechRepublic Pro |
![]() |
SolutionBase: Backup Linux reliably with rsync and tar
If you want to have a successful disaster recovery plan in place, you've got to start with backups. There are several utilities you can use to back up Linux servers, but ...
Company: Jack Wallen
Date: April 2007 |
Jack Wallen |
![]() |
How do I... Publish Microsoft Access check box controls to a Word document?
When you publish an Access report to Word, you'll lose any check boxes the report contains. Luckily, you can take advantage of a couple of workarounds: either display the...
Company: Susan Harkins
Date: April 2007 |
Susan Harkins |
![]() |
10 things you should know about automated backup programs
Eliminating the daily pressure of having to manually back up an organization's critical data opens valuable time that can be dedicated to other responsibilities. Howev...
Company: Erik Eckel
Date: April 2007 |
Erik Eckel |
![]() |
Worst practices for disaster recovery
Based on his years in IT, Consultant Peter Herbener has compiled this series of the four worst practices for disaster recovery. Along with these cautionary tales and ...
Company: Peter Herbener
Date: April 2007 |
Peter Herbener |
![]() |
A simple solution for tracking changes to Access data
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 oper...
Company: Susan Harkins
Date: March 2007 |
Susan Harkins |
![]() |
10+ tips for designing flexible and efficient Access tables
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 effe...
Company: Susan Harkins
Date: March 2007 |
Susan Harkins |
![]() |
How do I... Enforce domain integrity for SQL Server data using CHECK constraints?
Even simple errors in data can result in huge problems. Luckily, you can eliminate at least some of those errors by using CHECK constraints to force users to enter data t...
Company: Susan Harkins
Date: March 2007 |
Susan Harkins |
- Showing items 1-40 of 250
- « Previous | Next 40 »
Related Categories:
Downloads
Resources to simplify your IT life
TechRepublic's Download Directory is the place to get free tech resources in a variety of formats, including PDF versions of popular articles, "10 things" lists, sample chapters from technology books, "How do I..." problem-solving guides, cheat sheets for knocking out IT tasks, keyboard shortcuts, glossaries, career pointers, and collections of tips and techniques that focus on critical topics. Check out some examples of these handy documents:
Newsletters
Stay up-to-date on TechRepublic's Downloads by receiving these newsletters in your inbox...
Click to sign up:
10 Things
TechRepublic's lists of "10
things" are some of the most popular articles and downloads on our site.
Latest lists: 10 things you can do to...









