SQL Server 2008, SQL Server 2005, SQL Server 2003, SQL Azure, Oracle Tutorials

Change page: < 1 2 > | Displaying page 1 of 2, items 1 to 30 of 47.

Microsoft SQL Server 2008 R2 : Setting Up and Configuring Database Mirroring (part 5) - Monitoring a Mirrored Database Environment & Removing Mirroring

Database Mirroring Monitor allows you to monitor roles of the mirroring partnership, see the history of transactions flowing to the mirror server, see the status and speed of this transaction flow, and set thresholds to alert you if failures or other issues occur.

Microsoft SQL Server 2008 R2 : Setting Up and Configuring Database Mirroring (part 4) - Configuring Database Mirroring by Using the Wizard

After you have the endpoints created, the roles established, the connections to the endpoints granted, and the mirror database restored on the mirror server, you could easily run through the final short steps in the Database Mirroring Wizard to enable and start mirroring.

Microsoft SQL Server 2008 R2 : Setting Up and Configuring Database Mirroring (part 3) - Creating the Database on the Mirror Server & Identifying the Other Endpoints for Database Mirroring

When the endpoints are configured and roles are established, you can create the database on the mirror server and get it to the point of being able to mirror. You must first make a backup copy of the principal database .

Microsoft SQL Server 2008 R2 : Setting Up and Configuring Database Mirroring (part 2) - Creating the Endpoints & Granting Permissions

Each server instance in the database mirroring configuration must have an endpoint defined so that the other servers can communicate with it. This is sort of like a private phone line to your friends.

Microsoft SQL Server 2008 R2 : Setting Up and Configuring Database Mirroring (part 1)

Microsoft uses a few other concepts and technologies in database mirroring. You have already learned about the copy-on-write technology. Microsoft also uses endpoints, which are assigned to each server in a database mirroring configuration.

Microsoft SQL Server 2008 R2 : Database Mirroring - What Is Database Mirroring?

When you mirror a database, you are essentially asking for a complete copy of a database to be created and maintained, with as much up-to-the-second completeness as possible; you are asking for a mirror image.

SQL Injection : Code-Level Defenses - Validating Input

When performing input validation you should always ensure that the input is in its canonical (simplest) form before making any input validation decisions. This may involve decoding the input into a simpler format, or just rejecting input that isn't already in canonical format where non-canonical input isn't expected.

SQL Injection : Code-Level Defenses - Using Parameterized Statements

One of the root causes of SQL injection is the creation of SQL queries as strings that are then sent to the database for execution. This behavior, commonly known as dynamic string building or dynamic SQL, is one of the primary causes of an application being vulnerable to SQL injection.

SQL Server 2005 : Extending User-Defined Aggregates

Each of the other SQLCLR features, with the possible exception of triggers, will see more use in production applications than will aggregates, but aggregates and types are the only members of the group that can help developers do things that simply were not possible before.

SQL Server 2005 : Enhancing Service Broker Scale-Out with SQLCLR

Service Broker is frequently mentioned as an excellent choice for helping to scale out database services. One of the more compelling use cases is a Service Broker service that can be used to asynchronously request data from a remote system.

MySQL Replication for Scale-Out : Managing the Replication Topology - Example of an Application-Level Load Balancer

To handle a large number of reads, sites use replication to create copies of the master and then let the slaves handle all read requests while the master handles the write requests.

MySQL Replication for Scale-Out : Scaling Out Reads, Not Writes & The Value of Asynchronous Replication

To handle a large number of reads, sites use replication to create copies of the master and then let the slaves handle all read requests while the master handles the write requests.

Installing and upgrading SQL Server 2008 : Developing a service pack upgrade strategy

A common planning mistake is to fail to consider the need for scheduled maintenance; therefore, a request to apply a service pack is often met with a negative response in terms of the impact on users.

Upgrading to SQL Server 2008 : Upgrade Advisor, In-place upgrade & Side-by-side upgrade

