Additional Articles

Working with Image Objects in InfoPath 2003 and SQL Server 2000

by Additional Articles

MSDN Communities

Miscellaneous

You can use features in Microsoft Office InfoPath 2003 Service Pack (SP) 1 to work more efficiently with image objects and other data. Learn how to use BLOB data types to work with data stored in a Microsoft SQL Server 2000 database from an InfoPath form. InfoPath 2003 provides a robust and rich interface to store and access data in SQL Server databases. Learn about best practices for integrating SQL Server databases and InfoPath form data, with an illustrative example.

2004-10-22

1,146 reads

Discuss

MDX Essentials: Basic Set Functions: The EXTRACT() Function

by Additional Articles

ASPToday

Analysis Services (SSAS)

This is the twenty-fourth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.

2004-10-21

1,747 reads

Discuss

Restore multiple DTS packages

by Additional Articles

Database Journal

This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box.

2004-10-20

1,987 reads

Discuss

SQL Server 2000 Security - Part 13 - SQL Injection attack

by Additional Articles

Database Journal

Security

Typically, access to data is provided via client applications, which increases the range of potential vulnerabilities and places an equal share of responsibility for data security on software developers. This is especially important since application flaws can have just as catastrophic implications as a misconfigured or unsecured SQL Server installation.

2004-10-19

2,337 reads

Discuss

Query Notifications in ADO.NET 2.0

by Additional Articles

MSDN Communities

.Net

Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes.

2004-10-18

2,668 reads

Discuss

From a Delimited String, fetching the nth Value

by Additional Articles

SQLServerCentral

T-SQL

This User defined Function will provide you the facility of fetching the nth Value from a Delimited string. The Parameter for the function which you have to pass is, the Delimited String, the Delimiter of the string, nth Position of the string. In this function , you can dynamically change the Delimiter as well as […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-15 (first published: 2004-08-04)

1,445 reads

Discuss

10 Ways to Optimize SQL Server Full-text Indexing

by Additional Articles

MSDN Communities

Indexing

Indexing performance has always been the Achilles' heel of SQL Server's full-text feature. Although the search performance itself is fast (very few customers complain about the search speed), users do complain (often loudly and frequently) about how slow the indexing process is–especially for large tables. Here's a few tips for you.

2004-10-15

2,630 reads

Discuss

Cursors with SQL 2000 Part 1

by Additional Articles

Database Journal

T-SQL

This series of articles will examine the purposes, uses, and optimization of cursors in SQL 2000.

2004-10-14

3,331 reads

Discuss

Automatically Sets Default on Columns

by Additional Articles

SQLServerCentral

Miscellaneous

If you set up a default on a column AFTER data has been entered, then this procedure will apply the default to all NULL values within that column. Limitations: It only works with numeric values right now.You will also need the INSTR function, which you can also get from this site.This is my first […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-13 (first published: 2004-07-22)

102 reads

Discuss

Architecting Disconnected Mobile Applications Using a Service Oriented

by Additional Articles

ASPToday

Miscellaneous

The Windows Mobile platform, which includes Microsoft .NET Compact Framework and Microsoft SQL Server CE, encapsulates the complex tasks of communication management and data exchange while your device is in a disconnected state. (16 printed pages)

2004-10-13

1,690 reads

Discuss

All authors

Additional Articles

Working with Image Objects in InfoPath 2003 and SQL Server 2000

MDX Essentials: Basic Set Functions: The EXTRACT() Function

Restore multiple DTS packages

SQL Server 2000 Security - Part 13 - SQL Injection attack

Query Notifications in ADO.NET 2.0

From a Delimited String, fetching the nth Value

10 Ways to Optimize SQL Server Full-text Indexing

Cursors with SQL 2000 Part 1

Automatically Sets Default on Columns

Architecting Disconnected Mobile Applications Using a Service Oriented

Blogs

Are you getting value from your reporting?

The Book of Redgate: SQL Server Central

Git forked

Forums

Microsoft Security Changes and SQL Server

Expanding into Print

Downtime Caused by the Postgres Transaction ID Wraparound Problem

Question of the Day

The String Distance I