Tutorials,Articles,Algorithms,Tips,Examples about Database

Change page: < 1 2 3 4 5 6 7 8 9 10 11 12 > | Displaying page 5 of 12, items 161 to 200 of 441.

Transact-SQL in SQL Server 2008 : Spatial Data Types (part 1) - Representing Spatial Data, Working with Geometry Data

The geometry data type is implemented as a common language runtime (CLR) data type in SQL Server and is used to represent data in a Euclidean (flat) coordinate system.

Transact-SQL in SQL Server 2008 : Sparse Columns

SQL Server 2008 provides a new space-saving storage option referred to as sparse columns. Sparse columns can provide optimized and efficient storage for columns that contain predominately NULL values.

SQL Server 2005 : Beyond OWC: Full-On OLAP Development (part 4) - Analysis Services CLR Support: Server-Side ADO MD.NET

Unlike SQL CLR integration, Analysis Services CLR support is on by default. In fact, it cannot be disabled. However, only users with administrative permissions on the Analysis Services server or database may load CLR assemblies.

SQL Server 2005 : Beyond OWC: Full-On OLAP Development (part 3) - XMLA at Your Service

Although XMLA can be used as a true Web service (and before the SQL Server 2005 release of Analysis Services, it had to be), its elevation to native API status changes things a bit.

SQL Server 2005 : Beyond OWC: Full-On OLAP Development (part 2) - OLAP Development with ADO MD.NET

With the introduction of SQL Server Analysis Services 2005, this kind of programming is almost as easy as data access programming against relational databases. That’s because Microsoft has created an ADO.NET managed data provider called ADO MD.NET, which you can use against Analysis Services databases.

SQL Server 2005 : Beyond OWC: Full-On OLAP Development (part 1) - Management Studio as an MDX Client

Management Studio is a replacement not only for SQL Enterprise Manager and SQL Query Analyzer but also for the SQL Server 2000 Analysis Services tools: Analysis Manager and the MDX Sample Application.

Microsoft SQL Server 2008 R2 : Using FILESTREAM Storage (part 2) - Using FILESTREAM Storage for Data Columns

Once FILESTREAM storage is enabled for a database, you can specify the FILESTREAM attribute on a varbinary(max) column to indicate that a column should store data in the FILESTREAM filegroup on the file system.

Microsoft SQL Server 2008 R2 : Using FILESTREAM Storage (part 1) - Enabling FILESTREAM Storage

If you decide to use FILESTREAM storage, it first needs to be enabled at both the Windows level as well as at the SQL Server Instance level. FILESTREAM storage can be enabled automatically during SQL Server installation or manually after installation.

SQL Server 2005 : Using Excel (part 2) - Using PivotTables and Charts in Applications and Web Pages

Although the temptation to use Excel as your OLAP front end is compelling, such a client environment is a far cry from a true custom-developed application. Many developers will greatly prefer to host PivotTables within applications rather than ceding control of OLAP functionality to Excel.

SQL Server 2005 : Using Excel (part 1) - Working Within Excel

The techniques described in this section require that MSQuery, an Excel installation option, be installed on your PC. If it is not, Excel will ask you at a certain point if you want to install it. When asked, you should answer Yes and supply your Office installation media if prompted.

Microsoft SQL Server 2008 R2 : Hierarchyid Data Type (part 2) - Modifying the Hierarchy

The script in Listing 2 performs the initial population of the Parts_hierarchy table. What if you need to add additional records into the table? Let’s look at how to use the GetDescendant method to add new records at different levels of the hierarchy.

Microsoft SQL Server 2008 R2 : Hierarchyid Data Type (part 1) - Creating a Hierarchy, Populating the Hierarchy, Querying the Hierarchy

The Hierarchyid data type introduced in SQL Server 2008 is actually a system-supplied common language runtime (CLR) user-defined type (UDT) that can be used for storing and manipulating hierarchical structures (for example, parent-child relationships) in a relational database.

Using SQL Server 2005 Integration Services : Extensibility (part 4) - Custom Connection Managers

Integration Services supports the notion of pluggable connection manager components. If you build and register a connection manager component, it will appear in the list of available connection types when you right-click in the Connection Managers tray and choose New Connection.

Using SQL Server 2005 Integration Services : Extensibility (part 3) - Script Components

The script component is one of the easiest ways to extend the functionality of the data flow. It allows access to the data flow using script written in Visual Basic .NET. When should you use a script component instead of a custom component?

Using SQL Server 2005 Integration Services : Extensibility (part 2) - Custom Components

Writing custom components is one way to extend the functionality of the data flow task. In a sense, all components are custom components, even the ones that ship with Integration Services, which shows how flexible and powerful custom components can be.

Using SQL Server 2005 Integration Services : Extensibility (part 1) - Script Tasks

A Script Task is a very simple way to introduce custom code into the execution of a package. It does not require building separate components—the code for the Script Task is stored inside the package and compiled on demand before execution.

.NET Compact Framework 3.5 : Working with Data Sets (part 3) - Reading and Writing a Data Set as XML

A database is not the only source for or destination of data set data. XML files can also be the storage media for the data. Unlike database access, which requires a separate provider-specific class to perform the transfer, XML file I/O is done by the DataSet class itself.

.NET Compact Framework 3.5 : Working with Data Sets (part 2) - Data Binding

The ADO.NET DataSet class lies at the center of the three-tiered approach . Understanding the DataSet class and its contained objects is a key to successful data management in managed code. Let’s recap what we have already said about data sets.

