Additional Articles

An Overview of SQL Server 2005 for the Database Developer

by Additional Articles

MSDN Communities

Development

With the release of Microsoft SQL Server 2005 Beta 2, the world of database development is changing. As a database developer, you now have the option to appropriately locate your code in relation to its functionality, to access data in native formats such as XML, and to build complex systems that are driven by the power of the database server. Database development is becoming more integrated than ever before, and all of the tools that you need are available right at your fingertips.

2004-11-02

3,856 reads

Discuss

Writing Managed Stored Procedures in SQL Server 2005

by Additional Articles

DevX

.Net

Are you tired of struggling with T-SQL to encapsulate the logic your applications need to get data into and out of SQL Server? Now you can bypass SQL altogether, and write logic that runs directly within SQL Server in your favorite .NET language.

2004-11-01

4,360 reads

Discuss

SQL Server 2005 Hands-On Labs

by Additional Articles

MSDN Communities

Development

Manuals for all SQL Server 2005 hands-on labs are now available for download. See the Hands-On Labs Manuals section of this page for links

2004-10-29

3,935 reads

Discuss

Securing Your SQL Server 2005 Express Edition Server

by Additional Articles

MSDN Communities

Get introduced to SQL Server Express, learn how to install and configure it in a secure manner, plus get information on the basics of SQL Server security.

2004-10-28

1,125 reads

Discuss

Work with XML Data Type in SQL Server 2005 from ADO.NET 2.0

by Additional Articles

Other

Development

One of the excellent features of the next release of SQL Server, known as SQL Server 2005, is its deep XML integration with the SQL Server database engine. This integration goes well beyond the simple relational-to-XML mapping layer that SQL Server 2000 provided. SQL Server 2005 will feature a native XML data type that will allow you to store native XML data in SQL Server itself.

2004-10-25

2,377 reads

Discuss

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