- SQL 2005 Web Synchronization for Merge Replication
- Oct 13, 2006
- Hilary Cotter provides a tutorial on how to set up Web synchronization in SQL 2005.
|
- Utilities for Microsoft Access
- Oct 13, 2006
- Microsoft Access can be a powerful tool for database development and management. But it's not trivial to learn, and if you want more than the built-in functionality it offers, you may need to look around for some assistance. Rick Cook discusses some of the available resources for helping you to get the most out of Access.
|
- Drag-and-Drop Techniques for Creating Database Applications in Visual Studio 2005
- Sep 22, 2006
- Don't think of drag-and-drop as something for the ill-prepared, says John Mueller. It's a valuable technique for anyone who can express an idea as a stored procedure.
|
- Migrating from Data Transformation Services to Integration Services in SQL Server
- Sep 22, 2006
- The question on most SQL Server Data Transformation Services (DTS) users' minds is how Integration Services (IS) will affect their current packages. The answer is both simple and complex. Kirk Haselden explains the available resources for performing migrations from DTS to IS and some of the problems you might encounter.
|
- Replicating Code Modules with SQL Server 2005
- Sep 15, 2006
- As with previous releases of the software, SQL Server 2005 enables you to replicate code modules. Baya Pavliashvili gives you an overview of replicating code modules and explains when it is beneficial to do so.
|
- Using MySQL Programs
- Sep 15, 2006
- Let the creators of MySQL give you a brief overview of the command-line programs provided by MySQL. They also discuss the general syntax for specifying options when running these programs.
|
- Monitoring and Troubleshooting Replication Using SQL Server 2005
- Sep 1, 2006
- Replication Monitor is a fine monitoring and troubleshooting tool included with SQL Server 2005. In this hands-on article, Baya Pavliashvili discusses ways in which the replication monitoring tools have improved significantly with SQL Server 2005, as compared with previous releases.
|
- The Ten Commandments of Data Protection
- Aug 25, 2006
- For most businesses, data is the most important of the organization's assets. By following Erik Eckel's 10 rules of data protection, you can help ensure that your organization can recover from accident, attack, or disaster.
|
- Maintaining Transactional Replication with SQL Server 2005
- Aug 18, 2006
- Baya Pavliashvili demonstrates the steps necessary to maintain a typical SQL Server 2005 publication, and explains how new options for delivering data changes can help you tailor a replication solution to your application's needs.
|
- Retrieving Data Using the MySQL SELECT Statement
- Aug 18, 2006
- Chris Newman explains how to use a SELECT statement to fetch records from a MySQL database.
|
- Defining and Working with Fields in FileMaker 8
- Aug 11, 2006
- Fields are the heart of any database. By storing information in properly categorized fields, you impart both function and meaning to what would otherwise be an incomprehensible pile of raw data. This chapter describes what kinds of fields exist in FileMaker Pro, how they store information, and how to ensure proper data integrity in your database solutions.
|
- Setting Up Transactional Replication with SQL Server 2005
- Aug 11, 2006
- Baya Pavliashvili walks us through the use of the SQL Server 2005 wizards and scripts for setting up transactional replication and points out some of the cool new features of the latest version.
|
- Backup Basics Part 3: General Tips for a Backup Strategy
- Jul 14, 2006
- Knowing how to configure backup applications and select backup media is half the battle of designing a successful backup strategy. The other half is choosing how and when to back up the specific pieces of data that are stored on your servers, share points, and workstations. In this final article of his series on backup basics for new technicians and administrators, Ryan Faas offers some suggestions to help you make these important decisions.
|
- The Best Data Cleaning Utilities for Windows Systems
- Jul 7, 2006
- Computers are stupid. So are people, sometimes. However that mangled data got into your database, you need to be able to get it straightened out and any duplicates removed. While you can do some of the work yourself, Rick Cook advocates looking over all the possible choices to choose the route that best meets your needs.
|
- Backup Basics Part 2: Demystifying Backup Media
- Jun 30, 2006
- In part two of a three-part series on backup basics, Ryan Faas continues to demystify backup options for new technicians and server/systems administrators. This time, the topic is choosing the media in which to store your backups. Find out the pros and cons of tape, hard drives, and RAID arrays; using network storage; and archiving using CDs or DVDs.
|
- Reporting Services Architecture in SQL Server 2005
- Jun 30, 2006
- SSRS is a comprehensive and extensible reporting platform, which includes an integrated set of processing components, programmatic interfaces, and tools. Processing components are the basis for the multilayered architecture of SSRS and interact with each other to retrieve data, process layout, render, and deliver a report to a target destination.
|
- Notification Services and the Service Broker in SQL Server 2005
- Jun 23, 2006
- In this chapter, you will examine a targeted approach for data distribution. Using Notification Services, you can trigger specific datagrams to users based on conditions in your database, from notifying someone that a stock price has changed to alerting that a machine has just gone offline.
|
- Backup Basics Part 1: Demystifying Server and Workstation Backup Methods
- Jun 16, 2006
- Understanding the options for backing up servers and workstations is important for any technician or system/server administrator. But for new IT staff, all the details about how backups work and how to configure them can be confusing. In this first article in a three-part series, Ryan Faas demystifies the various types of backups that can be performed on servers and workstations using most backup applications.
|
- In-Process Data Access in SQL Server 2005
- Jun 16, 2006
- Whether you access data from the client, middle tier, or server, when you’re using SQL Server and the .NET Framework, you use the SqlClient data provider. Your data access code is similar regardless of its location, but the .NET Framework 2.0 version of SqlClient contains code to encapsulate differences when you’re programming inside SQL Server and optimize the in-server programming environment. This chapter introduces you to the idea of in-process data access.
|
- Keeping Your Data Safe with a RAID 1 Setup
- Jun 16, 2006
- Kulvir Bhogal shows you how you can build a low-cost RAID 1 setup to protect yourself against hard drive data loss.
|