SQL Server 2008, like 2005, includes an Upgrade Advisor tool, which you can use to examine existing 2000 and/or 2005 instances to determine whether any issues will prevent an upgrade from completing (blocking issues) or backward-compatibility issues that may lead to application failure after the upgrade.

MySQL for Python : Exception Handling - Catching different types of exceptions

Exceptions can be caught with a generic except clause for simpler implementations, but more complex programs should process exceptions by type.

MySQL for Python : Handling exceptions passed from MySQL

MySQL for Python takes care of the nitty-gritty of communication between your program and MySQL. As a result, handling exceptions passed from MySQL is as straightforward as handling exceptions passed from any other Python module.

Oracle SOA Suite 11g : Product Installation - Additional actions (part 2) - Configuration

This section provides the instructions for creating database and JMS resources that are required by the tutorial. Start your database and WebLogic admin servers and complete the following configuration steps.

Oracle SOA Suite 11g : Product Installation - Additional actions (part 1) -Setting memory limits

Review the memory settings. This value is dependent on your machine resources and may need to be adjusted for your machine. Allocating less memory for startup will give you better performance on a machine with less memory available. This value is appropriate for a 3 GB memory machine or less.

Installing SQL Server 2008 : GUI installation & Command prompt installations

After installation, you must perform a number of important configuration activities, such as sizing the tempdb database, setting minimum and maximum memory values, and creating SQL Agent alerts.

Installing and upgrading SQL Server 2008 : Preparing for installation

A SQL Server installation will create several new Windows services, each of which requires an account under which it will run. As we'll see shortly, these accounts are specified during installation, so they need to be created in advance.

Exploiting Second-Order SQL Injection

Second-order SQL injection usually arises because of an easy mistake that developers make when thinking about tainted and validated data.

MySQL for Python : Exception Handling (part 1)

The value of rigorous error checking is exemplified in any of the several catastrophes arising from poor software engineering. Examples abound, but a few are particularly illustrative of what happens when bad data and design go unchallenged.

MySQL for Python : Connecting with a database

In making a phone call, one picks up the handset, dials a number, talks and listens, and then hangs up. Making a database connection through MySQL for Python is nearly as simple.

Using a WCF Service to Integrate SQL Azure Data with SharePoint (part 2) - Creating a Dashboard

Creating a dashboard in SharePoint does not necessarily require code. As a best practice, you should always look to the out-of-the-box functionality before engaging in custom development.

Using a WCF Service to Integrate SQL Azure Data with SharePoint (part 1) - Creating a WCF Service

WCF services can be called from many different types of client applications, such as Windows Forms or Windows Presentation Foundation (WPF) applications, JavaScript or jQuery-based applications, or Silverlight applications.

Oracle SOA Suite 11g : Installing JDeveloper (part 2) - Updating JDeveloper with latest SOA

SOA design time in JDeveloper requires a JDeveloper extension called SOA Composite Editor. While this is normally updated over the network when using release-level software, you can also perform the update manually if you have the extension file.

Oracle SOA Suite 11g : Installing JDeveloper (part 1)

If you are installing JDeveloper on a machine that is not the same as your WebLogic server installation, you must have installed the JDK 6 update 11 first.

SQL Server 2008 : SQL Server and SANs

SAN storage design goals are often in conflict with those of SQL Server. SANs are effective at maximizing disk utilization by sharing a large central store of disks between many servers.

SQL Injection : Evading Input Filters (part 3)

Sanitizing filters often perform several operations on user-supplied data, and occasionally one of the steps is to truncate the input to a maximum length, perhaps in an effort to prevent buffer overflow attacks, or accommodate data within database fields that have a predefined maximum length.

SQL Injection : Evading Input Filters (part 2)

Many databases allow SQL queries to be executed dynamically, by passing a string containing an SQL query into a database function which executes the query.