Additional Articles

All authors

List Server Extended Properties

by Additional Articles

SQLServerCentral

Replication

Simply lists all server extended properties.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-11-05 (first published: 2004-08-08)

1,699 reads

Discuss

SQL Server 2005 Partitioned Tables and Indexes

by Additional Articles

Other

Development

Although partitioning tables and indexes has always been a design tactic chosen to improve performance and manageability in larger databases, Microsoft SQL Server 2005 has new features that simplify the design. This whitepaper describes the logical progression from manually partitioning data by creating your own tables to the preliminary features, which enabled partitioning through views in SQL Server 7.0 and SQL Server 2000, to the true partitioned table features available in SQL Server 2005. In SQL Server 2005, the new table-based partitioning features significantly simplify design and administration of partitioned tables while continuing to improve performance.

2004-11-05

3,625 reads

Discuss

WebService - Enabling SQL Server 2005 Procedures

by Additional Articles

Other

.Net

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

Discuss

XML Support in Microsoft SQL Server 2005

by Additional Articles

MSDN Communities

Development

This article discusses the XML support built into SQL Server 2005. It shows how this support integrates with the client side programming support in the .NET Framework V2.0 and in native code such as OLEDB and SQLXML.

2004-11-03

1,352 reads

Discuss

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