- Subscribe to this page:
- RSS
- Email Alert
database management
(119 results)-
Downloads
It has arrived! A more intelligent way to manage IT alerts - for FREE!
Mar 2013
SolarWinds Alert Central is centralized IT alert management software that provides amazingly streamlined alert management for your entire IT organization. Alert Central consolidates and manages...
Provided by SolarWinds
-
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
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
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
A free self-service analytic tool for business analysts
Nov 2012
Empower yourself with a new, agile way to analyze, optimize, and control your data and business processes. Experience Lavastorm Desktop Public today and become a data hero overnight. Lavastorm...
Provided by Lavastorm Analytics
-
Downloads
Free 30 Day Trial: Customizable Business Software with Intuit QuickBase
Sep 2012
Intuit QuickBase revolutionizes the way people work by enabling professionals to quickly create their own cloud-based applications and drive vastly improved team productivity. Finding a solution...
Provided by Intuit
-
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
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
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
-
Whitepapers
Move to the Cloud Without Compromising Security
Jan 2013
You’ve heard why so many companies now store data in the cloud: access anytime, from any computer or device, and scalability. However, many businesses have valid concerns about giving up control...
Provided by ShareFile
-
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
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
-
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
Secure Copy trial download
Sep 2012
Migrate Quickly, Easily and Securely - for Free! Migrating data between Windows-based devices? It isn't just moving information - it's copying data, permissions, shares, users and groups, and...
Provided by Dell Software
-
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
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+ 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
-
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
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
-
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
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
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
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
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
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
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
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
Protect Your Critical Oracle Data - for Free!
Jul 2012
LiteSpeed Engine for Oracle cuts storage costs, reduces backup/restore times and delivers a solid return-on-investment - while keeping total control over the backup and recovery process. It's...
Provided by Dell Software
-
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
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
It has arrived! A more intelligent way to manage IT alerts - for FREE!
Mar 2013
SolarWinds Alert Central is centralized IT alert management software that provides amazingly streamlined alert management for your entire IT organization. Alert Central consolidates and manages...
Provided by SolarWinds
-
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
-
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
-
Whitepapers
Move to the Cloud Without Compromising Security
Jan 2013
You’ve heard why so many companies now store data in the cloud: access anytime, from any computer or device, and scalability. However, many businesses have valid concerns about giving up control...
Provided by ShareFile
-
Downloads
Free 30 Day Trial: Customizable Business Software with Intuit QuickBase
Sep 2012
Intuit QuickBase revolutionizes the way people work by enabling professionals to quickly create their own cloud-based applications and drive vastly improved team productivity. Finding a solution...
Provided by Intuit
-
Downloads
A free self-service analytic tool for business analysts
Nov 2012
Empower yourself with a new, agile way to analyze, optimize, and control your data and business processes. Experience Lavastorm Desktop Public today and become a data hero overnight. Lavastorm...
Provided by Lavastorm Analytics
-
Downloads
Secure Copy trial download
Sep 2012
Migrate Quickly, Easily and Securely - for Free! Migrating data between Windows-based devices? It isn't just moving information - it's copying data, permissions, shares, users and groups, and...
Provided by Dell Software
-
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
Protect Your Critical Oracle Data - for Free!
Jul 2012
LiteSpeed Engine for Oracle cuts storage costs, reduces backup/restore times and delivers a solid return-on-investment - while keeping total control over the backup and recovery process. It's...
Provided by Dell Software
-
Downloads
Protect Your Critical Oracle Data - for Free!
Apr 2012
LiteSpeed Engine for Oracle cuts storage costs, reduces backup/restore times and delivers a solid return-on-investment - while keeping total control over the backup and recovery process. It's...
Provided by Dell Software
-
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
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
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... 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
-
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
Create a site for e-commerce with PHP, MySQL, and PayPal
Feb 2005
This how-to article offers step-by-step instructions for adding e-commerce capabilities to your existing Web site using PHP, MySQL, and PayPal. The method outlined here lets you add e-business...
Provided by TechRepublic
-
Whitepapers
Move to the Cloud Without Compromising Security
Jan 2013
You’ve heard why so many companies now store data in the cloud: access anytime, from any computer or device, and scalability. However, many businesses have valid concerns about giving up control...
Provided by ShareFile
-
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
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
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
-
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
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
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
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
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
Anatomy of Excel data analysis: Achieve better information organization with subtotals
Nov 2005
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...
Provided by TechRepublic
-
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
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
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
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
Vendor Questionnaire: Content Management Software
Nov 2004
Content Management Software (CMS) works by using the scripting language and database combination to manage Web site content. This tool will help you select the best vendor for this key IT purchase.
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
-
Downloads
Comparison chart of free databases: MySQL 5, SQL Server 2005 Express, and Oracle 10g Express
Jan 2006
If you're trying to choose between the recently released MySQL 5.0, SQL Server 2005 Express Edition, and the beta version of Oracle 10g Express Edition, this quick side-by-side comparison will...
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
-
Downloads
IT Hiring Kit: Database Administrator
Mar 2006
The IT Hiring Kit for Database Administrators will help you interview, evaluate, and select suitable candidates for a DBA position. This kit comes with a detailed job description, interview...
Provided by TechRepublic Pro
