- Subscribe to this page:
- RSS
- Email Alert
data infrastructure
(60 results)Search the Library
Mission Statement
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.
-
Book chapters
Managing OUs, Users, and Groups in Active Directory
May 2006
This sample chapter from Inside Active Directory: A System Administrator's Guide discusses managing OUs and users, contacts, computers, and groups in Active Directory using Active Directory's...
Provided by Addison Wesley Professional
-
Downloads
Five SQL Server scripts for novice DBAs
Jun 2004
For IT professionals who are new to SQL Server, these five scripts can save time and help you do a better job of managing SQL Server and its data.
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
-
Book chapters
Quickly import data into Excel with these techniques
Oct 2005
This sample chapter, taken from Managing Data with Excel, highlights a couple ways to get data from other applications into an Excel worksheet. Learn a couple ways that you can import data into...
Provided by Que 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
10 things you should know about working with Microsoft Access reports
Sep 2005
Mastering reporting basics in Microsoft Access is fairly easy, but working most effectively means going beyond the basics. These tips will help you work more efficiently and create better...
Provided by TechRepublic
-
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
-
Book chapters
A clear explanation of relational databases and the rules that govern them
Apr 2005
Deploying a relational database on almost any scale requires a thorough understanding of the fundamental concepts and rules that govern their behavior. This excerpt from Get It Done With MySQL 5,...
Provided by Artful Software Development
-
Book chapters
Master the basic building blocks of an SQL database query
Nov 2005
This sample chapter, taken from Learning SQL, examines the different parts of the select statement and how they interact. Learn how queries are executed by the MySQL server, and then take a...
Provided by O'Reilly Media
-
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
-
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
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
-
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
TechRepublic Pro 's Business Case Template: New Database Administrator
Mar 2006
Database Administrators play a key role in maintaining data integrity, data availability, and data security. The Database administrator is responsible for the design, implementation, and...
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
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
-
Downloads
Gap Analysis: Active Directory
Oct 2004
This ZDNet-branded Gap Analysis spreadsheet is designed to help you identify gaps that may exist in your organization's technology infrastructure. Once you complete the workbook, this unique...
Provided by TechRepublic Pro
-
Book chapters
Use the GROUP BY clause to aggregate data in MySQL
Apr 2007
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 Comprehensive Tutorial and Reference helps you...
Provided by Addison Wesley Professional
-
Downloads
Keyboard shortcuts for Lotus Notes users
Mar 2005
You can make life a little easier for your Lotus Notes users—and maybe even help them work a little more efficiently—by handing out this set of cheat sheets. To help users zero in on the tasks...
Provided by TechRepublic
-
Downloads
Follow the evolution of an SQL query and automate your database reporting
Jul 2005
This download shows you how a relatively simple SQL query can evolve into a complex SQL Server stored procedure that automatically sends the correct data to the correct person responsible for...
Provided by TechRepublic
-
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
-
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
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 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
Keyboard shortcuts for Lotus Notes users
Mar 2005
You can make life a little easier for your Lotus Notes users—and maybe even help them work a little more efficiently—by handing out this set of cheat sheets. To help users zero in on the tasks...
Provided by TechRepublic
-
Book chapters
Master the basic building blocks of an SQL database query
Nov 2005
This sample chapter, taken from Learning SQL, examines the different parts of the select statement and how they interact. Learn how queries are executed by the MySQL server, and then take a...
Provided by O'Reilly Media
-
Downloads
Database cheat sheet: Setting up an ODBC connection
Apr 2005
The ODBC Data Source Administrator applet lets you set up, troubleshoot, and manage your ODBC configuration. Here's a quick, graphical run-through of the steps you need to follow to set up and...
Provided by TechRepublic
-
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
-
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
Access reference: Working with tables
Jan 2004
When users come to you with Access questions, it helps to have a resource you can refer to for quick answers. Susan Harkins has assembled those answers in an easy-to-read format, covering the...
Provided by TechRepublic
-
Downloads
Folder Size Tracker Tool
Jul 2004
When you want to identify space-hogging folders, you don't need to wade through each folder's Properties data to determine its size. Just point the Folder Size Tracker Tool to the desired path and...
Provided by TechRepublic
-
Downloads
10 questions to consider when optimizing your database
Jan 2006
When it comes to database design, you can make some big performance improvements with some small changes. Here are some basic rules to keep in mind. Following certain standards and design rules...
Provided by TechRepublic
-
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
-
Downloads
Evaluate external data center providers with this 36-point checklist
Mar 2005
Building your own data center may be prohibitively expensive, but leasing space could be a viable alternative—assuming you choose the right facility. Before making your decision, take a careful...
Provided by TechRepublic
-
Downloads
Free Chapter Download - Active Directory, Second Edition
Aug 2005
Active Directory introduced vast improvements for Windows administrators, but it also introduced an entire new set of challenges. The directory services utility, while simplifying user and system...
Provided by TechRepublic
-
Downloads
12 useful MySQL configuration variables that will improve performance
Jun 2005
The default MySQL server settings are optimized for most common uses and for most installations these settings will work just fine as is. However, because MySQL is so open, it's fairly easy for...
Provided by TechRepublic
-
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
-
Downloads
Sample Active Directory Chart
Nov 2003
Figuring out how to properly design an Active Directory environment can be confusing. You can use this sample Visio Active Directory Chart to use as a starting point in designing your Active...
Provided by TechRepublic
-
Downloads
Follow the evolution of an SQL query and automate your database reporting
Jul 2005
This download shows you how a relatively simple SQL query can evolve into a complex SQL Server stored procedure that automatically sends the correct data to the correct person responsible for...
Provided by TechRepublic
-
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
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
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
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
-
Book chapters
A clear explanation of relational databases and the rules that govern them
Apr 2005
Deploying a relational database on almost any scale requires a thorough understanding of the fundamental concepts and rules that govern their behavior. This excerpt from Get It Done With MySQL 5,...
Provided by Artful Software Development
-
Downloads
Free Chapter Download - Active Directory, Second Edition
Aug 2005
Active Directory introduced vast improvements for Windows administrators, but it also introduced an entire new set of challenges. The directory services utility, while simplifying user and system...
Provided by TechRepublic
-
Downloads
12 useful MySQL configuration variables that will improve performance
Jun 2005
The default MySQL server settings are optimized for most common uses and for most installations these settings will work just fine as is. However, because MySQL is so open, it's fairly easy for...
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
-
Downloads
10 common backup mistakes
Nov 2009
Despite their best intentions, IT pros sometimes fall short when it comes to implementing a reliable backup solution. See whether any of these mistakes sound familiar.This download is also...
Provided by Brien Posey
-
Downloads
Keyboard shortcuts for Lotus Notes users
Mar 2005
You can make life a little easier for your Lotus Notes users—and maybe even help them work a little more efficiently—by handing out this set of cheat sheets. To help users zero in on the tasks...
Provided by TechRepublic
-
Downloads
Information Ownership Policy
Jul 2012
TechRepublic's Information Ownership Policy will help you establish guidelines to safeguard your organization's intellectual property.
Provided by TechRepublic Pro
-
Downloads
Data Backup Policy
Mar 2012
TechRepublic's Data Backup Policy will help your organization determine what information is backed up, how backups are administered and maintained, and who is responsible for managing and...
Provided by TechRepublic Pro
-
Book chapters
Master the basic building blocks of an SQL database query
Nov 2005
This sample chapter, taken from Learning SQL, examines the different parts of the select statement and how they interact. Learn how queries are executed by the MySQL server, and then take a...
Provided by O'Reilly Media
-
Book chapters
Mastering the Active Directory Schema
May 2006
This sample chapter from Inside Active Directory: A System Administrator's Guide describes the Active Directory data model and the way in which the rules of the schema enforce it. This sample...
Provided by Addison Wesley Professional
-
Book chapters
Managing OUs, Users, and Groups in Active Directory
May 2006
This sample chapter from Inside Active Directory: A System Administrator's Guide discusses managing OUs and users, contacts, computers, and groups in Active Directory using Active Directory's...
Provided by Addison Wesley Professional
-
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
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
-
Downloads
Sample Active Directory Chart
Nov 2003
Figuring out how to properly design an Active Directory environment can be confusing. You can use this sample Visio Active Directory Chart to use as a starting point in designing your Active...
Provided by TechRepublic
-
Downloads
Database cheat sheet: Setting up an ODBC connection
Apr 2005
The ODBC Data Source Administrator applet lets you set up, troubleshoot, and manage your ODBC configuration. Here's a quick, graphical run-through of the steps you need to follow to set up and...
Provided by TechRepublic
-
Downloads
Follow the evolution of an SQL query and automate your database reporting
Jul 2005
This download shows you how a relatively simple SQL query can evolve into a complex SQL Server stored procedure that automatically sends the correct data to the correct person responsible for...
Provided by TechRepublic
-
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
