- Subscribe to this page:
- RSS
- Email Alert
data infrastructure
(61 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.
-
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
-
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
-
Whitepapers
Simple Strategies for More Effective Business Collaboration: File Sharing
Jan 2013
Not long ago, collaboration required physical meetings, with hard copies of documents passed around the table. Today, colleagues take advantage of technology to reduce the unnecessary drain on...
Provided by ShareFile
-
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
Download a FREE Trial of IP Address Manager from SolarWinds!
Jan 2013
Are you still using spreadsheets to manage your IP space? The explosion of IP-enabled devices in today’s corporate networks has increased the complexity of IP space management beyond what can be...
Provided by SolarWinds
-
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
-
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
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
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
-
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 things to look for in a data center
Jan 2011
Going to the cloud might make a lot of sense for your organization -- but only if you choose a secure, reliable data center that can handle your needs. Erik Eckel runs through 10 essential...
Provided by Erik Eckel
-
Downloads
20 key features of enterprise backup software
Apr 2005
Choosing the right backup software product requires you to consider a number of factors, from reporting functionality to management features to support for various media, storage devices, and...
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
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
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 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
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
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
-
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
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
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
-
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
-
Book chapters
Choose the optimal site for your data center
Jul 2005
Learn the important factors to consider when choosing the perfect location for your data center. This sample chapter, taken from Cisco Press' Build the Best Data Center Facility for Your...
Provided by Cisco Press
-
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
The Internet of Things: A Primer for IT Pros
Jan 2013
The Internet of Things: A Primer for IT Pros includes a glossary and a selection of articles to help you get up to speed on current and future IoT technologies, issues, and implementations.
Provided by TechRepublic Pro
-
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
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
-
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
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
-
Downloads
10 key success factors for enterprise video
Feb 2011
Use of video is escalating in the enterprise, and organizations need to be ready to meet challenges such as platform selection, video file storage, and device compatibility. This download is...
Provided by Greg Pulier
-
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
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
TechRepublic SQL Server QuickStart
Jun 2004
Getting a good start in any new technology or programming language often depends on finding the best available information. Besides explaining the basics, the TechRepublic.com SQL Server...
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
10 useful MySQL date and time functions
May 2005
MySQL is a very powerful RDBMS, and it has a lot more to offer the discerning user than just SELECT and INSERT queries. It's when it comes to date and time manipulation, though, that MySQL truly...
Provided by TechRepublic
-
Downloads
Optimize SQL Server without rewriting queries
Mar 2005
Sluggish SQL Server database performance can be caused by many factors besides just poorly designed queries. While there is certainly a correlation between the quality of your queries and your...
Provided by TechRepublic
-
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
Download a FREE Trial of IP Address Manager from SolarWinds!
Jan 2013
Are you still using spreadsheets to manage your IP space? The explosion of IP-enabled devices in today’s corporate networks has increased the complexity of IP space management beyond what can be...
Provided by SolarWinds
-
Downloads
The Internet of Things: A Primer for IT Pros
Jan 2013
The Internet of Things: A Primer for IT Pros includes a glossary and a selection of articles to help you get up to speed on current and future IoT technologies, issues, and implementations.
Provided by TechRepublic Pro
-
Whitepapers
Simple Strategies for More Effective Business Collaboration: File Sharing
Jan 2013
Not long ago, collaboration required physical meetings, with hard copies of documents passed around the table. Today, colleagues take advantage of technology to reduce the unnecessary drain on...
Provided by ShareFile
-
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
-
Downloads
10 key success factors for enterprise video
Feb 2011
Use of video is escalating in the enterprise, and organizations need to be ready to meet challenges such as platform selection, video file storage, and device compatibility. This download is...
Provided by Greg Pulier
-
Downloads
10 things to look for in a data center
Jan 2011
Going to the cloud might make a lot of sense for your organization -- but only if you choose a secure, reliable data center that can handle your needs. Erik Eckel runs through 10 essential...
Provided by Erik Eckel
-
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
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
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
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+ 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 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
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
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
-
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
-
Book chapters
Exploit advanced T-SQL querying techniques: Aggregating and pivoting data in SQL Server 2005
Aug 2006
Take a detailed look at the internal architecture of T-SQL and unveil the power of set-based querying. Best practices, sample databases, and sample code in Inside Microsoft SQL Server 2005: T-SQL...
Provided by Microsoft Press
-
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
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
-
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
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
Choose the optimal site for your data center
Jul 2005
Learn the important factors to consider when choosing the perfect location for your data center. This sample chapter, taken from Cisco Press' Build the Best Data Center Facility for Your...
Provided by Cisco Press
-
Downloads
10 useful MySQL date and time functions
May 2005
MySQL is a very powerful RDBMS, and it has a lot more to offer the discerning user than just SELECT and INSERT queries. It's when it comes to date and time manipulation, though, that MySQL truly...
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
Optimize SQL Server without rewriting queries
Mar 2005
Sluggish SQL Server database performance can be caused by many factors besides just poorly designed queries. While there is certainly a correlation between the quality of your queries and your...
Provided by TechRepublic
-
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
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
-
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
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
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
-
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
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
20 key features of enterprise backup software
Apr 2005
Choosing the right backup software product requires you to consider a number of factors, from reporting functionality to management features to support for various media, storage devices, and...
Provided by TechRepublic
-
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
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
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
Download a FREE Trial of IP Address Manager from SolarWinds!
Jan 2013
Are you still using spreadsheets to manage your IP space? The explosion of IP-enabled devices in today’s corporate networks has increased the complexity of IP space management beyond what can be...
Provided by SolarWinds
-
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
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
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
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
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
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
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
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
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
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
-
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
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
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
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
20 key features of enterprise backup software
Apr 2005
Choosing the right backup software product requires you to consider a number of factors, from reporting functionality to management features to support for various media, storage devices, and...
Provided by TechRepublic
-
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
-
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
-
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
TechRepublic SQL Server QuickStart
Jun 2004
Getting a good start in any new technology or programming language often depends on finding the best available information. Besides explaining the basics, the TechRepublic.com SQL Server...
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
-
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
-
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
Choose the optimal site for your data center
Jul 2005
Learn the important factors to consider when choosing the perfect location for your data center. This sample chapter, taken from Cisco Press' Build the Best Data Center Facility for Your...
Provided by Cisco Press
-
Downloads
10 useful MySQL date and time functions
May 2005
MySQL is a very powerful RDBMS, and it has a lot more to offer the discerning user than just SELECT and INSERT queries. It's when it comes to date and time manipulation, though, that MySQL truly...
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
Optimize SQL Server without rewriting queries
Mar 2005
Sluggish SQL Server database performance can be caused by many factors besides just poorly designed queries. While there is certainly a correlation between the quality of your queries and your...
Provided by TechRepublic
-
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
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