.NET Compact Framework 3.5 : Working with Data Sets (part 1) - Creating and Accessing DataSet, DataTable, and DataView Objects

.NET Compact Framework 3.5 : Examining ADO.NET

The ADO.NET memory-resident database classes treat data as provider-agnostic, meaning there is no easy way—and, hopefully, no need—to determine which data came from what data source.

Using SQL Server 2005 Integration Services : Programming Integration Services (part 4) - Connecting the Source and Destination Adapters with a Path

The virtual input is used to access a component’s virtual input column collection. This collection contains columns that are based on all the upstream columns that can be used to create the component’s input columns.

Using SQL Server 2005 Integration Services : Programming Integration Services (part 3) - Setting Up Column Information

Other AccessMode values are available, such as a mode for retrieving the SQL command from an Integration Services variable. One way to get a list of access modes and their associated enumeration is to look in the type library for the OLE DB source adapter. For example, you can open Oledbsrc.dll in the Object Browser in Visual Studio.

Using SQL Server 2005 Integration Services : Programming Integration Services (part 2)

Instead of using OleDbConnection as the index value into a component’s runtime connection collection, we could also use 0 as the index because there is only one runtime connection in the collection.

Using SQL Server 2005 Integration Services : Programming Integration Services (part 1) - Creating Packages Programmatically - Data Flow

In addition to loading and executing packages programmatically, you can also use the Integration Services object model to create packages programmatically. The package’s control flow and data flow are conceptually different and therefore have different methods for their construction.

Using SQL Server 2005 Integration Services : Working with Integration Services Packages (part 2) - Data Flow

Control flow is the new model for representing the process embodied by the package. When you open a package in the Integration Services designer, the first thing you see is the control flow design surface.

Using SQL Server 2005 Integration Services : Working with Integration Services Packages (part 1) - Control Flow

SQL Server 2005 : Extending Your Database System with Data Mining - Data Mining Applied (part 2)

Once you have designed and trained your mining models, it’s easy to display the results in a Reporting Services report. DMX, although powerful, does lack some basic query functionality that might be desirable for showing data mining results.

SQL Server 2005 : Extending Your Database System with Data Mining - Data Mining Applied (part 1)

SSAS data mining is no less programmable than OLAP, and although SSAS data mining can sometimes be more straightforward than OLAP development, for the most part the two are comparable in complexity.

# Oracle Coherence 3.5 : Achieving Performance, Scalability, and Availability Objectives (part 2)

You can scale an application up by buying a bigger server or by adding more CPUs, memory, and/or storage to the existing one. The problem with scaling up is that finding the right balance of resources is extremely difficult. You might add more CPUs only to find out that you have turned memory into a bottleneck.

# Oracle Coherence 3.5 : Achieving Performance, Scalability, and Availability Objectives (part 1)

When building a distributed system, another important factor we need to consider is network latency. The duration of every operation is the sum of the time it takes to perform the operation, and the time it takes for the request to reach the application and for the response to reach the client.

MySQL Server Monitoring (part 3) - Server Logs, Third-Party Tools & The MySQL Benchmark Suite

If you are a seasoned Linux or Unix administrator, you are familiar with the concepts and importance of logging. The MySQL server was born of this same environment. Consequently, MySQL has several logs that contain vital information about errors, events, and data changes.

MySQL Server Monitoring (part 2) - MySQL Administrator

The MySQL Administrator is a jack of all trades. It provides facilities for viewing and changing system variables, managing configuration files, examining the server logs, monitoring status variables, and even viewing graphical representations of performance for some of the more important features.

MySQL Server Monitoring (part 1) - SQL Commands

All of the SQL monitoring commands are a variant of the SHOW command, which displays internal information about the system and its subsystems.

Using MySQL Enterprise (part 3) - Query Analyzer

The Query Analyzer runs over the user-defined port 6446 (by default) and can introduce some performance delay. Thus, you should enable it only when you are searching for problems.

Using MySQL Enterprise (part 2) - Monitoring

If you create a reporting mechanism that monitors a custom application, you can create an advisor for it and add alerts to the Enterprise Dashboard. The specific details of how to add new advisors and alerts are covered in the MySQL Enterprise Monitor manual on the Enterprise subscription portal.

Using MySQL Enterprise (part 1) - Installation & Fixing Monitoring Agent Problems

There are several user accounts involved in the installation of MySQL Enterprise. Besides your Enterprise subscription account, you will also be using a MEM administrator, an agent access account to your MEM server, and an agent access account for the monitoring agent running on each MySQL server.

Getting Started with MySQL Enterprise & MySQL Enterprise Components

One of the most powerful tools available to an attacker building an XSS exploit is being able to generate requests to the target website from the victim’s browser and being able to read the responses.

Transact-SQL in SQL Server 2008 : Table-Valued Parameters

In previous versions of SQL Server, it was not possible to share the contents of table variables between stored procedures. SQL Server 2008 changes that with the introduction of table-valued parameters, which allow you to pass table variables to stored procedures as input parameters.

Transact-SQL in SQL Server 2008 : New date and time Data Types and Functions

If an existing CONVERT style includes the time part, and the conversion is from datetimeoffset to a string, the time zone offset (except for style 127) is included.

Defensive Database Programming with SQL Server : When Snapshot Isolation Breaks Code

Queries that may previously have been blocked, in lock-waiting state, under traditional isolation levels, can complete when running under the snapshot isolation levels. This feature is highly useful in many situations but, unfortunately, it may in some cases break existing code, such as triggers.