Updated Articles and Resources
- Subscribing to a SQL Server PublicationCreated: 2009-10-31 @ 10:58:55 EDT Updated: 2009-10-31 @ 11:00:50 EDT
Once you've configured a distributor and created a publication, the last step in configuring SQL Server replication is to create a subscriber who will receive publication updates from the publisher… - Creating a Publication in SQL ServerCreated: 2009-10-18 @ 19:21:33 EDT
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of dat… - Snapshot Replication: Creating a Distributor in SQL Server 2008 for …Created: 2009-10-04 @ 17:46:01 EDT
SQL Server's snapshot replication technology allows you to automatically transfer information between databases to keep them synchronized. In this article, we look at the first step of the snapsho… - Importing Bulk Data into SQL ServerCreated: 2009-09-20 @ 18:38:27 EDT Updated: 2009-09-20 @ 18:39:50 EDT
SQL Server provides three methods you can use when you need to insert large quantities of data into a SQL Server database. These automated techniques will help you insert data from the results of … - Microsoft Access Function Library: IsError()Created: 2009-09-06 @ 20:15:14 EDT
The IsErrorfunction returns a value of true if evaluating the expression results in an error value. Otherwise, it returns false… - Microsoft Access Function Library: IsNumeric()Created: 2009-09-06 @ 20:12:18 EDT
The IsNumeric function returns a value of true if the referenced variable can be evaluated as a number. Otherwise, it returns false… - Microsoft Access Function Library: IsNull()Created: 2009-09-06 @ 20:09:45 EDT
The IsNull function returns a value of true if the referenced variable contains no valid data. Otherwise, it returns false… - Microsoft SQL Server Database Maintenance PlansCreated: 2009-08-23 @ 14:13:52 EDT Updated: 2009-08-23 @ 14:31:31 EDT
Database Maintenance Plans allow you to automate many database administration tasks in Microsoft SQL Server. You can create maintenance plans using an easy wizard-based process without any knowled… - Database Engine Tuning Advisor (DETA): Tuning Your SQL Server Databa…Created: 2009-08-09 @ 16:48:18 EDT
Database Engine Tuning Advisor (DETA) allows you to optimize your SQL Server database configuration based upon the unique business requirements of your organization. It analyzes your database work… - SQL Server Agent; Automating Database Administration in Microsoft SQ…Created: 2009-07-26 @ 15:23:37 EDT Updated: 2009-07-26 @ 15:26:29 EDT
SQL Server Agent allows you to automate a variety of administrative tasks. In this tutorial, we walk through the process of using SQL Server Agent to create and schedule a job that automates datab… - Retrieving Data from Multiple Tables with SQL JoinsUpdated: 2009-09-26 @ 13:55:27 EDT
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction… - Microsoft Access Function Library: IsEmpty()Updated: 2009-09-06 @ 20:12:53 EDT
The IsEmpty function returns a value of true if the referenced variable has not been initialized. Otherwise, it returns false… - Using DatabasesUpdated: 2009-08-23 @ 14:35:13 EDT
Databases offer a powerful, flexible way to manage your organization's data. In this section, we explore several popular database platforms: Microsoft Access, Microsoft SQL Server and MySQL, provi… - IndexUpdated: 2003-09-14 @ 20:23:14 EDT
What is an index? Find out here!…