Additional Articles

All authors

Technical Article

WebService - Enabling SQL Server 2005 Procedures

One of the most interesting features that I'll explore is that you can now create WebServices in the database tier directly, without resorting to "add ons" or even the use of IIS at all. One of the many extensions to Transact SQL is the new CREATE ENDPOINT statement, which allows the developer to create an endpoint directly from SQL Server 2005, which hooks right into the Kernel Mode HTTP.SYS driver, exposing functions and stored procedures written either in T-SQL or native CLR methods/classes.

2004-11-04

3,131 reads

Technical Article

An Overview of SQL Server 2005 for the Database Developer

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

Technical Article

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

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

Technical Article

Working with Image Objects in InfoPath 2003 and SQL Server 2000

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

All authors

Blogs

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

SQL Saturday Oregon & SW Washington 2024

By

Wow I am so late in posting these notes! But this conference was amazing,...

Challenges Enterprises Face When Adopting AI

By

The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Sparse Column Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sparse Column Storage

The Managed Cloud Database Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Managed Cloud Database Options

Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 6...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers