- Subscribe to this page:
- RSS
- Email Alert
database management
(120 results)-
Book chapters
Secure your databases with cryptography
Nov 2005
This sample chapter, taken from Cryptography in the Database: The Last Line of Defense, discusses different types of cryptology and how they can be used to protect the confidentiality of your data...
Provided by Addison Wesley Professional
-
Downloads
Achieve better SQL Server performance with Profiler and Query Analyzer
Apr 2005
The overall performance of Microsoft's SQL Server can only be as good as the queries that are sent to it. The automated query optimizer does the best it can to make the queries as efficient as...
Provided by TechRepublic
-
Downloads
Uncover the hidden capabilities of MySQL with these 10 power tips
Dec 2005
This document looks under the hood to introduce you to some of the less well-known capabilities of MySQL. While MySQL is certainly a well-known and very popular database, it also has a history...
Provided by TechRepublic
-
Downloads
Microsoft SQL Server: Lock it down in 10 steps
Mar 2005
IT departments sometimes have a habit of setting up Microsoft SQL Server systems and then not not giving them much attention. That can result in servers that aren't properly updated and aren't...
Provided by TechRepublic
-
Book chapters
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
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
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
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
-
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
-
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
Network Administrators' SQL Server Quick Guide PDF
Sep 2004
This 30-page PDF covers the pressing issues facing IT professionals working with SQL Server, including performance, availability, and security. You'll learn how to set up SQL Server Alerts,...
Provided by TechRepublic Pro
-
Downloads
TechRepublic Pro FastAnswer: Learning basic Microsoft Access keyboard shortcuts - PDF
Apr 2005
GUIs make applications like Microsoft Access much easier to learn, but having to reach for the mouse can actually be counter productive. Knowing a few keyboard shortcuts can save you some time....
Provided by TechRepublic Pro
-
Downloads
SQL Server Survival Guide for Network Administrators
Oct 2004
This resource will guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon to perform; Transact-SQL...
Provided by TechRepublic Pro
-
Book chapters
Work with SQL Server Agent jobs
Jun 2006
Microsoft SQL Server features a powerful and flexible job-scheduling engine called SQL Server Agent. This sample chapter from MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server...
Provided by Microsoft Press
-
Downloads
Quick Guide: MySQL 5.0
Aug 2006
If you want to build a high-power database solution, a good way to go is to deploy MySQL 5.0. Doing so can be a huge undertaking. This Quick Guide shows you what you need to know to set up,...
Provided by TechRepublic Pro
-
Book chapters
Create dynamic database reports with JasperReports, the leading open source Java reporting tool
Sep 2006
JasperReports is a powerful open source Java reporting tool that has the ability to deliver rich, dynamic content onto the screen, to the printer, or into PDF, HTML, XLS, CSV and XML files....
Provided by Packt Publishing
-
Book chapters
Convert stored data into business intelligence: Implement online analytical processing (OLAP) with Microsoft Analysis Services
Sep 2006
A data warehouse is a general structure for storing the data needed for good business intelligence (BI), but data in a warehouse is of little use until it is converted into the information that...
Provided by Microsoft Press
-
Book chapters
Use cursors wisely in your T-SQL Programming
Oct 2006
T-SQL database developers and administrators with solid knowledge of the various cursor types and the syntax for declaring and using them will deepen their understanding of when and how to use...
Provided by Microsoft Press
-
Book chapters
Master advanced searching to take your SQL query skills to the next level
Oct 2006
If you know the rudiments of the SQL query language but want to take your skills to the next level, learn how to take full advantage of SQL's expressive power: work more with SQL inside the...
Provided by O'Reilly Media
-
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
Master the basics of designing relational databases with Visual Studio and SQL Server 2005
Nov 2006
For the most part, the process of creating a database is hidden from us by a database application's IDE: we just use drag-and-drop or use wizards to build the databases and tables we want. This...
Provided by Addison Wesley Professional
-
Book chapters
Administer SQL Server 2005 Express Edition
Dec 2006
SQL Server Express is a free, easy-to-use, simple-to-manage database without many of the features of the full-blown SQL Server, but powerful and flexible enough to meet the needs of low-end...
Provided by Sybex
-
Book chapters
Troubleshoot waiting and blocking issues in SQL Server 2005
Dec 2006
Waiting and blocking, two of the most common problems SQL Server users encounter, can touch many aspects of SQL Server, so any investigation of them benefits from a solid understanding of how SQL...
Provided by Addison Wesley Professional
-
Downloads
How do I... Publish Microsoft Access check box controls to a Word document?
Apr 2007
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 literal values or use...
Provided by Susan Harkins
-
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
Lunch and Learn: Get up to speed on Microsoft Access 2007
Apr 2007
This is a prepackaged presentation designed to be given in a classroom or conference room setting to help attendees become familiar with Access 2007. Everything is ready to be used even if you...
Provided by TechRepublic Pro
-
Downloads
A couple of MySQL stored procedures myths get busted
Jun 2007
Two often repeated myths about MySQL stored procedures include (1) MySQL does not support stored procedures and (2) MySQL stored procedures are too difficult to work with under typical...
Provided by Edmond Woychowsky
-
Downloads
TechRepublic's Access 2003 Lunch and Learn collection
Jul 2007
You can use this collection of TechRepublic Lunch and Learns to get users up to speed quickly on Microsoft Access 2003. This download contains the following five Lunch and Learn presentations:...
Provided by TechRepublic Pro
-
Book chapters
Use the QtSql module to build Qt applications that work with various relational database management systems
Jul 2007
Nowadays, it's difficult to imagine many applications being able to function without relational databases to back them up. For this reason, Qt provides a range of classes in the QtSql module that...
Provided by No Starch Press
-
Downloads
How do I... Transfer logins from one SQL Server 2005 instance to another?
Sep 2007
In a previous download, Steven Warren described how to restore a SQL Server to a new server. That download lead to some questions regarding how to move SQL Server logins from one SQL Server...
Provided by Steven Warren
-
Downloads
How do I... 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
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
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
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
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
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
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
-
Book chapters
Design Access 2003 forms for efficient and accurate data entry
Oct 2005
This sample chapter, taken from Microsoft Access 2003 Forms, Reports, and Queries, teaches you techniques that will help reduce data-entry errors. Learn how to set up your forms in Access 2003 so...
Provided by Que Publishing
-
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
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
-
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
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
-
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
-
Book chapters
Secure your databases with cryptography
Nov 2005
This sample chapter, taken from Cryptography in the Database: The Last Line of Defense, discusses different types of cryptology and how they can be used to protect the confidentiality of your data...
Provided by Addison Wesley Professional
-
Downloads
Achieve better SQL Server performance with Profiler and Query Analyzer
Apr 2005
The overall performance of Microsoft's SQL Server can only be as good as the queries that are sent to it. The automated query optimizer does the best it can to make the queries as efficient as...
Provided by TechRepublic
-
Downloads
Uncover the hidden capabilities of MySQL with these 10 power tips
Dec 2005
This document looks under the hood to introduce you to some of the less well-known capabilities of MySQL. While MySQL is certainly a well-known and very popular database, it also has a history...
Provided by TechRepublic
-
Downloads
Microsoft SQL Server: Lock it down in 10 steps
Mar 2005
IT departments sometimes have a habit of setting up Microsoft SQL Server systems and then not not giving them much attention. That can result in servers that aren't properly updated and aren't...
Provided by TechRepublic
-
Book chapters
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
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
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
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
-
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
-
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
-
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
-
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
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
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
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
-
Book chapters
Import and export data in MySQL
Feb 2006
This sample chapter, taken from MySQL 5.0 Certification Study Guide, discusses how to use MySQL to perform bulk data import and export operations. Learn how to perform bulk data import and export...
Provided by Sams Publishing
-
Downloads
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 Quest Software, now a part of Dell
-
Book chapters
Protect your database with a thorough and effective database security plan
Feb 2007
If you happen to be a database administrator, a written database security plan can be a lifesaver, both on initial database setup and as an ongoing reminder of the symbiotic relationship between...
Provided by IBM Press
-
Downloads
10+ tips for designing flexible and efficient Access tables
Mar 2007
The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access...
Provided by Susan Harkins
-
Downloads
A simple solution for tracking changes to Access data
Mar 2007
When you have a lot of users changing data, it's easy for things to go wrong. But if you keep an audit trail of data input changes, you'll be able to determine which operators are consistently...
Provided by Susan Harkins
-
Downloads
How do I... Publish Microsoft Access check box controls to a Word document?
Apr 2007
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 literal values or use...
Provided by Susan Harkins
-
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
Lunch and Learn: Get up to speed on Microsoft Access 2007
Apr 2007
This is a prepackaged presentation designed to be given in a classroom or conference room setting to help attendees become familiar with Access 2007. Everything is ready to be used even if you...
Provided by TechRepublic Pro
-
Downloads
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
How Do I... Restore a SQL Server database to a new server?
Jun 2007
As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out...
Provided by Steven Warren
-
Downloads
A couple of MySQL stored procedures myths get busted
Jun 2007
Two often repeated myths about MySQL stored procedures include (1) MySQL does not support stored procedures and (2) MySQL stored procedures are too difficult to work with under typical...
Provided by Edmond Woychowsky
-
Downloads
How do I... 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
TechRepublic's Access 2003 Lunch and Learn collection
Jul 2007
You can use this collection of TechRepublic Lunch and Learns to get users up to speed quickly on Microsoft Access 2003. This download contains the following five Lunch and Learn presentations:...
Provided by TechRepublic Pro
-
Book chapters
Use the QtSql module to build Qt applications that work with various relational database management systems
Jul 2007
Nowadays, it's difficult to imagine many applications being able to function without relational databases to back them up. For this reason, Qt provides a range of classes in the QtSql module that...
Provided by No Starch Press
-
Downloads
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
Lunch and Learn: Microsoft Access 2007 Basics
Sep 2007
The Microsoft Access 2007 Basics presentation is a prepackaged solution designed to help familiarize attendees with the database program's basic functions. The presentation contains everything you...
Provided by TechRepublic Pro
-
Downloads
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
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
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
-
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
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
-
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
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
-
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
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
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
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
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
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
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
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+ 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
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
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
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
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 Quest Software, now a part of Dell
-
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 Quest Software, now a part of Dell
-
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
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
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+ 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
