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.

Versioning

by Andre Vigneau

SQLServerCentral.com

Miscellaneous

How many times has an application exploded because you upgraded or patched SQL Server? How many people were aware that a patch was applied? New author Andre Vigneau has dealt with this and gives us some code that our applications can use to check to see if anything has changed. It doesn't keep the code working, but it does allow you to inform users that something has changed.

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.

Review - dbMaestro

by Dinesh Asanka

SQLServerCentral.com

Product and Book Reviews

Version control in SQL Server is fairly immature, to put it nicely. Fortunately it's also an area that a number of vendors are working to make smoother. Dinesh Asanka looks at dbMaestro, a tool from Extreme Technologies to help you track changes in multiple databases.

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.

Implementing a Flexible Backup Strategy

by Eli Leiba

SQLServerCentral.com

Backup and restore

SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.

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.

Custom String Functions

by Chris Cathers

SQLServerCentral.com

Advanced Querying

SQL Server's Data Transformation Services (DTS) is a fantastic tool for importing data from any type of source. However even with this tool, you sometimes need more flexibility than it appears to have, especially if the data formats are unknown far enough in advance. New author Chris Cathers has developed a technique that allows him to be extremely flexible without causing too many headaches down the road.

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.

Duplicate Key Inserted Error During Replication

by Andy Warren

SQLServerCentral.com

Replication

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.

Working with Image Objects in InfoPath 2003 and SQL Server 2000

Versioning

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

Review - dbMaestro

Restore multiple DTS packages

Implementing a Flexible Backup Strategy

SQL Server 2000 Security - Part 13 - SQL Injection attack

Custom String Functions

Query Notifications in ADO.NET 2.0

Duplicate Key Inserted Error During Replication

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

Flying Halfway Around the World to Australia

Dealing with Change – Two Resources

Forums

SSIS Execution Error

Pivot query

Table with FK(s) to other columns within the table

Question of the Day

Using Table Hints in a Query